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

Oracle Community | 795088 | 6 years ago
  1. 0

    oracle.jbo.SQLStmtException: JBO-27122

    Oracle Community | 6 years ago | 795088
    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)))
  2. 0

    Fnd Load Issue

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;
  3. 0

    db:: 3.55::FND_MESSAGE.PUT 1c

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = emp;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SEPL and VO Extension

    Oracle Community | 9 years ago | 567494
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = xxEYReqSummaryVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
  6. 0

    Tycast error in Extension

    Oracle Community | 8 years ago | 568541
    oracle.apps.fnd.framework.OAException: The application id or shortname (abc) you entered does not exist.

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2979)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1859)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      7 frames