My Oracle Support Banner

OBIA 7.9.6.3 Support For R12 SLA Accounts For Accounts Payable (Doc ID 1439159.1)

Last updated on OCTOBER 01, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Goal


Implementing OBIA 7.9.6.3 with EBS R12 as source. Need to use GL Account from XLA tables not AP Invoice distribution. Is this already supported by OOTB BI Apps?

We are in process of implementing 7.9.6.3 with R12 as source. Oracle R12 has sub-ledger accounting  module. This is a new feature and module that allows accounting rules for each sub-ledger. When this module is setup for a sub-ledger (for example Accounts Payables) , SLA module generates accounting entries that will match Oracle GL.  So to comply with Oracle R12 SLA functionality OBIA pre-built mapping should have sourced account and amount from XLA_AE_LINES tables instead of AP table   AP_INVOICE_DISRIBUTIONS_ALL (as in this case accounting information in AP_INVOICE_DISTRIBUTIONS_ALL has been overridden by SLA)

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.