Error while drilling down the report created through Report Manager.
I'm facing an error while drilling down the report created through Report Manager. Below is the error which I'm receiving while double clicking on the amount in the report exported to Excel from Report Manager.
Any help is appreciated.
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FLEX_VALUE DRILL_FLEX_VALUE, ENABLED_FLAG DRILL_ENABLED_FLAG, START_DATE_ACTIVE DRILL_START_DATE, END_DATE_ACTIVE DRILL_END_DATE, SUMMARY_FLAG DRILL_SUMMARY_FLAG FROM FND_FLEX_VALUES WHERE FLEX_VALUE_SET_ID = :1) QRSLT WHERE (AND DRILL_ENABLED_FLAG = :2 AND SYSDATE BETWEEN NVL(DRILL_START_DATE, SYSDATE) AND NVL(DRILL_END_DATE, SYSDATE) AND DRILL_SUMMARY_FLAG = :3AND (NOT EXISTS ( SELECT M.ERROR_MESSAGE FROM FND_FLEX_VALUE_RULE_USAGES U, FND_FLEX_VALUE_RULES_VL M WHERE U.FLEX_VALUE_RULE_ID = M.FLEX_VALUE_RULE_ID AND U.APPLICATION_ID = :4 AND U.RESPONSIBILITY_ID = :5 AND U.FLEX_VALUE_SET_ID = :6 AND (EXISTS (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L WHERE (DRILL_FLEX_VALUE BETWEEN NVL(L.FLEX_VALUE_LOW, DRILL_FLEX_VALUE) AND NVL(L.FLEX_VALUE_HIGH, DRILL_FLEX_VALUE)) AND L.FLEX_VALUE_RULE_ID = U.FLEX_VALUE_RULE_ID AND L.INCLUDE_EXCLUDE_INDICATOR = 'E') OR NOT EXISTS (SELECT NULL