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.


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


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
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


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.