AGIS FUNRCNRPT Intercompany Reconciliation Data Extract Program Has Poor Performance (Doc ID 1455288.1)

Last updated on NOVEMBER 21, 2016

Applies to:

Oracle General Ledger - Version 12.1.1 and later
Oracle Financials Common Modules - Version 12.1.1 and later
Information in this document applies to any platform.
ConcurrentProgram:FUNRCNRPT - Intercompany Reconciliation Data Extract Program

Symptoms

The "Intercompany Reconciliation Data Extract Program" runs for almost 5 hours.

AWR is showing the most expensive statement is:

SELECT /*+ leading(fia, ael) cardinality(fia,1) opt_param('_optimizer_cost_based_transformation','off' ) */
glv.legal_entity_id TRANS_LE_ID
,glv.LEGAL_ENTITY_NAME TRANS_LE
,fia.to_le_id TRAD_LE_ID
,fun_recon_rpt_pkg.get_legal_entity(fia.to_le_Id) TRAD_LE
,glv.ledger_name TRANSACTING_LEDGER
,glv.ledger_id LEDGER_ID

..................................

Explain plan of the above statement is showing that there is a TABLE ACCESS FULL on GL_JE_HEADERS.

The issue can be reproduced at will with the following steps:
1. Log in to Inter company super user Responsibility
2. Run the report "Intercompany Reconciliation Data Extract Program"

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