My Oracle Support Banner

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

Last updated on JANUARY 03, 2023

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

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.