Financial Report Template Editor

Done all the setups as per the note (Report Manager - Master Note[Article ID 726774.1].

On R12.1.3 , while trying to go to Report Manager responsibility > Financial Report Template Editor

You have encountered an unexpected error. Please contact the System Administrator for assistance.

====================

 

Error Page

Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NAME REPORT_NAME, REPORT_ID, ROW_SET_ID, COLUMN_SET_ID, CONTENT_SET_ID, ROW_ORDER_ID, REPORT_DISPLAY_SET_ID, PARAMETER_SET_ID, MINIMUM_DISPLAY_LEVEL, PERIOD_SET_NAME, UNIT_OF_MEASURE_ID, SEGMENT_OVERRIDE, ROUNDING_OPTION, OUTPUT_OPTION, (SELECT NAME FROM RG_REPORT_AXIS_SETS WHERE AXIS_SET_ID = ROW_SET_ID) AS ROW_SET_NAME, (SELECT NAME FROM RG_REPORT_AXIS_SETS WHERE AXIS_SET_ID = COLUMN_SET_ID) AS COLUMN_SET_NAME, OVERRIDE_ALC_LEDGER_CURRENCY FROM RG_REPORTS, RG_LOOKUPS WHERE APPLICATION_ID in (101, 168) AND NVL(STRUCTURE_ID, :0) = :1 AND LOOKUP_TYPE = 'FSG_ADHOC_REPORT_NAME_PREFIX' AND LOOKUP_CODE = 'ADHOC_PREFIX' AND NAME NOT LIKE MEANING ||