oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT acmt.CHASSIS_ID, ach.po_header_id, ACH.CHASSIS_VIN, acmt.INVOICE_RECEIPT_DATE, acmt.SUPPLIER_INVOICE, acmt.MSO_RECEIVED_DATE "MSO Received", acmt.MSO_MAILED_DATE "MSO Mailed", acmt.INVOICING_ORG_ID "Invoicing Lcation", pha.segment1, we.WIP_ENTITY_NAME Altec_Job, (SELECT hzp.party_name FROM oe_order_headers_all oe, hz_cust_accounts hca, hz_parties hzp WHERE ach.so_header_id = oe.header_id AND oe.sold_to_org_id = hca.cust_account_id AND oe.ship_to_org_id = hca.cust_account_id AND hzp.party_id = hca.party_id) Sales_Order_Bill_TO, ach.CHASSIS_MFG, acmt.mso_tracking_id FROM altec.ALTEC_CHASSIS_MSO_TRACKING acmt, altec.altec_chassis_headers ach, po_headers_all pha, wip_entities we WHERE acmt.chassis_id = ach.chassis_id AND pha.po_header_id(+) = ACH.PO_HEADER_ID AND we.WIP_ENTITY_ID(+) = ach.WIP_ENTITY_ID) QRSLT ORDER BY CHASSIS_ID ASC

Oracle Community | 907927 | 5 years ago
  1. 0

    ORA-00932: inconsistent datatypes: expected NUMBER got DATE

    Oracle Community | 5 years ago | 907927
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT acmt.CHASSIS_ID, ach.po_header_id, ACH.CHASSIS_VIN, acmt.INVOICE_RECEIPT_DATE, acmt.SUPPLIER_INVOICE, acmt.MSO_RECEIVED_DATE "MSO Received", acmt.MSO_MAILED_DATE "MSO Mailed", acmt.INVOICING_ORG_ID "Invoicing Lcation", pha.segment1, we.WIP_ENTITY_NAME Altec_Job, (SELECT hzp.party_name FROM oe_order_headers_all oe, hz_cust_accounts hca, hz_parties hzp WHERE ach.so_header_id = oe.header_id AND oe.sold_to_org_id = hca.cust_account_id AND oe.ship_to_org_id = hca.cust_account_id AND hzp.party_id = hca.party_id) Sales_Order_Bill_TO, ach.CHASSIS_MFG, acmt.mso_tracking_id FROM altec.ALTEC_CHASSIS_MSO_TRACKING acmt, altec.altec_chassis_headers ach, po_headers_all pha, wip_entities we WHERE acmt.chassis_id = ach.chassis_id AND pha.po_header_id(+) = ACH.PO_HEADER_ID AND we.WIP_ENTITY_ID(+) = ach.WIP_ENTITY_ID) QRSLT ORDER BY CHASSIS_ID ASC
  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 acmt.CHASSIS_ID, ach.po_header_id, ACH.CHASSIS_VIN, acmt.INVOICE_RECEIPT_DATE, acmt.SUPPLIER_INVOICE, acmt.MSO_RECEIVED_DATE "MSO Received", acmt.MSO_MAILED_DATE "MSO Mailed", acmt.INVOICING_ORG_ID "Invoicing Lcation", pha.segment1, we.WIP_ENTITY_NAME Altec_Job, (SELECT hzp.party_name FROM oe_order_headers_all oe, hz_cust_accounts hca, hz_parties hzp WHERE ach.so_header_id = oe.header_id AND oe.sold_to_org_id = hca.cust_account_id AND oe.ship_to_org_id = hca.cust_account_id AND hzp.party_id = hca.party_id) Sales_Order_Bill_TO, ach.CHASSIS_MFG, acmt.mso_tracking_id FROM altec.ALTEC_CHASSIS_MSO_TRACKING acmt, altec.altec_chassis_headers ach, po_headers_all pha, wip_entities we WHERE acmt.chassis_id = ach.chassis_id AND pha.po_header_id(+) = ACH.PO_HEADER_ID AND we.WIP_ENTITY_ID(+) = ach.WIP_ENTITY_ID) QRSLT ORDER BY CHASSIS_ID ASC

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2381)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1609)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
      7 frames