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

Last updated on AUGUST 30, 2016

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

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