oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID, QRSLT.PO_RELEASE_ID, QRSLT.ORDER_ID, QRSLT.PO_NUMBER, QRSLT.PO_LINE_ID, QRSLT.PO_LINE_LOCATION_ID, QRSLT.PO_RELEASE_NUMBER, QRSLT.PO_LINE_NUMBER, QRSLT.PO_SHIPMENT_NUMBER, QRSLT.TO_ORGANIZATION_ID, QRSLT.ITEM_ID, QRSLT.PRIMARY_UOM, QRSLT.PRIMARY_UOM_CLASS, QRSLT.QUANTITY_DELIVERED, QRSLT.EXPECTED_RECEIPT_QTY, QRSLT.ITEM_DESCRIPTION, QRSLT.SHIP_TO_LOCATION_ID, QRSLT.VENDOR_ID, QRSLT.SOURCE, QRSLT.VENDOR_SITE_ID, QRSLT.SUPPLIER_SITE, QRSLT.NEED_BY_DATE, QRSLT.PROMISED_DATE, QRSLT.EXPECTED_RECEIPT_DATE, QRSLT.ORDERED_QTY, QRSLT.ORDERED_UOM, QRSLT.USSGL_TRANSACTION_CODE, QRSLT.PO_DISTRIBUTION_ID, QRSLT.PO_NUM_REL_NUM, QRSLT.UNIT, QRSLT.RECEIPT_QUANTITY, QRSLT.REQ_DISTRIBUTION_ID, QRSLT.DELIVER_TO_LOCATION_ID, QRSLT.REQ_HEADER_ID, QRSLT.REQUISITION_NUMBER, QRSLT.ORDER_TYPE, QRSLT.PO_DISTRIBUTION_NUM, QRSLT.VENDOR_PRODUCT_NUM, QRSLT.ORDER_NUMBER, QRSLT.MATCHING_BASIS, QRSLT.REQ_LINK, QRSLT.SHIPMENT_HEADER_ID , QRSLT.MANUFACTURER_PART_NUMBER, QRSLT.OPERATING_UNIT, PORD.PROJECT_ID, PAPA.SEGMENT1 PROJECT_NUMBER, papa.name PROJECT_NAME, PORL.LINE_NUM REQ_LINE_NUM, PAT.TASK_NUMBER, PAT.TASK_NAME, pord.Expenditure_Type, NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE FROM (SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_my_purchase_items_v rcv UNION ALL SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv1.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_internal_items_v rcv1 ) QRSLT ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER

orafaq.com | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    OraFAQ Forum: JDeveloper, Java & XML ยป java.sql.SQLException: ORA-01007: variable not in select list

    orafaq.com | 9 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID, QRSLT.PO_RELEASE_ID, QRSLT.ORDER_ID, QRSLT.PO_NUMBER, QRSLT.PO_LINE_ID, QRSLT.PO_LINE_LOCATION_ID, QRSLT.PO_RELEASE_NUMBER, QRSLT.PO_LINE_NUMBER, QRSLT.PO_SHIPMENT_NUMBER, QRSLT.TO_ORGANIZATION_ID, QRSLT.ITEM_ID, QRSLT.PRIMARY_UOM, QRSLT.PRIMARY_UOM_CLASS, QRSLT.QUANTITY_DELIVERED, QRSLT.EXPECTED_RECEIPT_QTY, QRSLT.ITEM_DESCRIPTION, QRSLT.SHIP_TO_LOCATION_ID, QRSLT.VENDOR_ID, QRSLT.SOURCE, QRSLT.VENDOR_SITE_ID, QRSLT.SUPPLIER_SITE, QRSLT.NEED_BY_DATE, QRSLT.PROMISED_DATE, QRSLT.EXPECTED_RECEIPT_DATE, QRSLT.ORDERED_QTY, QRSLT.ORDERED_UOM, QRSLT.USSGL_TRANSACTION_CODE, QRSLT.PO_DISTRIBUTION_ID, QRSLT.PO_NUM_REL_NUM, QRSLT.UNIT, QRSLT.RECEIPT_QUANTITY, QRSLT.REQ_DISTRIBUTION_ID, QRSLT.DELIVER_TO_LOCATION_ID, QRSLT.REQ_HEADER_ID, QRSLT.REQUISITION_NUMBER, QRSLT.ORDER_TYPE, QRSLT.PO_DISTRIBUTION_NUM, QRSLT.VENDOR_PRODUCT_NUM, QRSLT.ORDER_NUMBER, QRSLT.MATCHING_BASIS, QRSLT.REQ_LINK, QRSLT.SHIPMENT_HEADER_ID , QRSLT.MANUFACTURER_PART_NUMBER, QRSLT.OPERATING_UNIT, PORD.PROJECT_ID, PAPA.SEGMENT1 PROJECT_NUMBER, papa.name PROJECT_NAME, PORL.LINE_NUM REQ_LINE_NUM, PAT.TASK_NUMBER, PAT.TASK_NAME, pord.Expenditure_Type, NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE FROM (SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_my_purchase_items_v rcv UNION ALL SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv1.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_internal_items_v rcv1 ) QRSLT ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER
  2. 0

    java.sql.SQLException: ORA-01007: variable not in select list

    Oracle Community | 6 years ago | 594196
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID, QRSLT.PO_RELEASE_ID, QRSLT.ORDER_ID, QRSLT.PO_NUMBER, QRSLT.PO_LINE_ID, QRSLT.PO_LINE_LOCATION_ID, QRSLT.PO_RELEASE_NUMBER, QRSLT.PO_LINE_NUMBER, QRSLT.PO_SHIPMENT_NUMBER, QRSLT.TO_ORGANIZATION_ID, QRSLT.ITEM_ID, QRSLT.PRIMARY_UOM, QRSLT.PRIMARY_UOM_CLASS, QRSLT.QUANTITY_DELIVERED, QRSLT.EXPECTED_RECEIPT_QTY, QRSLT.ITEM_DESCRIPTION, QRSLT.SHIP_TO_LOCATION_ID, QRSLT.VENDOR_ID, QRSLT.SOURCE, QRSLT.VENDOR_SITE_ID, QRSLT.SUPPLIER_SITE, QRSLT.NEED_BY_DATE, QRSLT.PROMISED_DATE, QRSLT.EXPECTED_RECEIPT_DATE, QRSLT.ORDERED_QTY, QRSLT.ORDERED_UOM, QRSLT.USSGL_TRANSACTION_CODE, QRSLT.PO_DISTRIBUTION_ID, QRSLT.PO_NUM_REL_NUM, QRSLT.UNIT, QRSLT.RECEIPT_QUANTITY, QRSLT.REQ_DISTRIBUTION_ID, QRSLT.DELIVER_TO_LOCATION_ID, QRSLT.REQ_HEADER_ID, QRSLT.REQUISITION_NUMBER, QRSLT.ORDER_TYPE, QRSLT.PO_DISTRIBUTION_NUM, QRSLT.VENDOR_PRODUCT_NUM, QRSLT.ORDER_NUMBER, QRSLT.MATCHING_BASIS, QRSLT.REQ_LINK, QRSLT.SHIPMENT_HEADER_ID , QRSLT.MANUFACTURER_PART_NUMBER, QRSLT.OPERATING_UNIT, PORD.PROJECT_ID, PAPA.SEGMENT1 PROJECT_NUMBER, papa.name PROJECT_NAME, PORL.LINE_NUM REQ_LINE_NUM, PAT.TASK_NUMBER, PAT.TASK_NAME, pord.Expenditure_Type, NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE FROM (SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_my_purchase_items_v rcv UNION ALL SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv1.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_internal_items_v rcv1 ) QRSLT ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER
  3. 0

    JBO-27122: SQL error during statement preparation. Statement - In Receiving VO

    Oracle Community | 4 years ago | ORA_USER1122
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (select lookup.meaning from fnd_lookup_values_vl lookup where lookup.lookup_code = rcv.order_type_code and lookup.lookup_type ='POR_RCV_ORDER_TYPE') ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, decode(req_distribution_id, to_number(null), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(null) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT, QUANTITY_INVOICED, GL_ENCUMBERED_DATE, (select hla.location_code from hr_locations_all hla where hla.location_id = rcv.deliver_to_location_id)DAI_LOCATION_CODE from por_rcv_my_purchase_items_v rcv UNION ALL select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (select lookup.meaning from fnd_lookup_values_vl lookup where lookup.lookup_code = rcv1.order_type_code and lookup.lookup_type ='POR_RCV_ORDER_TYPE') ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, NULL matching_basis, decode(req_distribution_id, to_number(null), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(null) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT, QUANTITY_INVOICED, GL_ENCUMBERED_DATE, (select hla.location_code from hr_locations_all hla where hla.location_id = rcv1.deliver_to_location_id)DAI_LOCATION_CODE from por_rcv_internal_items_v rcv1) QRSLT WHERE (REQUESTOR_ID = :1 and expected_receipt_date >= trunc(sysdate - 8) and expected_receipt_date <= trunc(sysdate + 1))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 4.05::Error 1579 8z

    hivmr.com | 9 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException
  6. 0

    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException

    Oracle Community | 6 years ago | 594196
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException

    2 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 QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID, QRSLT.PO_RELEASE_ID, QRSLT.ORDER_ID, QRSLT.PO_NUMBER, QRSLT.PO_LINE_ID, QRSLT.PO_LINE_LOCATION_ID, QRSLT.PO_RELEASE_NUMBER, QRSLT.PO_LINE_NUMBER, QRSLT.PO_SHIPMENT_NUMBER, QRSLT.TO_ORGANIZATION_ID, QRSLT.ITEM_ID, QRSLT.PRIMARY_UOM, QRSLT.PRIMARY_UOM_CLASS, QRSLT.QUANTITY_DELIVERED, QRSLT.EXPECTED_RECEIPT_QTY, QRSLT.ITEM_DESCRIPTION, QRSLT.SHIP_TO_LOCATION_ID, QRSLT.VENDOR_ID, QRSLT.SOURCE, QRSLT.VENDOR_SITE_ID, QRSLT.SUPPLIER_SITE, QRSLT.NEED_BY_DATE, QRSLT.PROMISED_DATE, QRSLT.EXPECTED_RECEIPT_DATE, QRSLT.ORDERED_QTY, QRSLT.ORDERED_UOM, QRSLT.USSGL_TRANSACTION_CODE, QRSLT.PO_DISTRIBUTION_ID, QRSLT.PO_NUM_REL_NUM, QRSLT.UNIT, QRSLT.RECEIPT_QUANTITY, QRSLT.REQ_DISTRIBUTION_ID, QRSLT.DELIVER_TO_LOCATION_ID, QRSLT.REQ_HEADER_ID, QRSLT.REQUISITION_NUMBER, QRSLT.ORDER_TYPE, QRSLT.PO_DISTRIBUTION_NUM, QRSLT.VENDOR_PRODUCT_NUM, QRSLT.ORDER_NUMBER, QRSLT.MATCHING_BASIS, QRSLT.REQ_LINK, QRSLT.SHIPMENT_HEADER_ID , QRSLT.MANUFACTURER_PART_NUMBER, QRSLT.OPERATING_UNIT, PORD.PROJECT_ID, PAPA.SEGMENT1 PROJECT_NUMBER, papa.name PROJECT_NAME, PORL.LINE_NUM REQ_LINE_NUM, PAT.TASK_NUMBER, PAT.TASK_NAME, pord.Expenditure_Type, NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE FROM (SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_my_purchase_items_v rcv UNION ALL SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv1.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_internal_items_v rcv1 ) QRSLT ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708)
      5 frames
    3. oracle.apps.icx
      RcvSrchCO.processRequest
      1. oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:458)
      2. oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:67)
      2 frames
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
      18 frames
    5. _oa__html
      _OA._jspService
      1. _oa__html._OA._jspService(_OA.java:84)
      1 frame
    6. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    7. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    8. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    10. oracle.jsp.provider
      Jsp20RequestDispatcher.forward
      1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
      1 frame
    11. oracle.jsp.runtime
      OraclePageContext.forward
      1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
      1 frame
    12. _oa__html
      _OA._jspService
      1. _oa__html._OA._jspService(_OA.java:94)
      1 frame
    13. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    14. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    15. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    16. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    17. oracle.jsp.provider
      Jsp20RequestDispatcher.forward
      1. oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
      1 frame
    18. oracle.jsp.runtime
      OraclePageContext.forward
      1. oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
      1 frame
    19. _oa__html
      _OA._jspService
      1. _oa__html._OA._jspService(_OA.java:94)
      1 frame
    20. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    21. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    22. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    23. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    24. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    25. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame