R12:XLA:Open Account Balances Data Manager (XLATBDMG) / Accounts Payable Trial Balance (APTBRPT) Performance Issue in R12
(Doc ID 1138764.1)
Last updated on APRIL 24, 2024
Applies to:
Oracle Payables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]Information in this document applies to any platform.
Open Account Balances Data Manager (XLATBDMG) / Accounts Payable Trial Balance (APTBRPT) Performance Issue in R12
Symptoms
The "Accounts Payable Trial Balance" / "Open Account Balances Data Manager" report is experiencing severe performance issues.
It is taking too long to run the rebuild. It took more than 8 hours.
BEGIN XLA_TB_DATA_MANAGER_PVT.UPLOAD(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4,:A5,:A6,
:A7,:A8); END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 59.99 19373.82 265335 409184 227721 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ------
total 2 60.00 19373.82 265335 409184 227721 1
INSERT INTO xla_trial_balances xtb(
record_type_code
,source_entity_id
,event_class_code
,source_application_id
,applied_to_entity_id
,applied_to_application_id
,gl_date
,trx_currency_code
,entered_rounded_dr
,entered_rounded_cr
,entered_unrounded_dr
...
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 732 412.10 18516.60 2325513 14748536 2805289 740262
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 733 412.10 18516.60 2325513 14748536 2805289 740262
Changes
Increasing data volume.
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 |