R12 AP: Invoice Validation Performance And Excessive Huge Archive Log Generation
(Doc ID 1339345.1)
Last updated on JULY 10, 2020
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
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