R12 AP: Invoice Validation Performance And Excessive Huge Archive Log Generation
Last updated on JANUARY 16, 2018
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
This patch also fixes the issue of growing records in xla.xla_bal_concurrency_control table. Before this patch, the invoice validation creates a number of records in this table causing performance issues.
After this patch the balances calculation will not be a part of the invoices validation process and this table should no longer be accessed from invoice validation. So a purge on xla.xla_bal_concurrency_control will not be required
***Checked for relevance on 18-Dec-2015***
On : 12.1.3 version, Other-MiscIss & KeyIndReport
After Upgrade to R12.1.3 invoice validation too slow & Generate Huge Archive Log
Balances are not maintained for encumbrance journals. So, it is
unnecessary to call balances API when the g_budgetary_control_mode is
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms