R12:FSG Drilldown: Error Has Occurred On The Drilldown. No Row Could Be Found in the FRM Repository For Repository Id. (Doc ID 1503147.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Report Manager - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

12.1.3, FSG Drilldown

Issue:
-----------
FSG reports run and publish properly but drilldown from any amounts fails.
The following error is returned:
  An error has occurred on the drilldown. Please contact your system administrator.

FND log messages show:
retrieveFsgInformationFromReportManager: No row could be found in the FRM repository for repository id
retrieveFsgInformationFromReportManager: An exception occurred during the FSG XML Parsing
"oracle.apps.fnd.framework.OAException: Application: SQLGL, Message Name:  GL_FSG_DRL_ERR_ERROR.
at oracle.apps.gl.drilldown.fsg.server.DrillAMImpl.retrieveFsgInformationFromReportManager(DrillAMImpl.java:1789)
...

Steps to recreate:
---------------------
1. Run an FSG from Report Manager
2. View the Excel output
3. Try to drill down on an amount

 

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