KentW Limited

Category: Functional Knowledge

  • Oracle E-Business Tax and Brexit

    As the United Kingdom (UK) leaves the EU from the 1/1-2021; E-Business Tax (ZX/EBTax) setup will require changes. Disclaimer and warning: EBTax setup is complex and flexible therefore the example below is unlikely to work with your instance, so please do use a skilled consultant for the changes and test carefully. All the examples below […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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 […]

  • R12 – XML Publisher – XDO

    Back to R12 – Upgrade Overview Placeholder for XML Publisher

  • 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 […]