Open Account Balances Data Manager (XLATBDMG) / Accounts Payable Trial Balance (APTBRPT) Performance Issue in R12 (Doc ID 1138764.1)

Last updated on DECEMBER 13, 2013

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Open Account Balances Data Manager (XLATBDMG) / Accounts Payable Trial Balance (APTBRPT) Performance Issue in R12
***Checked for relevance on 09-Jul-2013***

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

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