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,'999' PackSize 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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Error While extending PoRequisitionLinesVO
    via by Hanimi,
  • Extending VO
    via by 596756,
  • AFter VO Extension , error is coming
    via by 3021894,
  • help.define purchasing options
    via by fred.jiang,
  • WhO column error in OAF page
    via by user9952568,
    • 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,'999' PackSize 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(OAException.java:980) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720) at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:972) at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:232) at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:150) at oracle.apps.icx.por.req.webui.BaseShoppingCartCO.loadReq(BaseShoppingCartCO.java:510) at oracle.apps.icx.por.req.webui.ShoppingCartCO.processRequest(ShoppingCartCO.java:74) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,