oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID, StructureEO.ARTICLE_VERSION_ID, StructureEO.DISPLAY_SEQ, StructureEO.LABEL, StructureEO.OBJ_TYPE, StructureEO.DOC_ID, StructureEO.DOC_TYPE, StructureEO.MANDATORY_YN, StructureEO.ALTERNATE_YN, StructureEO.STANDARD_YN, StructureEO.ARTICLE_FROM_EXPERT, StructureEO.OBJECT_VERSION_NUMBER, ' '||StructureEO.LABEL||' '||StructureEO.NAME DISPLAY, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'OkcTermsStructDtlsMandatoryEnabled', 'OkcTermsStructDtlsMandatoryDisabled') MANDATORY_CHECKBOX, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', DECODE(StructureEO.MANDATORY_YN, 'Y', 'OkcTermsStructDtlsMandatory', 'OkcTermsStructDtlsNotMandatory'), 'OkcTermsStructDtlsNotMandatory') MANDATORY_IMAGE, DECODE(StructureEO.ALTERNATE_YN, 'Y', 'OkcTermsStructDtlsAlternatesEnabled', 'N', 'OkcTermsStructDtlsAlternatesNotApplied', 'OkcTermsStructDtlsAlternatesNotApplied') ALTERNATES_IMAGE, okc_terms_util_grp.enable_update( StructureEO.OBJ_TYPE, StructureEO.DOC_TYPE, StructureEO.STANDARD_YN) UPDATE_IMAGE, okc_terms_util_grp.enable_delete( StructureEO.OBJ_TYPE, StructureEO.MANDATORY_YN, StructureEO.STANDARD_YN, StructureEO.DOC_TYPE) REMOVE_IMAGE, DECODE(StructureEO.STANDARD_YN, 'N', 'OkcTermsStructDtlsNonStandard', 'OkcTermsStructDtlsNotApplied') NON_STD_IMAGE, DECODE(StructureEO.ARTICLE_FROM_EXPERT, 'Y', 'OkcTermsStructDtlsFromExpert', 'OkcTermsStructDtlsNotFromExpert') EXPERT_IMAGE, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'tree_document.gif', 'SECTION', NULL, --'folder.gif' 'tree_contract.gif') TREE_ICON, NULL DETAILS_URL, XXLC_LOCK_TEXT(StructureEO.article_id,StructureEO.article_version_id) Unprotected FROM OKC_TERMS_STRUCTURE_V StructureEO WHERE StructureEO.DOC_ID = :1 AND StructureEO.DOC_TYPE = :2 AND ((StructureEO.OBJ_TYPE = 'ARTICLE' AND StructureEO.ARTICLE_VERSION_ID IS NOT NULL) OR (StructureEO.OBJ_TYPE <> 'ARTICLE'))) QRSLT WHERE (:3 = PARENT_ID) AND (:4 = PARENT_OBJ_TYPE) ORDER BY DISPLAY_SEQ

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by Veejay, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID
via Oracle Community by 797277, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT bp.vendor_site_id, (bp.vendor_site_code || ' - ' || ps.ADDRESS_LINE1 || DECODE (ps.ADDRESS_LINE1,NULL,NULL,', ') || ps.ADDRESS_LINE2 || DECODE
via Oracle Community by 818948, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT GANTT_VIEW_ID ,NAME FROM PA_GANTT_VIEWS_VL where ENABLE_FLAG ='Y' and GANTT_VIEW_USAGE = ?
via Oracle Community by 775215, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name
via Oracle Community by user539616, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name
via Oracle Community by sreese, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct meaning , attribute4 from splwms.so_lookups where lookup_type = 'SHIPMENT_PRIORITY' and enabled_flag = 'Y' and attribute4 = :Carrier order by meaning
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID, StructureEO.ARTICLE_VERSION_ID, StructureEO.DISPLAY_SEQ, StructureEO.LABEL, StructureEO.OBJ_TYPE, StructureEO.DOC_ID, StructureEO.DOC_TYPE, StructureEO.MANDATORY_YN, StructureEO.ALTERNATE_YN, StructureEO.STANDARD_YN, StructureEO.ARTICLE_FROM_EXPERT, StructureEO.OBJECT_VERSION_NUMBER, ' '||StructureEO.LABEL||' '||StructureEO.NAME DISPLAY, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'OkcTermsStructDtlsMandatoryEnabled', 'OkcTermsStructDtlsMandatoryDisabled') MANDATORY_CHECKBOX, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', DECODE(StructureEO.MANDATORY_YN, 'Y', 'OkcTermsStructDtlsMandatory', 'OkcTermsStructDtlsNotMandatory'), 'OkcTermsStructDtlsNotMandatory') MANDATORY_IMAGE, DECODE(StructureEO.ALTERNATE_YN, 'Y', 'OkcTermsStructDtlsAlternatesEnabled', 'N', 'OkcTermsStructDtlsAlternatesNotApplied', 'OkcTermsStructDtlsAlternatesNotApplied') ALTERNATES_IMAGE, okc_terms_util_grp.enable_update( StructureEO.OBJ_TYPE, StructureEO.DOC_TYPE, StructureEO.STANDARD_YN) UPDATE_IMAGE, okc_terms_util_grp.enable_delete( StructureEO.OBJ_TYPE, StructureEO.MANDATORY_YN, StructureEO.STANDARD_YN, StructureEO.DOC_TYPE) REMOVE_IMAGE, DECODE(StructureEO.STANDARD_YN, 'N', 'OkcTermsStructDtlsNonStandard', 'OkcTermsStructDtlsNotApplied') NON_STD_IMAGE, DECODE(StructureEO.ARTICLE_FROM_EXPERT, 'Y', 'OkcTermsStructDtlsFromExpert', 'OkcTermsStructDtlsNotFromExpert') EXPERT_IMAGE, DECODE(StructureEO.OBJ_TYPE, 'ARTICLE', 'tree_document.gif', 'SECTION', NULL, --'folder.gif' 'tree_contract.gif') TREE_ICON, NULL DETAILS_URL, XXLC_LOCK_TEXT(StructureEO.article_id,StructureEO.article_version_id) Unprotected FROM OKC_TERMS_STRUCTURE_V StructureEO WHERE StructureEO.DOC_ID = :1 AND StructureEO.DOC_TYPE = :2 AND ((StructureEO.OBJ_TYPE = 'ARTICLE' AND StructureEO.ARTICLE_VERSION_ID IS NOT NULL) OR (StructureEO.OBJ_TYPE <> 'ARTICLE'))) QRSLT WHERE (:3 = PARENT_ID) AND (:4 = PARENT_OBJ_TYPE) ORDER BY DISPLAY_SEQ
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3136)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2931)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.