My Oracle Support Banner

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

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


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