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)))

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web1177

  • via Oracle Community by 795088, 1 year ago
    ' 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)))
  • via Oracle Community by 574833, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select comp_plan_id,name,org_id from cn_comp_plans_all where sysdate between start_date and nvl(end_date,sysdate+1) and org_id = :1) QRSLT WHERE (( UPPER(NAME) like :2 AND (NAME like :3 OR NAME like :4 OR NAME like :5 OR NAME like :6)))
  • via Oracle Community by 554681, 1 week ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (Query of VO ) QRSLT WHERE (( UPPER(EMPLOYEE_NUMBER) like :5 AND (EMPLOYEE_NUMBER like :6 OR EMPLOYEE_NUMBER like :7 OR EMPLOYEE_NUMBER like :8 OR EMPLOYEE_NUMBER like :9)))
  • Stack trace

    • 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)

    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 user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates