oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID , OTA_RESOURCE_DEFINITIONS.SEGMENT1 FLEX_DISPLAY0 , FLEX_T1_0.MEANING FLEX_DISPLAY1 , fnd_flex_server.get_concatenated_value( , :SEGMENT_COUNT , OTA_RESOURCE_DEFINITIONS.SEGMENT1 , FLEX_T1_0.MEANING ) FLEX_CONCATENATED_DISPLAY FROM OTA_RESOURCE_DEFINITIONS , FND_COMMON_LOOKUPS FLEX_T1_0 WHERE (OTA_RESOURCE_DEFINITIONS.enabled_flag = 'Y' and nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate)) between nvl(trunc(OTA_RESOURCE_DEFINITIONS.start_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))) and nvl(trunc(OTA_RESOURCE_DEFINITIONS.end_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))) and OTA_RESOURCE_DEFINITIONS.ID_FLEX_NUM = :STRUCTURE and 1 = 1 and 1 = 1 and OTA_RESOURCE_DEFINITIONS.SEGMENT2 = FLEX_T1_0.LOOKUP_CODE and ( LOOKUP_TYPE='MOSTAFA_TRAINER_CLASSIFICATION' AND ENABLED_FLAG = 'Y') and OTA_RESOURCE_DEFINITIONS.SEGMENT1 like :FLEX_QUERY_VALUE0 and FLEX_T1_0.MEANING like :FLEX_QUERY_VALUE1) ORDER BY FLEX_DISPLAY0 , FLEX_DISPLAY1

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1658

Stack trace

  • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID , OTA_RESOURCE_DEFINITIONS.SEGMENT1 FLEX_DISPLAY0 , FLEX_T1_0.MEANING FLEX_DISPLAY1 , fnd_flex_server.get_concatenated_value( , :SEGMENT_COUNT , OTA_RESOURCE_DEFINITIONS.SEGMENT1 , FLEX_T1_0.MEANING ) FLEX_CONCATENATED_DISPLAY FROM OTA_RESOURCE_DEFINITIONS , FND_COMMON_LOOKUPS FLEX_T1_0 WHERE (OTA_RESOURCE_DEFINITIONS.enabled_flag = 'Y' and nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate)) between nvl(trunc(OTA_RESOURCE_DEFINITIONS.start_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))) and nvl(trunc(OTA_RESOURCE_DEFINITIONS.end_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))) and OTA_RESOURCE_DEFINITIONS.ID_FLEX_NUM = :STRUCTURE and 1 = 1 and 1 = 1 and OTA_RESOURCE_DEFINITIONS.SEGMENT2 = FLEX_T1_0.LOOKUP_CODE and ( LOOKUP_TYPE='MOSTAFA_TRAINER_CLASSIFICATION' AND ENABLED_FLAG = 'Y') and OTA_RESOURCE_DEFINITIONS.SEGMENT1 like :FLEX_QUERY_VALUE0 and FLEX_T1_0.MEANING like :FLEX_QUERY_VALUE1) ORDER BY FLEX_DISPLAY0 , FLEX_DISPLAY1 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
14 more bugmates