My Oracle Support Banner

R12.1 - Performance Slow With Third Party Balances Report "XLATPRPT" (Doc ID 1275098.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version: 12.1.2 and later   [Release: 12.1 and later ]
Oracle Subledger Accounting - Version: 12.1.1 to 12.1.3   [Release: 12.1 to 12.1]
Information in this document applies to any platform.

Symptoms


The Third Party Balances Report takings too long time (9 hours) to finish .


Changes


Need an index on columns code_combination_id, ledger_id ,accounting_date on
xla_ae_lines to improve the performance of Third Party Balances Report
and
changes in the hint for the report sql


Index XLA_AE_LINES_N5 has been created on columns code_combination_id,
ledger_id , accounting_date on xla_ae_lines , this improves theperformance of
Third Party Balances Report and modified the hint in the report sql


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!


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