oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT a.TEMPLATE_ID, a.TEMPLATE_NAME, a.WORKING_COPY_FLAG, a.INTENT, a.STATUS_CODE, a.START_DATE, a.END_DATE, a.GLOBAL_FLAG, a.PARENT_TEMPLATE_ID, a.CONTRACT_EXPERT_ENABLED, a.TEMPLATE_MODEL_ID, a.INSTRUCTION_TEXT, a.TMPL_NUMBERING_SCHEME, a.Print_Template_Id, a.DESCRIPTION, a.LAST_UPDATE_LOGIN, a.CREATION_DATE, a.CREATED_BY, a.LAST_UPDATED_BY, a.LAST_UPDATE_DATE, a.OBJECT_VERSION_NUMBER, a.ATTRIBUTE_CATEGORY, a.ATTRIBUTE1, a.ATTRIBUTE2, a.ATTRIBUTE3, a.ATTRIBUTE4, a.ATTRIBUTE5, a.ATTRIBUTE6, a.ATTRIBUTE7, a.ATTRIBUTE8, a.ATTRIBUTE9, a.ATTRIBUTE10, a.ATTRIBUTE11, a.ATTRIBUTE12, a.ATTRIBUTE13, a.ATTRIBUTE14, a.ATTRIBUTE15, b.document_type, a.org_id, DECODE(a.CONTRACT_EXPERT_ENABLED, 'Y', 'ExpertEnabled', 'NotExpertEnabled') EXPERT_IMAGE, fnd_lang.description language_description FROM OKC_TERMS_TEMPLATES_ALL a , OKC_ALLOWED_TMPL_USAGES b , PA_PROJECTS_ALL c , PA_PROJECT_PLAYERS d , FND_USER e , FND_LANGUAGES_VL fnd_lang WHERE a.template_id = b.template_id AND a.attribute1 = c.project_id AND d.project_id = c.project_id AND d.person_id = e.employee_id AND e.user_id = FND_PROFILE.VALUE('USER_ID') AND a.status_code = 'APPROVED' AND a.language = fnd_lang.language_code(+)) QRSLT WHERE (DOCUMENT_TYPE = :1 AND ORG_ID = :2 AND :3 between start_date and nvl(end_date, :4 ) AND ( UPPER(TEMPLATE_NAME) like UPPER(:5) AND (TEMPLATE_NAME like :6 OR TEMPLATE_NAME like :7 OR TEMPLATE_NAME like :8 OR TEMPLATE_NAME like :9)))

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

Solutions on the web

via Oracle Community by 795088, 1 year ago
, b.document_type, a.org_id, DECODE(a.CONTRACT_EXPERT_ENABLED, 'Y', 'ExpertEnabled', 'NotExpertEnabled') EXPERT_IMAGE, fnd_lang.description language_description FROM OKC_TERMS_TEMPLATES_ALL a , OKC_ALLOWED_TMPL_USAGES b , PA_PROJECTS_ALL c , PA_PROJECT_PLAYERS d
via Oracle Community by 868733, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select customer_id from XXCUR_TRADE_CONSOL_SUMMARY
via Oracle Community by 784264, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT organization_id,name FROM hr_organization_units where COST_ALLOCATION_KEYFLEX_ID in(SELECT pcak.COST_ALLOCATION_KEYFLEX_ID FROM pay_cost_allocation_keyflex pcak WHERE pcak.segment2 like :1)
via Oracle Community by HaroonAfridi, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EmpTestEO.EMPNO, EmpTestEO.ENAME, EmpTestEO.JOB, EmpTestEO.MGR, EmpTestEO.HIREDATE, EmpTestEO.SAL, EmpTestEO.COMM, EmpTestEO.DEPTNO FROM EMP_TEST EmpTestEO WHERE EMPNO = :1
via Oracle Community by 802240, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PORTFOLIO_CODE PortfolioCode , PORTFOLIO_NAME PortfolioName , PORTFOLIO_DESCRIPTION PortfolioDescription , ATTRIBUTE1 Attribute1 , ATTRIBUTE2 Attribute2 , ATTRIBUTE3 Attribute3 FROM XXOTL_XX_XX_PORTFOLIOV_V
via Oracle Community by 528560, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT nfexceldataloadheadereo.batch_number, nfexceldataloadheadereo.file_name, nfexceldataloadheadereo.program_name
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT a.TEMPLATE_ID, a.TEMPLATE_NAME, a.WORKING_COPY_FLAG, a.INTENT, a.STATUS_CODE, a.START_DATE, a.END_DATE, a.GLOBAL_FLAG, a.PARENT_TEMPLATE_ID, a.CONTRACT_EXPERT_ENABLED, a.TEMPLATE_MODEL_ID, a.INSTRUCTION_TEXT, a.TMPL_NUMBERING_SCHEME, a.Print_Template_Id, a.DESCRIPTION, a.LAST_UPDATE_LOGIN, a.CREATION_DATE, a.CREATED_BY, a.LAST_UPDATED_BY, a.LAST_UPDATE_DATE, a.OBJECT_VERSION_NUMBER, a.ATTRIBUTE_CATEGORY, a.ATTRIBUTE1, a.ATTRIBUTE2, a.ATTRIBUTE3, a.ATTRIBUTE4, a.ATTRIBUTE5, a.ATTRIBUTE6, a.ATTRIBUTE7, a.ATTRIBUTE8, a.ATTRIBUTE9, a.ATTRIBUTE10, a.ATTRIBUTE11, a.ATTRIBUTE12, a.ATTRIBUTE13, a.ATTRIBUTE14, a.ATTRIBUTE15, b.document_type, a.org_id, DECODE(a.CONTRACT_EXPERT_ENABLED, 'Y', 'ExpertEnabled', 'NotExpertEnabled') EXPERT_IMAGE, fnd_lang.description language_description FROM OKC_TERMS_TEMPLATES_ALL a , OKC_ALLOWED_TMPL_USAGES b , PA_PROJECTS_ALL c , PA_PROJECT_PLAYERS d , FND_USER e , FND_LANGUAGES_VL fnd_lang WHERE a.template_id = b.template_id AND a.attribute1 = c.project_id AND d.project_id = c.project_id AND d.person_id = e.employee_id AND e.user_id = FND_PROFILE.VALUE('USER_ID') AND a.status_code = 'APPROVED' AND a.language = fnd_lang.language_code(+)) QRSLT WHERE (DOCUMENT_TYPE = :1 AND ORG_ID = :2 AND :3 between start_date and nvl(end_date, :4 ) AND ( UPPER(TEMPLATE_NAME) like UPPER(:5) AND (TEMPLATE_NAME like :6 OR TEMPLATE_NAME like :7 OR TEMPLATE_NAME like :8 OR TEMPLATE_NAME like :9)))
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:2979)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1859)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 week 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.