Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. ClientUtil.invokeMethod() has thrown an OAException
    Unsorted
    0
    0
    0
  2. OAApplicationModuleImpl.invokeMethod() has thrown an OAException
    Unsorted
    0
    0
    0

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT REQUISITION_LINE_ID, REQUISITION_HEADER_ID, LINE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, DELIVER_TO_LOCATION_ID, TO_PERSON_ID, ITEM_DESCRIPTION, CATEGORY_ID, UNIT_MEAS_LOOKUP_CODE, UNIT_PRICE, QUANTITY, LINE_TYPE_ID, SOURCE_TYPE_CODE, ITEM_ID, ITEM_REVISION, QUANTITY_DELIVERED, SUGGESTED_BUYER_ID, ENCUMBERED_FLAG, RFQ_REQUIRED_FLAG, NEED_BY_DATE, LINE_LOCATION_ID, MODIFIED_BY_AGENT_FLAG, PARENT_REQ_LINE_ID, JUSTIFICATION, NOTE_TO_AGENT, NOTE_TO_RECEIVER, PURCHASING_AGENT_ID, DOCUMENT_TYPE_CODE, BLANKET_PO_HEADER_ID, BLANKET_PO_LINE_NUM, CURRENCY_CODE, RATE_TYPE, RATE_DATE, RATE, CURRENCY_UNIT_PRICE, SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_LOCATION, SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_PRODUCT_CODE, UN_NUMBER_ID, HAZARD_CLASS_ID, MUST_USE_SUGG_VENDOR_FLAG, REFERENCE_NUM, ON_RFQ_FLAG, URGENT_FLAG, CANCEL_FLAG, SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY, DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY, QUANTITY_CANCELLED, CANCEL_DATE, CANCEL_REASON, CLOSED_CODE, AGENT_RETURN_NOTE, CHANGED_AFTER_RESEARCH_FLAG, VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, RESEARCH_AGENT_ID, ON_LINE_FLAG, WIP_ENTITY_ID, WIP_LINE_ID, WIP_REPETITIVE_SCHEDULE_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, ATTRIBUTE_CATEGORY, DESTINATION_CONTEXT, INVENTORY_SOURCE_CONTEXT, VENDOR_SOURCE_CONTEXT, BOM_RESOURCE_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT, CLOSED_REASON, CLOSED_DATE, TRANSACTION_REASON_CODE, QUANTITY_RECEIVED, SOURCE_REQ_LINE_ID, ORG_ID, KANBAN_CARD_ID, CATALOG_TYPE, CATALOG_SOURCE, MANUFACTURER_ID, MANUFACTURER_NAME, MANUFACTURER_PART_NUMBER, REQUESTER_EMAIL, REQUESTER_FAX, REQUESTER_PHONE, UNSPSC_CODE, OTHER_CATEGORY_CODE, SUPPLIER_DUNS, TAX_STATUS_INDICATOR, PCARD_FLAG, NEW_SUPPLIER_FLAG, AUTO_RECEIVE_FLAG, TAX_USER_OVERRIDE_FLAG, TAX_CODE_ID, NOTE_TO_VENDOR, OKE_CONTRACT_VERSION_ID, OKE_CONTRACT_HEADER_ID, ITEM_SOURCE_ID, SUPPLIER_REF_NUMBER, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_CANCELLED, AUCTION_HEADER_ID, AUCTION_DISPLAY_NUMBER, AUCTION_LINE_NUMBER, REQS_IN_POOL_FLAG, VMI_FLAG, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, BID_NUMBER, BID_LINE_NUMBER, AMOUNT, CURRENCY_AMOUNT, NONCAT_TEMPLATE_ID, JOB_ID, CONTACT_INFORMATION, CANDIDATE_SCREENING_REQD_FLAG, SUGGESTED_SUPPLIER_FLAG, ASSIGNMENT_END_DATE, OVERTIME_ALLOWED_FLAG, CONTRACTOR_REQUISITION_FLAG, LABOR_REQ_LINE_ID, JOB_LONG_DESCRIPTION, CONTRACTOR_STATUS, SUGGESTED_VENDOR_CONTACT_FAX, SUGGESTED_VENDOR_CONTACT_EMAIL, CANDIDATE_FIRST_NAME, CANDIDATE_LAST_NAME, ASSIGNMENT_START_DATE, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, MATCHING_BASIS, NEGOTIATED_BY_PREPARER_FLAG, BASE_UNIT_PRICE, AT_SOURCING_FLAG, TAX_ATTRIBUTE_UPDATE_CODE, DROP_SHIP_FLAG, SHIP_METHOD, ESTIMATED_PICKUP_DATE, SUPPLIER_NOTIFIED_FOR_CANCEL, TAX_NAME, DECODE(SOURCE_TYPE_CODE, 'VENDOR', 'Externe', 'INVENTORY', 'Interne', SOURCE_TYPE_CODE) xxOrigine FROM PO_REQUISITION_LINES_ALL) 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
2 matching frames hidden
    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.icatalog.shopping.webui.ShoppingClientHelper.addToReqs(ShoppingClientHelper.java:258)
    at oracle.apps.icx.icatalog.shopping.webui.ShoppingClientHelper.addToReqsForSearchResults(ShoppingClientHelper.java:1381)
3 frames hidden

External results for this pattern (10)

  1. 3021894via Oracle Community4 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: null
    Show stack trace
  2. Naveen Gudalavia Oracle Community4 months ago
    java.lang.Exception: There is no current requisition. Checkout cannot proceed.
    Show stack trace
  3. 596756via Oracle Community4 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: 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, atcllc.atcpo_generic_price.is_price_updateable(PoRequisitionLineEO.BLANKET_PO_HEADER_ID, PoRequisitionLineEO.BLANKET_PO_LINE_NUM) AS atcpo_is_price_updateable FROM PO_REQUISITION_LINES_ALL PoRequisitionLineEO WHERE PoRequisitionLineEO.REQUISITION_HEADER_ID = :Bind_RequisitionHeaderId
    Show stack trace
  4. 593502via Oracle Community4 months ago
    java.lang.NullPointerException
    Show stack trace
  5. 3021894via Oracle Community1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: null
    Show stack trace
  6. 1977211via Oracle Community2 years ago
    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
    Show stack trace
  7. Azadare Mvia Oracle Community2 years ago
    oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value PoRequisitionLinesVO for source passed to method ViewLinkImpl.setSource. Explanation: view def mismatch
    Show stack trace
  8. Azadare Mvia Oracle Community2 years ago
    java.lang.Exception: There is no current requisition. Checkout cannot proceed.
    Show stack trace
  9. user12003600via Oracle Community2 years ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT REQUISITION_LINE_ID, REQUISITION_HEADER_ID, LINE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, DELIVER_TO_LOCATION_ID, TO_PERSON_ID, ITEM_DESCRIPTION, CATEGORY_ID, UNIT_MEAS_LOOKUP_CODE, UNIT_PRICE, QUANTITY, LINE_TYPE_ID, SOURCE_TYPE_CODE, ITEM_ID, ITEM_REVISION, QUANTITY_DELIVERED, SUGGESTED_BUYER_ID, ENCUMBERED_FLAG, RFQ_REQUIRED_FLAG, NEED_BY_DATE, LINE_LOCATION_ID, MODIFIED_BY_AGENT_FLAG, PARENT_REQ_LINE_ID, JUSTIFICATION, NOTE_TO_AGENT, NOTE_TO_RECEIVER, PURCHASING_AGENT_ID, DOCUMENT_TYPE_CODE, BLANKET_PO_HEADER_ID, BLANKET_PO_LINE_NUM, CURRENCY_CODE, RATE_TYPE, RATE_DATE, RATE, CURRENCY_UNIT_PRICE, SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_LOCATION, SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_PRODUCT_CODE, UN_NUMBER_ID, HAZARD_CLASS_ID, MUST_USE_SUGG_VENDOR_FLAG, REFERENCE_NUM, ON_RFQ_FLAG, URGENT_FLAG, CANCEL_FLAG, SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY, DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY, QUANTITY_CANCELLED, CANCEL_DATE, CANCEL_REASON, CLOSED_CODE, AGENT_RETURN_NOTE, CHANGED_AFTER_RESEARCH_FLAG, VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, RESEARCH_AGENT_ID, ON_LINE_FLAG, WIP_ENTITY_ID, WIP_LINE_ID, WIP_REPETITIVE_SCHEDULE_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, ATTRIBUTE_CATEGORY, DESTINATION_CONTEXT, INVENTORY_SOURCE_CONTEXT, VENDOR_SOURCE_CONTEXT, BOM_RESOURCE_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT, CLOSED_REASON, CLOSED_DATE, TRANSACTION_REASON_CODE, QUANTITY_RECEIVED, SOURCE_REQ_LINE_ID, ORG_ID, KANBAN_CARD_ID, CATALOG_TYPE, CATALOG_SOURCE, MANUFACTURER_ID, MANUFACTURER_NAME, MANUFACTURER_PART_NUMBER, REQUESTER_EMAIL, REQUESTER_FAX, REQUESTER_PHONE, UNSPSC_CODE, OTHER_CATEGORY_CODE, SUPPLIER_DUNS, TAX_STATUS_INDICATOR, PCARD_FLAG, NEW_SUPPLIER_FLAG, AUTO_RECEIVE_FLAG, TAX_USER_OVERRIDE_FLAG, TAX_CODE_ID, NOTE_TO_VENDOR, OKE_CONTRACT_VERSION_ID, OKE_CONTRACT_HEADER_ID, ITEM_SOURCE_ID, SUPPLIER_REF_NUMBER, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_CANCELLED, AUCTION_HEADER_ID, AUCTION_DISPLAY_NUMBER, AUCTION_LINE_NUMBER, REQS_IN_POOL_FLAG, VMI_FLAG, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, BID_NUMBER, BID_LINE_NUMBER, AMOUNT, CURRENCY_AMOUNT, NONCAT_TEMPLATE_ID, JOB_ID, CONTACT_INFORMATION, CANDIDATE_SCREENING_REQD_FLAG, SUGGESTED_SUPPLIER_FLAG, ASSIGNMENT_END_DATE, OVERTIME_ALLOWED_FLAG, CONTRACTOR_REQUISITION_FLAG, LABOR_REQ_LINE_ID, JOB_LONG_DESCRIPTION, CONTRACTOR_STATUS, SUGGESTED_VENDOR_CONTACT_FAX, SUGGESTED_VENDOR_CONTACT_EMAIL, CANDIDATE_FIRST_NAME, CANDIDATE_LAST_NAME, ASSIGNMENT_START_DATE, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, MATCHING_BASIS, NEGOTIATED_BY_PREPARER_FLAG, BASE_UNIT_PRICE, AT_SOURCING_FLAG, TAX_ATTRIBUTE_UPDATE_CODE, DROP_SHIP_FLAG, SHIP_METHOD, ESTIMATED_PICKUP_DATE, SUPPLIER_NOTIFIED_FOR_CANCEL, TAX_NAME, DECODE(SOURCE_TYPE_CODE, 'VENDOR', 'Externe', 'INVENTORY', 'Interne', SOURCE_TYPE_CODE) xxOrigine FROM PO_REQUISITION_LINES_ALL) 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
    Show stack trace
  10. 477721via Oracle Community2 years ago
    oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Update": SQL Statement " UPDATE PO_REQ_DISTRIBUTIONS_ALL PoReqDistributionEO SET LAST_UPDATE_DATE=:1,LAST_UPDATED_BY=:2,LAST_UPDATE_LOGIN=:3,CODE_COMBINATION_ID=:4 WHERE DISTRIBUTION_ID=:5".
    Show stack trace