My Oracle Support Banner

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

Last updated on MAY 03, 2023

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

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

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.