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


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