AGIS FUNRCNRPT Intercompany Reconciliation Data Extract Program Has Poor Performance
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
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' ) */
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"
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