FSG Drilldown Error: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FLEX_VALUE (Doc ID 1678876.1)

Last updated on FEBRUARY 25, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

11.5.10.2

ISSUE:
------------
When drilling down from an FSG on a parent account, from a Set of Books that has a special character in the name of the book, an error is received:

ERROR
------------
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 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 = 'I')))))


STEPS
-----------
1. Publish an FSG
2. View the output
3. Click on a cell with a parent account.
 

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