oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT POREQUISITIONLINEEO.REQUISITION_LINE_ID, POREQUISITIONLINEEO.REQUISITION_HEADER_ID, POREQUISITIONLINEEO.LINE_NUM, POREQUISITIONLINEEO.LAST_UPDATE_DATE, POREQUISITIONLINEEO.LAST_UPDATED_BY, POREQUISITIONLINEEO.LAST_UPDATE_LOGIN, POREQUISITIONLINEEO.CREATION_DATE, POREQUISITIONLINEEO.CREATED_BY, POREQUISITIONLINEEO.DELIVER_TO_LOCATION_ID, POREQUISITIONLINEEO.TO_PERSON_ID, POREQUISITIONLINEEO.ITEM_DESCRIPTION, POREQUISITIONLINEEO.CATEGORY_ID, POREQUISITIONLINEEO.UNIT_MEAS_LOOKUP_CODE, POREQUISITIONLINEEO.UNIT_PRICE, POREQUISITIONLINEEO.QUANTITY, POREQUISITIONLINEEO.LINE_TYPE_ID, POREQUISITIONLINEEO.SOURCE_TYPE_CODE, POREQUISITIONLINEEO.ITEM_ID, POREQUISITIONLINEEO.ITEM_REVISION, POREQUISITIONLINEEO.QUANTITY_DELIVERED, POREQUISITIONLINEEO.SUGGESTED_BUYER_ID, POREQUISITIONLINEEO.ENCUMBERED_FLAG, POREQUISITIONLINEEO.RFQ_REQUIRED_FLAG, POREQUISITIONLINEEO.NEED_BY_DATE, POREQUISITIONLINEEO.LINE_LOCATION_ID, POREQUISITIONLINEEO.MODIFIED_BY_AGENT_FLAG, POREQUISITIONLINEEO.PARENT_REQ_LINE_ID, POREQUISITIONLINEEO.JUSTIFICATION, POREQUISITIONLINEEO.NOTE_TO_AGENT, POREQUISITIONLINEEO.NOTE_TO_RECEIVER, POREQUISITIONLINEEO.PURCHASING_AGENT_ID, POREQUISITIONLINEEO.DOCUMENT_TYPE_CODE, POREQUISITIONLINEEO.BLANKET_PO_HEADER_ID, POREQUISITIONLINEEO.BLANKET_PO_LINE_NUM, POREQUISITIONLINEEO.CURRENCY_CODE, POREQUISITIONLINEEO.RATE_TYPE, POREQUISITIONLINEEO.RATE_DATE, POREQUISITIONLINEEO.RATE, POREQUISITIONLINEEO.CURRENCY_UNIT_PRICE, POREQUISITIONLINEEO.SUGGESTED_VENDOR_NAME, POREQUISITIONLINEEO.SUGGESTED_VENDOR_LOCATION, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT, POREQUISITIONLINEEO.SUGGESTED_VENDOR_PHONE, POREQUISITIONLINEEO.SUGGESTED_VENDOR_PRODUCT_CODE, POREQUISITIONLINEEO.UN_NUMBER_ID, POREQUISITIONLINEEO.HAZARD_CLASS_ID, POREQUISITIONLINEEO.MUST_USE_SUGG_VENDOR_FLAG, POREQUISITIONLINEEO.REFERENCE_NUM, POREQUISITIONLINEEO.ON_RFQ_FLAG, POREQUISITIONLINEEO.URGENT_FLAG, POREQUISITIONLINEEO.CANCEL_FLAG, POREQUISITIONLINEEO.SOURCE_ORGANIZATION_ID, POREQUISITIONLINEEO.SOURCE_SUBINVENTORY, POREQUISITIONLINEEO.DESTINATION_TYPE_CODE, POREQUISITIONLINEEO.DESTINATION_ORGANIZATION_ID, POREQUISITIONLINEEO.DESTINATION_SUBINVENTORY, POREQUISITIONLINEEO.QUANTITY_CANCELLED, POREQUISITIONLINEEO.CANCEL_DATE, POREQUISITIONLINEEO.CANCEL_REASON, POREQUISITIONLINEEO.CLOSED_CODE, POREQUISITIONLINEEO.AGENT_RETURN_NOTE, POREQUISITIONLINEEO.CHANGED_AFTER_RESEARCH_FLAG, POREQUISITIONLINEEO.VENDOR_ID, POREQUISITIONLINEEO.VENDOR_SITE_ID, POREQUISITIONLINEEO.VENDOR_CONTACT_ID, POREQUISITIONLINEEO.RESEARCH_AGENT_ID, POREQUISITIONLINEEO.ON_LINE_FLAG, POREQUISITIONLINEEO.WIP_ENTITY_ID, POREQUISITIONLINEEO.WIP_LINE_ID, POREQUISITIONLINEEO.WIP_REPETITIVE_SCHEDULE_ID, POREQUISITIONLINEEO.WIP_OPERATION_SEQ_NUM, POREQUISITIONLINEEO.WIP_RESOURCE_SEQ_NUM, POREQUISITIONLINEEO.ATTRIBUTE_CATEGORY, POREQUISITIONLINEEO.DESTINATION_CONTEXT, POREQUISITIONLINEEO.INVENTORY_SOURCE_CONTEXT, POREQUISITIONLINEEO.VENDOR_SOURCE_CONTEXT, POREQUISITIONLINEEO.BOM_RESOURCE_ID, POREQUISITIONLINEEO.REQUEST_ID, POREQUISITIONLINEEO.PROGRAM_APPLICATION_ID, POREQUISITIONLINEEO.PROGRAM_ID, POREQUISITIONLINEEO.PROGRAM_UPDATE_DATE, POREQUISITIONLINEEO.USSGL_TRANSACTION_CODE, POREQUISITIONLINEEO.GOVERNMENT_CONTEXT, POREQUISITIONLINEEO.CLOSED_REASON, POREQUISITIONLINEEO.CLOSED_DATE, POREQUISITIONLINEEO.TRANSACTION_REASON_CODE, POREQUISITIONLINEEO.QUANTITY_RECEIVED, POREQUISITIONLINEEO.SOURCE_REQ_LINE_ID, POREQUISITIONLINEEO.ORG_ID, POREQUISITIONLINEEO.KANBAN_CARD_ID, POREQUISITIONLINEEO.CATALOG_TYPE, POREQUISITIONLINEEO.CATALOG_SOURCE, POREQUISITIONLINEEO.MANUFACTURER_ID, POREQUISITIONLINEEO.MANUFACTURER_NAME, POREQUISITIONLINEEO.MANUFACTURER_PART_NUMBER, POREQUISITIONLINEEO.REQUESTER_EMAIL, POREQUISITIONLINEEO.REQUESTER_FAX, POREQUISITIONLINEEO.REQUESTER_PHONE, POREQUISITIONLINEEO.UNSPSC_CODE, POREQUISITIONLINEEO.OTHER_CATEGORY_CODE, POREQUISITIONLINEEO.SUPPLIER_DUNS, POREQUISITIONLINEEO.TAX_STATUS_INDICATOR, POREQUISITIONLINEEO.PCARD_FLAG, POREQUISITIONLINEEO.NEW_SUPPLIER_FLAG, POREQUISITIONLINEEO.AUTO_RECEIVE_FLAG, POREQUISITIONLINEEO.TAX_USER_OVERRIDE_FLAG, POREQUISITIONLINEEO.TAX_CODE_ID, POREQUISITIONLINEEO.NOTE_TO_VENDOR, POREQUISITIONLINEEO.OKE_CONTRACT_VERSION_ID, POREQUISITIONLINEEO.OKE_CONTRACT_HEADER_ID, POREQUISITIONLINEEO.ITEM_SOURCE_ID, POREQUISITIONLINEEO.SUPPLIER_REF_NUMBER, POREQUISITIONLINEEO.SECONDARY_UNIT_OF_MEASURE, POREQUISITIONLINEEO.SECONDARY_QUANTITY, POREQUISITIONLINEEO.PREFERRED_GRADE, POREQUISITIONLINEEO.SECONDARY_QUANTITY_RECEIVED, POREQUISITIONLINEEO.SECONDARY_QUANTITY_CANCELLED, POREQUISITIONLINEEO.AUCTION_HEADER_ID, POREQUISITIONLINEEO.AUCTION_DISPLAY_NUMBER, POREQUISITIONLINEEO.AUCTION_LINE_NUMBER, POREQUISITIONLINEEO.REQS_IN_POOL_FLAG, POREQUISITIONLINEEO.VMI_FLAG, POREQUISITIONLINEEO.ATTRIBUTE1, POREQUISITIONLINEEO.ATTRIBUTE2, POREQUISITIONLINEEO.ATTRIBUTE3, POREQUISITIONLINEEO.ATTRIBUTE4, POREQUISITIONLINEEO.ATTRIBUTE5, POREQUISITIONLINEEO.ATTRIBUTE6, POREQUISITIONLINEEO.ATTRIBUTE7, POREQUISITIONLINEEO.ATTRIBUTE8, POREQUISITIONLINEEO.ATTRIBUTE9, POREQUISITIONLINEEO.ATTRIBUTE10, POREQUISITIONLINEEO.ATTRIBUTE11, POREQUISITIONLINEEO.ATTRIBUTE12, POREQUISITIONLINEEO.ATTRIBUTE13, POREQUISITIONLINEEO.ATTRIBUTE14, POREQUISITIONLINEEO.ATTRIBUTE15, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE1, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE2, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE3, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE4, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE5, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE6, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE7, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE8, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE9, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE10, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE11, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE12, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE13, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE14, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE15, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE16, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE17, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE18, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE19, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE20, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE_CATEGORY, POREQUISITIONLINEEO.BID_NUMBER, POREQUISITIONLINEEO.BID_LINE_NUMBER, POREQUISITIONLINEEO.AMOUNT, POREQUISITIONLINEEO.CURRENCY_AMOUNT, POREQUISITIONLINEEO.NONCAT_TEMPLATE_ID, POREQUISITIONLINEEO.JOB_ID, POREQUISITIONLINEEO.CONTACT_INFORMATION, POREQUISITIONLINEEO.CANDIDATE_SCREENING_REQD_FLAG, POREQUISITIONLINEEO.SUGGESTED_SUPPLIER_FLAG, POREQUISITIONLINEEO.ASSIGNMENT_END_DATE, POREQUISITIONLINEEO.OVERTIME_ALLOWED_FLAG, POREQUISITIONLINEEO.CONTRACTOR_REQUISITION_FLAG, POREQUISITIONLINEEO.LABOR_REQ_LINE_ID, POREQUISITIONLINEEO.JOB_LONG_DESCRIPTION, POREQUISITIONLINEEO.CONTRACTOR_STATUS, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT_FAX, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT_EMAIL, POREQUISITIONLINEEO.CANDIDATE_FIRST_NAME, POREQUISITIONLINEEO.CANDIDATE_LAST_NAME, POREQUISITIONLINEEO.ASSIGNMENT_START_DATE, POREQUISITIONLINEEO.ORDER_TYPE_LOOKUP_CODE, POREQUISITIONLINEEO.PURCHASE_BASIS, POREQUISITIONLINEEO.MATCHING_BASIS, POREQUISITIONLINEEO.NEGOTIATED_BY_PREPARER_FLAG, POREQUISITIONLINEEO.BASE_UNIT_PRICE, POREQUISITIONLINEEO.AT_SOURCING_FLAG, POREQUISITIONLINEEO.TAX_ATTRIBUTE_UPDATE_CODE, POREQUISITIONLINEEO.DROP_SHIP_FLAG, POREQUISITIONLINEEO.SHIP_METHOD, POREQUISITIONLINEEO.ESTIMATED_PICKUP_DATE, POREQUISITIONLINEEO.SUPPLIER_NOTIFIED_FOR_CANCEL, POREQUISITIONLINEEO.TAX_NAME, POREQUISITIONLINEEO.REQUISITION_HEADER_ID BUDGET_AMOUNT, POREQUISITIONLINEEO.REQUISITION_HEADER_ID ACTUAL_SPEND, POREQUISITIONLINEEO.REQUISITION_HEADER_ID SPEND_IN_PROCESS, POREQUISITIONLINEEO.REQUISITION_HEADER_ID VARIANCE_COLUMN FROM PO_REQUISITION_LINES_ALL POREQUISITIONLINEEO) QRSLT WHERE (nvl(closed_code, 'N') <> 'FINALLY CLOSED' AND nvl(cancel_flag, 'N') = 'N' AND nvl(modified_by_agent_flag, 'N') = 'N' AND line_location_id IS NULL AND ((SELECT nvl(transferred_to_oe_flag, 'N') FROM po_requisition_headers_all h WHERE h.requisition_header_id = PoRequisitionLineEO.requisition_header_id) <> 'Y' OR source_type_code = 'VENDOR')) AND REQUISITION_HEADER_ID = :Bind_RequisitionHeaderId

Oracle Community | 1977211 | 3 years ago
  1. 0

    Vo extension error in iprocurement

    Oracle Community | 3 years ago | 1977211
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT POREQUISITIONLINEEO.REQUISITION_LINE_ID, POREQUISITIONLINEEO.REQUISITION_HEADER_ID, POREQUISITIONLINEEO.LINE_NUM, POREQUISITIONLINEEO.LAST_UPDATE_DATE, POREQUISITIONLINEEO.LAST_UPDATED_BY, POREQUISITIONLINEEO.LAST_UPDATE_LOGIN, POREQUISITIONLINEEO.CREATION_DATE, POREQUISITIONLINEEO.CREATED_BY, POREQUISITIONLINEEO.DELIVER_TO_LOCATION_ID, POREQUISITIONLINEEO.TO_PERSON_ID, POREQUISITIONLINEEO.ITEM_DESCRIPTION, POREQUISITIONLINEEO.CATEGORY_ID, POREQUISITIONLINEEO.UNIT_MEAS_LOOKUP_CODE, POREQUISITIONLINEEO.UNIT_PRICE, POREQUISITIONLINEEO.QUANTITY, POREQUISITIONLINEEO.LINE_TYPE_ID, POREQUISITIONLINEEO.SOURCE_TYPE_CODE, POREQUISITIONLINEEO.ITEM_ID, POREQUISITIONLINEEO.ITEM_REVISION, POREQUISITIONLINEEO.QUANTITY_DELIVERED, POREQUISITIONLINEEO.SUGGESTED_BUYER_ID, POREQUISITIONLINEEO.ENCUMBERED_FLAG, POREQUISITIONLINEEO.RFQ_REQUIRED_FLAG, POREQUISITIONLINEEO.NEED_BY_DATE, POREQUISITIONLINEEO.LINE_LOCATION_ID, POREQUISITIONLINEEO.MODIFIED_BY_AGENT_FLAG, POREQUISITIONLINEEO.PARENT_REQ_LINE_ID, POREQUISITIONLINEEO.JUSTIFICATION, POREQUISITIONLINEEO.NOTE_TO_AGENT, POREQUISITIONLINEEO.NOTE_TO_RECEIVER, POREQUISITIONLINEEO.PURCHASING_AGENT_ID, POREQUISITIONLINEEO.DOCUMENT_TYPE_CODE, POREQUISITIONLINEEO.BLANKET_PO_HEADER_ID, POREQUISITIONLINEEO.BLANKET_PO_LINE_NUM, POREQUISITIONLINEEO.CURRENCY_CODE, POREQUISITIONLINEEO.RATE_TYPE, POREQUISITIONLINEEO.RATE_DATE, POREQUISITIONLINEEO.RATE, POREQUISITIONLINEEO.CURRENCY_UNIT_PRICE, POREQUISITIONLINEEO.SUGGESTED_VENDOR_NAME, POREQUISITIONLINEEO.SUGGESTED_VENDOR_LOCATION, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT, POREQUISITIONLINEEO.SUGGESTED_VENDOR_PHONE, POREQUISITIONLINEEO.SUGGESTED_VENDOR_PRODUCT_CODE, POREQUISITIONLINEEO.UN_NUMBER_ID, POREQUISITIONLINEEO.HAZARD_CLASS_ID, POREQUISITIONLINEEO.MUST_USE_SUGG_VENDOR_FLAG, POREQUISITIONLINEEO.REFERENCE_NUM, POREQUISITIONLINEEO.ON_RFQ_FLAG, POREQUISITIONLINEEO.URGENT_FLAG, POREQUISITIONLINEEO.CANCEL_FLAG, POREQUISITIONLINEEO.SOURCE_ORGANIZATION_ID, POREQUISITIONLINEEO.SOURCE_SUBINVENTORY, POREQUISITIONLINEEO.DESTINATION_TYPE_CODE, POREQUISITIONLINEEO.DESTINATION_ORGANIZATION_ID, POREQUISITIONLINEEO.DESTINATION_SUBINVENTORY, POREQUISITIONLINEEO.QUANTITY_CANCELLED, POREQUISITIONLINEEO.CANCEL_DATE, POREQUISITIONLINEEO.CANCEL_REASON, POREQUISITIONLINEEO.CLOSED_CODE, POREQUISITIONLINEEO.AGENT_RETURN_NOTE, POREQUISITIONLINEEO.CHANGED_AFTER_RESEARCH_FLAG, POREQUISITIONLINEEO.VENDOR_ID, POREQUISITIONLINEEO.VENDOR_SITE_ID, POREQUISITIONLINEEO.VENDOR_CONTACT_ID, POREQUISITIONLINEEO.RESEARCH_AGENT_ID, POREQUISITIONLINEEO.ON_LINE_FLAG, POREQUISITIONLINEEO.WIP_ENTITY_ID, POREQUISITIONLINEEO.WIP_LINE_ID, POREQUISITIONLINEEO.WIP_REPETITIVE_SCHEDULE_ID, POREQUISITIONLINEEO.WIP_OPERATION_SEQ_NUM, POREQUISITIONLINEEO.WIP_RESOURCE_SEQ_NUM, POREQUISITIONLINEEO.ATTRIBUTE_CATEGORY, POREQUISITIONLINEEO.DESTINATION_CONTEXT, POREQUISITIONLINEEO.INVENTORY_SOURCE_CONTEXT, POREQUISITIONLINEEO.VENDOR_SOURCE_CONTEXT, POREQUISITIONLINEEO.BOM_RESOURCE_ID, POREQUISITIONLINEEO.REQUEST_ID, POREQUISITIONLINEEO.PROGRAM_APPLICATION_ID, POREQUISITIONLINEEO.PROGRAM_ID, POREQUISITIONLINEEO.PROGRAM_UPDATE_DATE, POREQUISITIONLINEEO.USSGL_TRANSACTION_CODE, POREQUISITIONLINEEO.GOVERNMENT_CONTEXT, POREQUISITIONLINEEO.CLOSED_REASON, POREQUISITIONLINEEO.CLOSED_DATE, POREQUISITIONLINEEO.TRANSACTION_REASON_CODE, POREQUISITIONLINEEO.QUANTITY_RECEIVED, POREQUISITIONLINEEO.SOURCE_REQ_LINE_ID, POREQUISITIONLINEEO.ORG_ID, POREQUISITIONLINEEO.KANBAN_CARD_ID, POREQUISITIONLINEEO.CATALOG_TYPE, POREQUISITIONLINEEO.CATALOG_SOURCE, POREQUISITIONLINEEO.MANUFACTURER_ID, POREQUISITIONLINEEO.MANUFACTURER_NAME, POREQUISITIONLINEEO.MANUFACTURER_PART_NUMBER, POREQUISITIONLINEEO.REQUESTER_EMAIL, POREQUISITIONLINEEO.REQUESTER_FAX, POREQUISITIONLINEEO.REQUESTER_PHONE, POREQUISITIONLINEEO.UNSPSC_CODE, POREQUISITIONLINEEO.OTHER_CATEGORY_CODE, POREQUISITIONLINEEO.SUPPLIER_DUNS, POREQUISITIONLINEEO.TAX_STATUS_INDICATOR, POREQUISITIONLINEEO.PCARD_FLAG, POREQUISITIONLINEEO.NEW_SUPPLIER_FLAG, POREQUISITIONLINEEO.AUTO_RECEIVE_FLAG, POREQUISITIONLINEEO.TAX_USER_OVERRIDE_FLAG, POREQUISITIONLINEEO.TAX_CODE_ID, POREQUISITIONLINEEO.NOTE_TO_VENDOR, POREQUISITIONLINEEO.OKE_CONTRACT_VERSION_ID, POREQUISITIONLINEEO.OKE_CONTRACT_HEADER_ID, POREQUISITIONLINEEO.ITEM_SOURCE_ID, POREQUISITIONLINEEO.SUPPLIER_REF_NUMBER, POREQUISITIONLINEEO.SECONDARY_UNIT_OF_MEASURE, POREQUISITIONLINEEO.SECONDARY_QUANTITY, POREQUISITIONLINEEO.PREFERRED_GRADE, POREQUISITIONLINEEO.SECONDARY_QUANTITY_RECEIVED, POREQUISITIONLINEEO.SECONDARY_QUANTITY_CANCELLED, POREQUISITIONLINEEO.AUCTION_HEADER_ID, POREQUISITIONLINEEO.AUCTION_DISPLAY_NUMBER, POREQUISITIONLINEEO.AUCTION_LINE_NUMBER, POREQUISITIONLINEEO.REQS_IN_POOL_FLAG, POREQUISITIONLINEEO.VMI_FLAG, POREQUISITIONLINEEO.ATTRIBUTE1, POREQUISITIONLINEEO.ATTRIBUTE2, POREQUISITIONLINEEO.ATTRIBUTE3, POREQUISITIONLINEEO.ATTRIBUTE4, POREQUISITIONLINEEO.ATTRIBUTE5, POREQUISITIONLINEEO.ATTRIBUTE6, POREQUISITIONLINEEO.ATTRIBUTE7, POREQUISITIONLINEEO.ATTRIBUTE8, POREQUISITIONLINEEO.ATTRIBUTE9, POREQUISITIONLINEEO.ATTRIBUTE10, POREQUISITIONLINEEO.ATTRIBUTE11, POREQUISITIONLINEEO.ATTRIBUTE12, POREQUISITIONLINEEO.ATTRIBUTE13, POREQUISITIONLINEEO.ATTRIBUTE14, POREQUISITIONLINEEO.ATTRIBUTE15, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE1, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE2, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE3, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE4, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE5, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE6, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE7, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE8, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE9, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE10, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE11, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE12, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE13, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE14, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE15, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE16, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE17, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE18, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE19, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE20, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE_CATEGORY, POREQUISITIONLINEEO.BID_NUMBER, POREQUISITIONLINEEO.BID_LINE_NUMBER, POREQUISITIONLINEEO.AMOUNT, POREQUISITIONLINEEO.CURRENCY_AMOUNT, POREQUISITIONLINEEO.NONCAT_TEMPLATE_ID, POREQUISITIONLINEEO.JOB_ID, POREQUISITIONLINEEO.CONTACT_INFORMATION, POREQUISITIONLINEEO.CANDIDATE_SCREENING_REQD_FLAG, POREQUISITIONLINEEO.SUGGESTED_SUPPLIER_FLAG, POREQUISITIONLINEEO.ASSIGNMENT_END_DATE, POREQUISITIONLINEEO.OVERTIME_ALLOWED_FLAG, POREQUISITIONLINEEO.CONTRACTOR_REQUISITION_FLAG, POREQUISITIONLINEEO.LABOR_REQ_LINE_ID, POREQUISITIONLINEEO.JOB_LONG_DESCRIPTION, POREQUISITIONLINEEO.CONTRACTOR_STATUS, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT_FAX, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT_EMAIL, POREQUISITIONLINEEO.CANDIDATE_FIRST_NAME, POREQUISITIONLINEEO.CANDIDATE_LAST_NAME, POREQUISITIONLINEEO.ASSIGNMENT_START_DATE, POREQUISITIONLINEEO.ORDER_TYPE_LOOKUP_CODE, POREQUISITIONLINEEO.PURCHASE_BASIS, POREQUISITIONLINEEO.MATCHING_BASIS, POREQUISITIONLINEEO.NEGOTIATED_BY_PREPARER_FLAG, POREQUISITIONLINEEO.BASE_UNIT_PRICE, POREQUISITIONLINEEO.AT_SOURCING_FLAG, POREQUISITIONLINEEO.TAX_ATTRIBUTE_UPDATE_CODE, POREQUISITIONLINEEO.DROP_SHIP_FLAG, POREQUISITIONLINEEO.SHIP_METHOD, POREQUISITIONLINEEO.ESTIMATED_PICKUP_DATE, POREQUISITIONLINEEO.SUPPLIER_NOTIFIED_FOR_CANCEL, POREQUISITIONLINEEO.TAX_NAME, POREQUISITIONLINEEO.REQUISITION_HEADER_ID BUDGET_AMOUNT, POREQUISITIONLINEEO.REQUISITION_HEADER_ID ACTUAL_SPEND, POREQUISITIONLINEEO.REQUISITION_HEADER_ID SPEND_IN_PROCESS, POREQUISITIONLINEEO.REQUISITION_HEADER_ID VARIANCE_COLUMN FROM PO_REQUISITION_LINES_ALL POREQUISITIONLINEEO) QRSLT WHERE (nvl(closed_code, 'N') <> 'FINALLY CLOSED' AND nvl(cancel_flag, 'N') = 'N' AND nvl(modified_by_agent_flag, 'N') = 'N' AND line_location_id IS NULL AND ((SELECT nvl(transferred_to_oe_flag, 'N') FROM po_requisition_headers_all h WHERE h.requisition_header_id = PoRequisitionLineEO.requisition_header_id) <> 'Y' OR source_type_code = 'VENDOR')) AND REQUISITION_HEADER_ID = :Bind_RequisitionHeaderId
  2. 0

    How to run CheckoutSummaryPG in OAF

    Oracle Community | 8 years ago | Naveen Gudala
    oracle.apps.fnd.framework.OAException: java.lang.Exception: There is no current requisition. Checkout cannot proceed.
  3. 0

    Passing parameter from one page to another

    Oracle Community | 3 years ago | Azadare M
    oracle.apps.fnd.framework.OAException: java.lang.Exception: There is no current requisition. Checkout cannot proceed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation - webnetta.com

    webnetta.com | 3 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT PoRequisitionLineEO.REQUISITION_LINE_ID,        PoRequisitionLineEO.REQUISITION_HEADER_ID,        PoRequisitionLineEO.LINE_NUM,        PoRequisitionLineEO.LAST_UPDATE_DATE,        PoRequisitionLineEO.LAST_UPDATED_BY,        PoRequisitionLineEO.LAST_UPDATE_LOGIN,        PoRequisitionLineEO.CREATION_DATE,        PoRequisitionLineEO.CREATED_BY,        PoRequisitionLineEO.DELIVER_TO_LOCATION_ID,        PoRequisitionLineEO.TO_PERSON_ID,        PoRequisitionLineEO.ITEM_DESCRIPTION,        PoRequisitionLineEO.CATEGORY_ID,        PoRequisitionLineEO.UNIT_MEAS_LOOKUP_CODE,        PoRequisitionLineEO.UNIT_PRICE,        PoRequisitionLineEO.QUANTITY,        PoRequisitionLineEO.LINE_TYPE_ID,        PoRequisitionLineEO.SOURCE_TYPE_CODE,        PoRequisitionLineEO.ITEM_ID,        PoRequisitionLineEO.ITEM_REVISION,        PoRequisitionLineEO.QUANTITY_DELIVERED,        PoRequisitionLineEO.SUGGESTED_BUYER_ID,        PoRequisitionLineEO.ENCUMBERED_FLAG,        PoRequisitionLineEO.RFQ_REQUIRED_FLAG,        PoRequisitionLineEO.NEED_BY_DATE,        PoRequisitionLineEO.LINE_LOCATION_ID,        PoRequisitionLineEO.MODIFIED_BY_AGENT_FLAG,        PoRequisitionLineEO.PARENT_REQ_LINE_ID,        PoRequisitionLineEO.JUSTIFICATION,        PoRequisitionLineEO.NOTE_TO_AGENT,        PoRequisitionLineEO.NOTE_TO_RECEIVER,        PoRequisitionLineEO.PURCHASING_AGENT_ID,        PoRequisitionLineEO.DOCUMENT_TYPE_CODE,        PoRequisitionLineEO.BLANKET_PO_HEADER_ID,        PoRequisitionLineEO.BLANKET_PO_LINE_NUM,        PoRequisitionLineEO.CURRENCY_CODE,        PoRequisitionLineEO.RATE_TYPE,        /*PoRequisitionLineEO.RATE_DATE*/trunc(SYSDATE) rate_DATE,        /*PoRequisitionLineEO.RATE*/        (SELECT conversion_rate           FROM gl_daily_rates                ,hr_operating_units hou                ,gl_sets_of_books sob          WHERE from_currency = PoRequisitionLineEO.CURRENCY_CODE          AND to_currency = sob.currency_code          AND conversion_type = PoRequisitionLineEO.RATE_TYPE          AND conversion_date = trunc(SYSDATE)          AND  hou.organization_id = PoRequisitionLineEO.org_id           AND hou.set_of_books_id = sob.SET_OF_BOOKS_ID ) rate,        PoRequisitionLineEO.CURRENCY_UNIT_PRICE,        PoRequisitionLineEO.SUGGESTED_VENDOR_NAME,        PoRequisitionLineEO.SUGGESTED_VENDOR_LOCATION,        PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT,        PoRequisitionLineEO.SUGGESTED_VENDOR_PHONE,        PoRequisitionLineEO.SUGGESTED_VENDOR_PRODUCT_CODE,        PoRequisitionLineEO.UN_NUMBER_ID,        PoRequisitionLineEO.HAZARD_CLASS_ID,        PoRequisitionLineEO.MUST_USE_SUGG_VENDOR_FLAG,        PoRequisitionLineEO.REFERENCE_NUM,        PoRequisitionLineEO.ON_RFQ_FLAG,        PoRequisitionLineEO.URGENT_FLAG,        PoRequisitionLineEO.CANCEL_FLAG,        PoRequisitionLineEO.SOURCE_ORGANIZATION_ID,        PoRequisitionLineEO.SOURCE_SUBINVENTORY,        PoRequisitionLineEO.DESTINATION_TYPE_CODE,        PoRequisitionLineEO.DESTINATION_ORGANIZATION_ID,        PoRequisitionLineEO.DESTINATION_SUBINVENTORY,        PoRequisitionLineEO.QUANTITY_CANCELLED,        PoRequisitionLineEO.CANCEL_DATE,        PoRequisitionLineEO.CANCEL_REASON,        PoRequisitionLineEO.CLOSED_CODE,        PoRequisitionLineEO.AGENT_RETURN_NOTE,        PoRequisitionLineEO.CHANGED_AFTER_RESEARCH_FLAG,        PoRequisitionLineEO.VENDOR_ID,        PoRequisitionLineEO.VENDOR_SITE_ID,        PoRequisitionLineEO.VENDOR_CONTACT_ID,        PoRequisitionLineEO.RESEARCH_AGENT_ID,        PoRequisitionLineEO.ON_LINE_FLAG,        PoRequisitionLineEO.WIP_ENTITY_ID,        PoRequisitionLineEO.WIP_LINE_ID,        PoRequisitionLineEO.WIP_REPETITIVE_SCHEDULE_ID,        PoRequisitionLineEO.WIP_OPERATION_SEQ_NUM,        PoRequisitionLineEO.WIP_RESOURCE_SEQ_NUM,        PoRequisitionLineEO.ATTRIBUTE_CATEGORY,        PoRequisitionLineEO.DESTINATION_CONTEXT,        PoRequisitionLineEO.INVENTORY_SOURCE_CONTEXT,        PoRequisitionLineEO.VENDOR_SOURCE_CONTEXT,        PoRequisitionLineEO.BOM_RESOURCE_ID,        PoRequisitionLineEO.REQUEST_ID,        PoRequisitionLineEO.PROGRAM_APPLICATION_ID,        PoRequisitionLineEO.PROGRAM_ID,        PoRequisitionLineEO.PROGRAM_UPDATE_DATE,        PoRequisitionLineEO.USSGL_TRANSACTION_CODE,        PoRequisitionLineEO.GOVERNMENT_CONTEXT,        PoRequisitionLineEO.CLOSED_REASON,        PoRequisitionLineEO.CLOSED_DATE,        PoRequisitionLineEO.TRANSACTION_REASON_CODE,        PoRequisitionLineEO.QUANTITY_RECEIVED,        PoRequisitionLineEO.SOURCE_REQ_LINE_ID,        PoRequisitionLineEO.ORG_ID,        PoRequisitionLineEO.KANBAN_CARD_ID,        PoRequisitionLineEO.CATALOG_TYPE,        PoRequisitionLineEO.CATALOG_SOURCE,        PoRequisitionLineEO.MANUFACTURER_ID,        PoRequisitionLineEO.MANUFACTURER_NAME,        PoRequisitionLineEO.MANUFACTURER_PART_NUMBER,        PoRequisitionLineEO.REQUESTER_EMAIL,        PoRequisitionLineEO.REQUESTER_FAX,        PoRequisitionLineEO.REQUESTER_PHONE,        PoRequisitionLineEO.UNSPSC_CODE,        PoRequisitionLineEO.OTHER_CATEGORY_CODE,        PoRequisitionLineEO.SUPPLIER_DUNS,        PoRequisitionLineEO.TAX_STATUS_INDICATOR,        PoRequisitionLineEO.PCARD_FLAG,        PoRequisitionLineEO.NEW_SUPPLIER_FLAG,        PoRequisitionLineEO.AUTO_RECEIVE_FLAG,        PoRequisitionLineEO.TAX_USER_OVERRIDE_FLAG,        PoRequisitionLineEO.TAX_CODE_ID,        PoRequisitionLineEO.NOTE_TO_VENDOR,        PoRequisitionLineEO.OKE_CONTRACT_VERSION_ID,        PoRequisitionLineEO.OKE_CONTRACT_HEADER_ID,        PoRequisitionLineEO.ITEM_SOURCE_ID,        PoRequisitionLineEO.SUPPLIER_REF_NUMBER,        PoRequisitionLineEO.SECONDARY_UNIT_OF_MEASURE,        PoRequisitionLineEO.SECONDARY_QUANTITY,        PoRequisitionLineEO.PREFERRED_GRADE,        PoRequisitionLineEO.SECONDARY_QUANTITY_RECEIVED,        PoRequisitionLineEO.SECONDARY_QUANTITY_CANCELLED,        PoRequisitionLineEO.AUCTION_HEADER_ID,        PoRequisitionLineEO.AUCTION_DISPLAY_NUMBER,        PoRequisitionLineEO.AUCTION_LINE_NUMBER,        PoRequisitionLineEO.REQS_IN_POOL_FLAG,        PoRequisitionLineEO.VMI_FLAG,        PoRequisitionLineEO.ATTRIBUTE1,        PoRequisitionLineEO.ATTRIBUTE2,        PoRequisitionLineEO.ATTRIBUTE3,        PoRequisitionLineEO.ATTRIBUTE4,        PoRequisitionLineEO.ATTRIBUTE5,        PoRequisitionLineEO.ATTRIBUTE6,        PoRequisitionLineEO.ATTRIBUTE7,        PoRequisitionLineEO.ATTRIBUTE8,        PoRequisitionLineEO.ATTRIBUTE9,        PoRequisitionLineEO.ATTRIBUTE10,        PoRequisitionLineEO.ATTRIBUTE11,        PoRequisitionLineEO.ATTRIBUTE12,        PoRequisitionLineEO.ATTRIBUTE13,        PoRequisitionLineEO.ATTRIBUTE14,        PoRequisitionLineEO.ATTRIBUTE15,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE1,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE2,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE3,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE4,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE5,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE6,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE7,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE8,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE9,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE10,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE11,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE12,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE13,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE14,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE15,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE16,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE17,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE18,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE19,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE20,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE_CATEGORY,        PoRequisitionLineEO.BID_NUMBER,        PoRequisitionLineEO.BID_LINE_NUMBER,        PoRequisitionLineEO.AMOUNT,        PoRequisitionLineEO.CURRENCY_AMOUNT,        PoRequisitionLineEO.NONCAT_TEMPLATE_ID,        PoRequisitionLineEO.JOB_ID,        PoRequisitionLineEO.CONTACT_INFORMATION,        PoRequisitionLineEO.CANDIDATE_SCREENING_REQD_FLAG,        PoRequisitionLineEO.SUGGESTED_SUPPLIER_FLAG,        PoRequisitionLineEO.ASSIGNMENT_END_DATE,        PoRequisitionLineEO.OVERTIME_ALLOWED_FLAG,        PoRequisitionLineEO.CONTRACTOR_REQUISITION_FLAG,        PoRequisitionLineEO.LABOR_REQ_LINE_ID,        PoRequisitionLineEO.JOB_LONG_DESCRIPTION,        PoRequisitionLineEO.CONTRACTOR_STATUS,        PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_FAX,        PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_EMAIL,        PoRequisitionLineEO.CANDIDATE_FIRST_NAME,        PoRequisitionLineEO.CANDIDATE_LAST_NAME,        PoRequisitionLineEO.ASSIGNMENT_START_DATE,        PoRequisitionLineEO.ORDER_TYPE_LOOKUP_CODE,        PoRequisitionLineEO.PURCHASE_BASIS,        PoRequisitionLineEO.MATCHING_BASIS,        PoRequisitionLineEO.NEGOTIATED_BY_PREPARER_FLAG,        PoRequisitionLineEO.BASE_UNIT_PRICE,        PoRequisitionLineEO.AT_SOURCING_FLAG,        PoRequisitionLineEO.TAX_ATTRIBUTE_UPDATE_CODE,        PoRequisitionLineEO.DROP_SHIP_FLAG,        PoRequisitionLineEO.SHIP_METHOD,        PoRequisitionLineEO.ESTIMATED_PICKUP_DATE,        PoRequisitionLineEO.SUPPLIER_NOTIFIED_FOR_CANCEL,        PoRequisitionLineEO.TAX_NAME FROM PO_REQUISITION_LINES_ALL PoRequisitionLineEO) QRSLT  WHERE (nvl(closed_code, 'N') <> 'FINALLY CLOSED' AND nvl(cancel_flag, 'N') = 'N' AND nvl(modified_by_agent_flag, 'N') = 'N' AND line_location_id IS NULL AND ((SELECT nvl(transferred_to_oe_flag, 'N')      FROM po_requisition_headers_all h      WHERE h.requisition_header_id = PoRequisitionLineEO.requisition_header_id)      <> 'Y' OR      source_type_code = 'VENDOR')) AND REQUISITION_HEADER_ID = :1
  6. 0

    R12.1.3 - Error when searching for customer simple search - JBO-27022: Fail

    Oracle Community | 6 years ago | sseth29
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 37 with java object of type java.lang.String due to java.sql.SQLException.

    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 POREQUISITIONLINEEO.REQUISITION_LINE_ID, POREQUISITIONLINEEO.REQUISITION_HEADER_ID, POREQUISITIONLINEEO.LINE_NUM, POREQUISITIONLINEEO.LAST_UPDATE_DATE, POREQUISITIONLINEEO.LAST_UPDATED_BY, POREQUISITIONLINEEO.LAST_UPDATE_LOGIN, POREQUISITIONLINEEO.CREATION_DATE, POREQUISITIONLINEEO.CREATED_BY, POREQUISITIONLINEEO.DELIVER_TO_LOCATION_ID, POREQUISITIONLINEEO.TO_PERSON_ID, POREQUISITIONLINEEO.ITEM_DESCRIPTION, POREQUISITIONLINEEO.CATEGORY_ID, POREQUISITIONLINEEO.UNIT_MEAS_LOOKUP_CODE, POREQUISITIONLINEEO.UNIT_PRICE, POREQUISITIONLINEEO.QUANTITY, POREQUISITIONLINEEO.LINE_TYPE_ID, POREQUISITIONLINEEO.SOURCE_TYPE_CODE, POREQUISITIONLINEEO.ITEM_ID, POREQUISITIONLINEEO.ITEM_REVISION, POREQUISITIONLINEEO.QUANTITY_DELIVERED, POREQUISITIONLINEEO.SUGGESTED_BUYER_ID, POREQUISITIONLINEEO.ENCUMBERED_FLAG, POREQUISITIONLINEEO.RFQ_REQUIRED_FLAG, POREQUISITIONLINEEO.NEED_BY_DATE, POREQUISITIONLINEEO.LINE_LOCATION_ID, POREQUISITIONLINEEO.MODIFIED_BY_AGENT_FLAG, POREQUISITIONLINEEO.PARENT_REQ_LINE_ID, POREQUISITIONLINEEO.JUSTIFICATION, POREQUISITIONLINEEO.NOTE_TO_AGENT, POREQUISITIONLINEEO.NOTE_TO_RECEIVER, POREQUISITIONLINEEO.PURCHASING_AGENT_ID, POREQUISITIONLINEEO.DOCUMENT_TYPE_CODE, POREQUISITIONLINEEO.BLANKET_PO_HEADER_ID, POREQUISITIONLINEEO.BLANKET_PO_LINE_NUM, POREQUISITIONLINEEO.CURRENCY_CODE, POREQUISITIONLINEEO.RATE_TYPE, POREQUISITIONLINEEO.RATE_DATE, POREQUISITIONLINEEO.RATE, POREQUISITIONLINEEO.CURRENCY_UNIT_PRICE, POREQUISITIONLINEEO.SUGGESTED_VENDOR_NAME, POREQUISITIONLINEEO.SUGGESTED_VENDOR_LOCATION, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT, POREQUISITIONLINEEO.SUGGESTED_VENDOR_PHONE, POREQUISITIONLINEEO.SUGGESTED_VENDOR_PRODUCT_CODE, POREQUISITIONLINEEO.UN_NUMBER_ID, POREQUISITIONLINEEO.HAZARD_CLASS_ID, POREQUISITIONLINEEO.MUST_USE_SUGG_VENDOR_FLAG, POREQUISITIONLINEEO.REFERENCE_NUM, POREQUISITIONLINEEO.ON_RFQ_FLAG, POREQUISITIONLINEEO.URGENT_FLAG, POREQUISITIONLINEEO.CANCEL_FLAG, POREQUISITIONLINEEO.SOURCE_ORGANIZATION_ID, POREQUISITIONLINEEO.SOURCE_SUBINVENTORY, POREQUISITIONLINEEO.DESTINATION_TYPE_CODE, POREQUISITIONLINEEO.DESTINATION_ORGANIZATION_ID, POREQUISITIONLINEEO.DESTINATION_SUBINVENTORY, POREQUISITIONLINEEO.QUANTITY_CANCELLED, POREQUISITIONLINEEO.CANCEL_DATE, POREQUISITIONLINEEO.CANCEL_REASON, POREQUISITIONLINEEO.CLOSED_CODE, POREQUISITIONLINEEO.AGENT_RETURN_NOTE, POREQUISITIONLINEEO.CHANGED_AFTER_RESEARCH_FLAG, POREQUISITIONLINEEO.VENDOR_ID, POREQUISITIONLINEEO.VENDOR_SITE_ID, POREQUISITIONLINEEO.VENDOR_CONTACT_ID, POREQUISITIONLINEEO.RESEARCH_AGENT_ID, POREQUISITIONLINEEO.ON_LINE_FLAG, POREQUISITIONLINEEO.WIP_ENTITY_ID, POREQUISITIONLINEEO.WIP_LINE_ID, POREQUISITIONLINEEO.WIP_REPETITIVE_SCHEDULE_ID, POREQUISITIONLINEEO.WIP_OPERATION_SEQ_NUM, POREQUISITIONLINEEO.WIP_RESOURCE_SEQ_NUM, POREQUISITIONLINEEO.ATTRIBUTE_CATEGORY, POREQUISITIONLINEEO.DESTINATION_CONTEXT, POREQUISITIONLINEEO.INVENTORY_SOURCE_CONTEXT, POREQUISITIONLINEEO.VENDOR_SOURCE_CONTEXT, POREQUISITIONLINEEO.BOM_RESOURCE_ID, POREQUISITIONLINEEO.REQUEST_ID, POREQUISITIONLINEEO.PROGRAM_APPLICATION_ID, POREQUISITIONLINEEO.PROGRAM_ID, POREQUISITIONLINEEO.PROGRAM_UPDATE_DATE, POREQUISITIONLINEEO.USSGL_TRANSACTION_CODE, POREQUISITIONLINEEO.GOVERNMENT_CONTEXT, POREQUISITIONLINEEO.CLOSED_REASON, POREQUISITIONLINEEO.CLOSED_DATE, POREQUISITIONLINEEO.TRANSACTION_REASON_CODE, POREQUISITIONLINEEO.QUANTITY_RECEIVED, POREQUISITIONLINEEO.SOURCE_REQ_LINE_ID, POREQUISITIONLINEEO.ORG_ID, POREQUISITIONLINEEO.KANBAN_CARD_ID, POREQUISITIONLINEEO.CATALOG_TYPE, POREQUISITIONLINEEO.CATALOG_SOURCE, POREQUISITIONLINEEO.MANUFACTURER_ID, POREQUISITIONLINEEO.MANUFACTURER_NAME, POREQUISITIONLINEEO.MANUFACTURER_PART_NUMBER, POREQUISITIONLINEEO.REQUESTER_EMAIL, POREQUISITIONLINEEO.REQUESTER_FAX, POREQUISITIONLINEEO.REQUESTER_PHONE, POREQUISITIONLINEEO.UNSPSC_CODE, POREQUISITIONLINEEO.OTHER_CATEGORY_CODE, POREQUISITIONLINEEO.SUPPLIER_DUNS, POREQUISITIONLINEEO.TAX_STATUS_INDICATOR, POREQUISITIONLINEEO.PCARD_FLAG, POREQUISITIONLINEEO.NEW_SUPPLIER_FLAG, POREQUISITIONLINEEO.AUTO_RECEIVE_FLAG, POREQUISITIONLINEEO.TAX_USER_OVERRIDE_FLAG, POREQUISITIONLINEEO.TAX_CODE_ID, POREQUISITIONLINEEO.NOTE_TO_VENDOR, POREQUISITIONLINEEO.OKE_CONTRACT_VERSION_ID, POREQUISITIONLINEEO.OKE_CONTRACT_HEADER_ID, POREQUISITIONLINEEO.ITEM_SOURCE_ID, POREQUISITIONLINEEO.SUPPLIER_REF_NUMBER, POREQUISITIONLINEEO.SECONDARY_UNIT_OF_MEASURE, POREQUISITIONLINEEO.SECONDARY_QUANTITY, POREQUISITIONLINEEO.PREFERRED_GRADE, POREQUISITIONLINEEO.SECONDARY_QUANTITY_RECEIVED, POREQUISITIONLINEEO.SECONDARY_QUANTITY_CANCELLED, POREQUISITIONLINEEO.AUCTION_HEADER_ID, POREQUISITIONLINEEO.AUCTION_DISPLAY_NUMBER, POREQUISITIONLINEEO.AUCTION_LINE_NUMBER, POREQUISITIONLINEEO.REQS_IN_POOL_FLAG, POREQUISITIONLINEEO.VMI_FLAG, POREQUISITIONLINEEO.ATTRIBUTE1, POREQUISITIONLINEEO.ATTRIBUTE2, POREQUISITIONLINEEO.ATTRIBUTE3, POREQUISITIONLINEEO.ATTRIBUTE4, POREQUISITIONLINEEO.ATTRIBUTE5, POREQUISITIONLINEEO.ATTRIBUTE6, POREQUISITIONLINEEO.ATTRIBUTE7, POREQUISITIONLINEEO.ATTRIBUTE8, POREQUISITIONLINEEO.ATTRIBUTE9, POREQUISITIONLINEEO.ATTRIBUTE10, POREQUISITIONLINEEO.ATTRIBUTE11, POREQUISITIONLINEEO.ATTRIBUTE12, POREQUISITIONLINEEO.ATTRIBUTE13, POREQUISITIONLINEEO.ATTRIBUTE14, POREQUISITIONLINEEO.ATTRIBUTE15, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE1, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE2, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE3, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE4, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE5, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE6, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE7, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE8, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE9, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE10, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE11, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE12, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE13, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE14, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE15, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE16, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE17, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE18, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE19, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE20, POREQUISITIONLINEEO.GLOBAL_ATTRIBUTE_CATEGORY, POREQUISITIONLINEEO.BID_NUMBER, POREQUISITIONLINEEO.BID_LINE_NUMBER, POREQUISITIONLINEEO.AMOUNT, POREQUISITIONLINEEO.CURRENCY_AMOUNT, POREQUISITIONLINEEO.NONCAT_TEMPLATE_ID, POREQUISITIONLINEEO.JOB_ID, POREQUISITIONLINEEO.CONTACT_INFORMATION, POREQUISITIONLINEEO.CANDIDATE_SCREENING_REQD_FLAG, POREQUISITIONLINEEO.SUGGESTED_SUPPLIER_FLAG, POREQUISITIONLINEEO.ASSIGNMENT_END_DATE, POREQUISITIONLINEEO.OVERTIME_ALLOWED_FLAG, POREQUISITIONLINEEO.CONTRACTOR_REQUISITION_FLAG, POREQUISITIONLINEEO.LABOR_REQ_LINE_ID, POREQUISITIONLINEEO.JOB_LONG_DESCRIPTION, POREQUISITIONLINEEO.CONTRACTOR_STATUS, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT_FAX, POREQUISITIONLINEEO.SUGGESTED_VENDOR_CONTACT_EMAIL, POREQUISITIONLINEEO.CANDIDATE_FIRST_NAME, POREQUISITIONLINEEO.CANDIDATE_LAST_NAME, POREQUISITIONLINEEO.ASSIGNMENT_START_DATE, POREQUISITIONLINEEO.ORDER_TYPE_LOOKUP_CODE, POREQUISITIONLINEEO.PURCHASE_BASIS, POREQUISITIONLINEEO.MATCHING_BASIS, POREQUISITIONLINEEO.NEGOTIATED_BY_PREPARER_FLAG, POREQUISITIONLINEEO.BASE_UNIT_PRICE, POREQUISITIONLINEEO.AT_SOURCING_FLAG, POREQUISITIONLINEEO.TAX_ATTRIBUTE_UPDATE_CODE, POREQUISITIONLINEEO.DROP_SHIP_FLAG, POREQUISITIONLINEEO.SHIP_METHOD, POREQUISITIONLINEEO.ESTIMATED_PICKUP_DATE, POREQUISITIONLINEEO.SUPPLIER_NOTIFIED_FOR_CANCEL, POREQUISITIONLINEEO.TAX_NAME, POREQUISITIONLINEEO.REQUISITION_HEADER_ID BUDGET_AMOUNT, POREQUISITIONLINEEO.REQUISITION_HEADER_ID ACTUAL_SPEND, POREQUISITIONLINEEO.REQUISITION_HEADER_ID SPEND_IN_PROCESS, POREQUISITIONLINEEO.REQUISITION_HEADER_ID VARIANCE_COLUMN FROM PO_REQUISITION_LINES_ALL POREQUISITIONLINEEO) QRSLT WHERE (nvl(closed_code, 'N') <> 'FINALLY CLOSED' AND nvl(cancel_flag, 'N') = 'N' AND nvl(modified_by_agent_flag, 'N') = 'N' AND line_location_id IS NULL AND ((SELECT nvl(transferred_to_oe_flag, 'N') FROM po_requisition_headers_all h WHERE h.requisition_header_id = PoRequisitionLineEO.requisition_header_id) <> 'Y' OR source_type_code = 'VENDOR')) AND REQUISITION_HEADER_ID = :Bind_RequisitionHeaderId

      at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
      2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
      3 frames
    3. oracle.apps.icx
      CheckoutSummaryCO.processRequest
      1. oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:972)
      2. oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:232)
      3. oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:150)
      4. oracle.apps.icx.por.req.webui.CheckoutSummaryCO.executePrepareForDisplay(CheckoutSummaryCO.java:175)
      5. oracle.apps.icx.por.req.webui.CheckoutSummaryCO.processRequest(CheckoutSummaryCO.java:109)
      5 frames
    4. xxinc.oracle.apps
      XXINCCheckoutSummaryCO.processRequest
      1. xxinc.oracle.apps.xxinc.icx.por.req.webui.XXINCCheckoutSummaryCO.processRequest(XXINCCheckoutSummaryCO.java:42)
      1 frame
    5. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      18 frames
    6. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:212)
      1 frame
    7. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    8. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    10. com.evermind.server
      ServletRequestDispatcher$2.oc4jRun
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
      5 frames
    11. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
      1 frame
    12. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
      2 frames
    13. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:221)
      1 frame
    14. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    15. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    16. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    17. com.evermind.server
      ServletRequestDispatcher$2.oc4jRun
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
      5 frames
    18. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
      1 frame
    19. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
      2 frames
    20. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:221)
      1 frame
    21. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    22. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    23. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    24. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    25. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    26. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    27. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    28. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    29. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    30. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    31. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame