Functional Currency and Ledger Currency

How do we determine what currencies to use for our ledgers? Accounting regulations like FASB52 and IAS21 (see regulatory limitations below for details) does not put many limitations on us. Neither does the Oracle R12 ledger setup – at least not evidently according to the FCG (see references section below for acronyms). FASB52 and IAS21 […]

Posted in: Functional Knowledge, General Ledger by Kent Willumsen Comments Off on Functional Currency and Ledger Currency , ,

R12 FND User password lock down

When making your R12 server available on-line you need to protect your FND user password. This assumes that you have ONLY opened port 8000 for APPS login access. For any other access I can only recommend to use VPN as a full OEL and RDBMS lock down is very complex. I used the following script […]

Posted in: R12 Installation, Technical Knowledge by Kent Willumsen Comments Off on R12 FND User password lock down ,

R12 on a HTPC

Want to access your R12 installation from a client site? No problem – pick up the R12 installation described earlier and install the hard disk in a HTPC! For the purpose I bought a Acer AspireRevo R3700 with the following relevant specifications: Processor Intel® Atom D525 processor 1.8GHz Memory 2GB DDR3 800MHz Graphics NVIDIA ION […]

Posted in: R12 Installation, Technical Knowledge by Kent Willumsen Comments Off on R12 on a HTPC ,

R12 – XML Publisher – XDO

Back to R12 – Upgrade Overview Placeholder for XML Publisher

Posted in: Functional Knowledge, XML Publisher by Kent Willumsen Comments Off on R12 – XML Publisher – XDO ,

R12 – MOAC Security

Multiple Organizations Access Control (MOAC) security give the possibility of querying or seeing transactions of one or more Operating Units (OU) without changing responsibility. In 11i we were securing transactions by Operating Unit (OU) only and we would have to choose a corresponding responsibility to see the transactions: OU1 – Receivables Manager OU2 – Receivables […]

Posted in: Functional Knowledge, Security by Kent Willumsen Comments Off on R12 – MOAC Security ,

R12 – Territory Manager – JTY

Back to R12 – Upgrade Overview In 11i we assign collectors using the profile options and optionally manually override this at account level if needed. This gets rather hard to manage in large departments especially when people leaves or joins. However in R12 you have the ability to use Territory Manager which originally is a […]

Posted in: Functional Knowledge, Territory Manager by Kent Willumsen Comments Off on R12 – Territory Manager – JTY , ,

R12 on two Laptops

So we have installed R12 on a external USB hard disk according to my instructions but now we want more performance and flexibility? You can either run out and buy a huge server and re-install on that or try to use two laptops instead of one? Equipment used: Router – Draytek 2820 Laptop 1 – […]

Posted in: R12 Installation, Technical Knowledge by Kent Willumsen Comments Off on R12 on two Laptops ,

R12 – Advanced Collections – IEX

Back to R12 – Upgrade Overview This article will however not provide a full overview of IEX but only explain some of the basics to get you started with IEX after moving to R12. Beyond that – dig into the manual. News Bulk XML Delivery per default in R12.1.2 Staged Dunning to be introduced (again) […]

Posted in: Advanced Collections, Functional Knowledge by Kent Willumsen Comments Off on R12 – Advanced Collections – IEX , ,

R12 – General Ledger – GL

Back to R12 – Upgrade Overview Overview In GL there has been a number of changes: Terminology Changes Set of Books (SOB) is now Ledgers Multiple Reporting Currencies (MRC) is now Reporting Currencies Global Intercompany System (GIS) is now Advanced Global Intercompany System (AGIS) Obsolete Global Accounting Engine (AX) replaced by Subledger Accounting MRC as […]

Posted in: Functional Knowledge, General Ledger by Kent Willumsen Comments Off on R12 – General Ledger – GL , ,

R12 – Receivables – AR

Back to R12 – Upgrade Overview AR are now fully support new modules like E-Business Tax and Subledger Accounting. Overview: Integration with E-Business Tax Integration with Subledger Accounting Centralized Banks and Bank Accounts Definitions Integration with Payments for Funds Capture Balance Forward Billing Late Charges Enhancements Customer UI Redesign Process Changes Integration with E-Business Tax […]

Posted in: Functional Knowledge, Receivables by Kent Willumsen Comments Off on R12 – Receivables – AR , ,