General Ledger - EBS (MOSC)

MOSC Banner

Error while drilling down the report created through Report Manager.

edited Mar 7, 2012 3:55AM in General Ledger - EBS (MOSC) 2 comments
Hello Everyone,

           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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center