R12 AP: Invoice Validation Performance And Excessive Huge Archive Log Generation (Doc ID 1339345.1)

Last updated on AUGUST 30, 2016

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***

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

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