R12 AP: Create Accounting Performance Issue (xla_accounting_pkg.unit_processor_batch)

(Doc ID 1136906.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Payables - Version 12.0.3 and later
Information in this document applies to any platform.
XLA_ACCOUNTING_PKG xlaapeng.pkb 120.147.12000000.39
XLA_ACCOUNTING_PKG xlaapeng.pkh 120.18.12000000.1
***Checked for relevance on 11-Dec-2015***

Symptoms

Performance problem:

AP create accounting concurrent is running for 4 days and not completed.

BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4,
:A5,:A6,:A7,:A8,:A9,:A10,:A11,:A12,:A13,:A14); END;


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 1106.20 3912.16 831013 70301012 73819012 2
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 1106.20 3912.16 831013 70301012 73819012 2

Changes

None

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