Budgetary Control and Funds Checking Notes

Overview Modules supporting budgetary control: General Ledger Payables Purchasing Inventory Projects Limitations: Budgetary control is only available for the primary ledger functional entered currency Budgetary control requires the use of encumbrance or budgetary accounting Funds checking levels: Detail budgetary control: budget per code combination assigned at budget organization range level Summary budgetary control: budget by […]

Posted in: Functional Knowledge, General Ledger by Kent Willumsen Comments Off on Budgetary Control and Funds Checking Notes , , ,

Interface Strategy – a Functional Approach

Interfaces are mostly assumed being a technical exercise however been on the receiving end of that there is several shortcomings to this approach. When interfacing two systems the transactional flow can become quite complex in terms of functional interaction – an interaction, which is beyond what most technical people can contemplate. Just imagine how to […]

Posted in: Functional Knowledge, Interfaces, Technical Knowledge by Kent Willumsen Comments Off on Interface Strategy – a Functional Approach ,

R12.2.x Functional Issues and Major Bugs

Trying to collect the major non-technical R12.2.x issues and bugs in a single note… UPDATE 2014-03-26: R12.3 seems to be on the way; its referred to in many notes on Metalink so bugs below might not get fixed until then. Topics covered in this note: Flexfield Value Set Security: Enabled by Default Report Manager Excel […]

Posted in: Functional Knowledge, New Features by Kent Willumsen Comments Off on R12.2.x Functional Issues and Major Bugs , ,

R12.2.2 Financials New Features

R12.2.2 enhancements compared to R12.1.3… This is an excerpt with highlights from Metalink document id: 1302189.1 For: Financials Projects Flexfields E-Business Tax Customer Tax Information Import: Customer interface program now supports the following: Party Tax Profile Tax Registrations Exemptions Reporting Code Association New condition set operators: Used to be available in R12.1.3 as a patch […]

Posted in: E-Business Tax, Functional Knowledge, General Ledger, New Features, Payments, Receivables by Kent Willumsen Comments Off on R12.2.2 Financials New Features , , , , ,

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 , ,

Data Migration Strategy – a Functional Approach

Having been on a few projects now where the data migration was treated as a technical exercise and felt the impact of this – now it’s time to describe the data migration from a functional perspective. Data migration strategy also called data conversion strategy is the basis for this. Focusing on the functional perspective helps […]

Posted in: Data Migration, Functional Knowledge, Technical Knowledge by Kent Willumsen Comments Off on Data Migration Strategy – a Functional Approach , ,

GL Chart of Accounts – Number of Segments

How many segments in my Chart of Accounts (COA) are needed for my business? There are many considerations and this article will only focus on the number of segments rather than the segment values which will be handled in a later post. Some of the considerations are: Oracle System requirements Legal reporting requirements Financial management […]

Posted in: Functional Knowledge, General Ledger by Kent Willumsen Comments Off on GL Chart of Accounts – Number of Segments ,

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 , ,