R12 AP: Invoice Validation Performance And Excessive Huge Archive Log Generation
(Doc ID 1339345.1)
Last updated on FEBRUARY 01, 2022
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation 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
Symptoms
On : 12.1.3 version, Other-MiscIss & KeyIndReport
After Upgrade to R12.1.3 invoice validation too slow & Generate Huge Archive Log
Changes
Balances are not maintained for encumbrance journals. So, it is
unnecessary to call balances API when the g_budgetary_control_mode is
'FUNDS_RESERVE','FUNDS_CHECK'
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |