oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.REQ_CAN_AUTHORIZE, PoSystemParameterEO.INSPECTION_REQUIRED_FLAG, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE, PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE, PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE, PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_PO_NUM_CODE, PoSystemParameterEO.MANUAL_PO_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_REQ_NUM_CODE, PoSystemParameterEO.MANUAL_REQ_NUM_TYPE, PoSystemParameterEO.DEFAULT_QUOTE_WARNING_DELAY, PoSystemParameterEO.ENFORCE_BUYER_AUTHORITY_FLAG, PoSystemParameterEO.ENFORCE_BUYER_NAME_FLAG, PoSystemParameterEO.ENFORCE_VENDOR_HOLD_FLAG, PoSystemParameterEO.NOTIFY_IF_BLANKET_FLAG, PoSystemParameterEO.RFQ_REQUIRED_FLAG, PoSystemParameterEO.PO_DOCUMENT_REPORT_ID, PoSystemParameterEO.PO_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.RFQ_DOCUMENT_REPORT_ID, PoSystemParameterEO.RFQ_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.LINE_TYPE_ID, PoSystemParameterEO.RECEIVING_FLAG, PoSystemParameterEO.ALLOW_ITEM_DESC_UPDATE_FLAG, PoSystemParameterEO.DISPOSITION_WARNING_FLAG, PoSystemParameterEO.ENFORCE_FULL_LOT_QUANTITIES, PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID, PoSystemParameterEO.MIN_RELEASE_AMOUNT, PoSystemParameterEO.PRICE_TYPE_LOOKUP_CODE, PoSystemParameterEO.NOTIFICATION_WARNING_DELAY, PoSystemParameterEO.PRICE_BREAK_LOOKUP_CODE, PoSystemParameterEO.INVOICE_CLOSE_CODE, PoSystemParameterEO.RECEIVE_CLOSE_CODE, PoSystemParameterEO.INVOICE_CLOSE_TOLERANCE, PoSystemParameterEO.RECEIVE_CLOSE_TOLERANCE, PoSystemParameterEO.CANCEL_REQS_ON_PO_CANCEL_FLAG, PoSystemParameterEO.REQIMPORT_GROUP_BY_CODE, PoSystemParameterEO.EXPENSE_ACCRUAL_CODE, PoSystemParameterEO.INVENTORY_ACCRUAL_CODE, PoSystemParameterEO.ORDER_TYPE_ID, PoSystemParameterEO.ORDER_SOURCE_ID, PoSystemParameterEO.SALESREP_ID, PoSystemParameterEO.TERM_ID, PoSystemParameterEO.NEXT_APPROVER_LOOKUP_CODE, PoSystemParameterEO.GLOBAL_ATTRIBUTE1, PoSystemParameterEO.GLOBAL_ATTRIBUTE2, PoSystemParameterEO.GLOBAL_ATTRIBUTE3, PoSystemParameterEO.GLOBAL_ATTRIBUTE4, PoSystemParameterEO.GLOBAL_ATTRIBUTE5, PoSystemParameterEO.GLOBAL_ATTRIBUTE6, PoSystemParameterEO.GLOBAL_ATTRIBUTE7, PoSystemParameterEO.GLOBAL_ATTRIBUTE8, PoSystemParameterEO.GLOBAL_ATTRIBUTE9, PoSystemParameterEO.GLOBAL_ATTRIBUTE10, PoSystemParameterEO.GLOBAL_ATTRIBUTE11, PoSystemParameterEO.GLOBAL_ATTRIBUTE12, PoSystemParameterEO.GLOBAL_ATTRIBUTE13, PoSystemParameterEO.GLOBAL_ATTRIBUTE14, PoSystemParameterEO.GLOBAL_ATTRIBUTE15, PoSystemParameterEO.GLOBAL_ATTRIBUTE16, PoSystemParameterEO.GLOBAL_ATTRIBUTE17, PoSystemParameterEO.GLOBAL_ATTRIBUTE18, PoSystemParameterEO.GLOBAL_ATTRIBUTE19, PoSystemParameterEO.GLOBAL_ATTRIBUTE20, PoSystemParameterEO.GLOBAL_ATTRIBUTE_CATEGORY, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_AMOUNT, PoSystemParameterEO.PRICE_CHANGE_AMOUNT, PoSystemParameterEO.AUTO_OFFSET_METHOD, PoSystemParameterEO.PO_OUTPUT_FORMAT, PoSystemParameterEO.BUYING_COMPANY_IDENTIFIER, PoSystemParameterEO.GAPLESS_INV_NUM_FLAG, PoSystemParameterEO.MAX_ATTACHMENT_SIZE, PoSystemParameterEO.EMAIL_ATTACHMENT_FILENAME, ot.name as order_type, pltv.line_type, pps.name as position_structure_name FROM PO_SYSTEM_PARAMETERS_ALL PoSystemParameterEO, oe_transaction_types ot, po_line_types_val_v pltv, per_position_structures pps where PoSystemParameterEO.org_id = :1 and PoSystemParameterEO.ORDER_TYPE_ID = ot.transaction_type_id and nvl(ot.po_required_flag, 'N') = 'N' and nvl(ot.agreement_required_flag, 'N') = 'N' and PoSystemParameterEO.LINE_TYPE_ID = pltv.line_type_id and PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID = pps.position_structure_id

Oracle Community | 1498181 | 3 years ago
  1. 0

    java.sql.SQLException: Missing IN or OUT parameter at index:: 1

    Oracle Community | 3 years ago | 1498181
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.REQ_CAN_AUTHORIZE, PoSystemParameterEO.INSPECTION_REQUIRED_FLAG, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE, PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE, PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE, PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_PO_NUM_CODE, PoSystemParameterEO.MANUAL_PO_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_REQ_NUM_CODE, PoSystemParameterEO.MANUAL_REQ_NUM_TYPE, PoSystemParameterEO.DEFAULT_QUOTE_WARNING_DELAY, PoSystemParameterEO.ENFORCE_BUYER_AUTHORITY_FLAG, PoSystemParameterEO.ENFORCE_BUYER_NAME_FLAG, PoSystemParameterEO.ENFORCE_VENDOR_HOLD_FLAG, PoSystemParameterEO.NOTIFY_IF_BLANKET_FLAG, PoSystemParameterEO.RFQ_REQUIRED_FLAG, PoSystemParameterEO.PO_DOCUMENT_REPORT_ID, PoSystemParameterEO.PO_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.RFQ_DOCUMENT_REPORT_ID, PoSystemParameterEO.RFQ_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.LINE_TYPE_ID, PoSystemParameterEO.RECEIVING_FLAG, PoSystemParameterEO.ALLOW_ITEM_DESC_UPDATE_FLAG, PoSystemParameterEO.DISPOSITION_WARNING_FLAG, PoSystemParameterEO.ENFORCE_FULL_LOT_QUANTITIES, PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID, PoSystemParameterEO.MIN_RELEASE_AMOUNT, PoSystemParameterEO.PRICE_TYPE_LOOKUP_CODE, PoSystemParameterEO.NOTIFICATION_WARNING_DELAY, PoSystemParameterEO.PRICE_BREAK_LOOKUP_CODE, PoSystemParameterEO.INVOICE_CLOSE_CODE, PoSystemParameterEO.RECEIVE_CLOSE_CODE, PoSystemParameterEO.INVOICE_CLOSE_TOLERANCE, PoSystemParameterEO.RECEIVE_CLOSE_TOLERANCE, PoSystemParameterEO.CANCEL_REQS_ON_PO_CANCEL_FLAG, PoSystemParameterEO.REQIMPORT_GROUP_BY_CODE, PoSystemParameterEO.EXPENSE_ACCRUAL_CODE, PoSystemParameterEO.INVENTORY_ACCRUAL_CODE, PoSystemParameterEO.ORDER_TYPE_ID, PoSystemParameterEO.ORDER_SOURCE_ID, PoSystemParameterEO.SALESREP_ID, PoSystemParameterEO.TERM_ID, PoSystemParameterEO.NEXT_APPROVER_LOOKUP_CODE, PoSystemParameterEO.GLOBAL_ATTRIBUTE1, PoSystemParameterEO.GLOBAL_ATTRIBUTE2, PoSystemParameterEO.GLOBAL_ATTRIBUTE3, PoSystemParameterEO.GLOBAL_ATTRIBUTE4, PoSystemParameterEO.GLOBAL_ATTRIBUTE5, PoSystemParameterEO.GLOBAL_ATTRIBUTE6, PoSystemParameterEO.GLOBAL_ATTRIBUTE7, PoSystemParameterEO.GLOBAL_ATTRIBUTE8, PoSystemParameterEO.GLOBAL_ATTRIBUTE9, PoSystemParameterEO.GLOBAL_ATTRIBUTE10, PoSystemParameterEO.GLOBAL_ATTRIBUTE11, PoSystemParameterEO.GLOBAL_ATTRIBUTE12, PoSystemParameterEO.GLOBAL_ATTRIBUTE13, PoSystemParameterEO.GLOBAL_ATTRIBUTE14, PoSystemParameterEO.GLOBAL_ATTRIBUTE15, PoSystemParameterEO.GLOBAL_ATTRIBUTE16, PoSystemParameterEO.GLOBAL_ATTRIBUTE17, PoSystemParameterEO.GLOBAL_ATTRIBUTE18, PoSystemParameterEO.GLOBAL_ATTRIBUTE19, PoSystemParameterEO.GLOBAL_ATTRIBUTE20, PoSystemParameterEO.GLOBAL_ATTRIBUTE_CATEGORY, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_AMOUNT, PoSystemParameterEO.PRICE_CHANGE_AMOUNT, PoSystemParameterEO.AUTO_OFFSET_METHOD, PoSystemParameterEO.PO_OUTPUT_FORMAT, PoSystemParameterEO.BUYING_COMPANY_IDENTIFIER, PoSystemParameterEO.GAPLESS_INV_NUM_FLAG, PoSystemParameterEO.MAX_ATTACHMENT_SIZE, PoSystemParameterEO.EMAIL_ATTACHMENT_FILENAME, ot.name as order_type, pltv.line_type, pps.name as position_structure_name FROM PO_SYSTEM_PARAMETERS_ALL PoSystemParameterEO, oe_transaction_types ot, po_line_types_val_v pltv, per_position_structures pps where PoSystemParameterEO.org_id = :1 and PoSystemParameterEO.ORDER_TYPE_ID = ot.transaction_type_id and nvl(ot.po_required_flag, 'N') = 'N' and nvl(ot.agreement_required_flag, 'N') = 'N' and PoSystemParameterEO.LINE_TYPE_ID = pltv.line_type_id and PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID = pps.position_structure_id
  2. 0

    help.define purchasing options

    Oracle Community | 4 years ago | fred.jiang
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.REQ_CAN_AUTHORIZE, PoSystemParameterEO.INSPECTION_REQUIRED_FLAG, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE, PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE, PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE, PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_PO_NUM_CODE, PoSystemParameterEO.MANUAL_PO_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_REQ_NUM_CODE, PoSystemParameterEO.MANUAL_REQ_NUM_TYPE, PoSystemParameterEO.DEFAULT_QUOTE_WARNING_DELAY, PoSystemParameterEO.ENFORCE_BUYER_AUTHORITY_FLAG, PoSystemParameterEO.ENFORCE_BUYER_NAME_FLAG, PoSystemParameterEO.ENFORCE_VENDOR_HOLD_FLAG, PoSystemParameterEO.NOTIFY_IF_BLANKET_FLAG, PoSystemParameterEO.RFQ_REQUIRED_FLAG, PoSystemParameterEO.PO_DOCUMENT_REPORT_ID, PoSystemParameterEO.PO_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.RFQ_DOCUMENT_REPORT_ID, PoSystemParameterEO.RFQ_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.LINE_TYPE_ID, PoSystemParameterEO.RECEIVING_FLAG, PoSystemParameterEO.ALLOW_ITEM_DESC_UPDATE_FLAG, PoSystemParameterEO.DISPOSITION_WARNING_FLAG, PoSystemParameterEO.ENFORCE_FULL_LOT_QUANTITIES, PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID, PoSystemParameterEO.MIN_RELEASE_AMOUNT, PoSystemParameterEO.PRICE_TYPE_LOOKUP_CODE, PoSystemParameterEO.NOTIFICATION_WARNING_DELAY, PoSystemParameterEO.PRICE_BREAK_LOOKUP_CODE, PoSystemParameterEO.INVOICE_CLOSE_CODE, PoSystemParameterEO.RECEIVE_CLOSE_CODE, PoSystemParameterEO.INVOICE_CLOSE_TOLERANCE, PoSystemParameterEO.RECEIVE_CLOSE_TOLERANCE, PoSystemParameterEO.CANCEL_REQS_ON_PO_CANCEL_FLAG, PoSystemParameterEO.REQIMPORT_GROUP_BY_CODE, PoSystemParameterEO.EXPENSE_ACCRUAL_CODE, PoSystemParameterEO.INVENTORY_ACCRUAL_CODE, PoSystemParameterEO.ORDER_TYPE_ID, PoSystemParameterEO.ORDER_SOURCE_ID, PoSystemParameterEO.SALESREP_ID, PoSystemParameterEO.TERM_ID, PoSystemParameterEO.NEXT_APPROVER_LOOKUP_CODE, PoSystemParameterEO.GLOBAL_ATTRIBUTE1, PoSystemParameterEO.GLOBAL_ATTRIBUTE2, PoSystemParameterEO.GLOBAL_ATTRIBUTE3, PoSystemParameterEO.GLOBAL_ATTRIBUTE4, PoSystemParameterEO.GLOBAL_ATTRIBUTE5, PoSystemParameterEO.GLOBAL_ATTRIBUTE6, PoSystemParameterEO.GLOBAL_ATTRIBUTE7, PoSystemParameterEO.GLOBAL_ATTRIBUTE8, PoSystemParameterEO.GLOBAL_ATTRIBUTE9, PoSystemParameterEO.GLOBAL_ATTRIBUTE10, PoSystemParameterEO.GLOBAL_ATTRIBUTE11, PoSystemParameterEO.GLOBAL_ATTRIBUTE12, PoSystemParameterEO.GLOBAL_ATTRIBUTE13, PoSystemParameterEO.GLOBAL_ATTRIBUTE14, PoSystemParameterEO.GLOBAL_ATTRIBUTE15, PoSystemParameterEO.GLOBAL_ATTRIBUTE16, PoSystemParameterEO.GLOBAL_ATTRIBUTE17, PoSystemParameterEO.GLOBAL_ATTRIBUTE18, PoSystemParameterEO.GLOBAL_ATTRIBUTE19, PoSystemParameterEO.GLOBAL_ATTRIBUTE20, PoSystemParameterEO.GLOBAL_ATTRIBUTE_CATEGORY, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_AMOUNT, PoSystemParameterEO.PRICE_CHANGE_AMOUNT, PoSystemParameterEO.AUTO_OFFSET_METHOD, PoSystemParameterEO.PO_OUTPUT_FORMAT, PoSystemParameterEO.BUYING_COMPANY_IDENTIFIER, PoSystemParameterEO.GAPLESS_INV_NUM_FLAG, PoSystemParameterEO.MAX_ATTACHMENT_SIZE, PoSystemParameterEO.EMAIL_ATTACHMENT_FILENAME, PoSystemParameterEO.ACCEPTANCE_REQUIRED_FLAG, ot.name as order_type, pltv.line_type, pps.name as position_structure_name FROM PO_SYSTEM_PARAMETERS_ALL PoSystemParameterEO, oe_transaction_types ot, po_line_types_val_v pltv, per_position_structures pps where PoSystemParameterEO.org_id = :1 and PoSystemParameterEO.ORDER_TYPE_ID = ot.transaction_type_id (+) and nvl(ot.po_required_flag, 'N') = 'N' and nvl(ot.agreement_required_flag, 'N') = 'N' and PoSystemParameterEO.LINE_TYPE_ID = pltv.line_type_id (+) and PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID = pps.position_structure_id (+)
  3. 0

    IAS Cache Error Raised After Selecting Purchasing Category On A PO line

    Oracle Community | 6 years ago | user10088255
    oracle.apps.fnd.framework.OAException: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.framework.OAException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error While extending PoRequisitionLinesVO

    Oracle Community | 5 years ago | Hanimi
    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
  6. 0

    Extending PoDistributionMergeEO casuing errors

    Oracle Community | 5 years ago | 879472
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoLineLocationMergeEO.OWNER FROM PO_LINE_LOCATIONS_MERGE_V PoLineLocationMergeEO WHERE PoLineLocationMergeEO.LINE_LOCATION_ID = :1

    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 PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.REQ_CAN_AUTHORIZE, PoSystemParameterEO.INSPECTION_REQUIRED_FLAG, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE, PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE, PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE, PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_PO_NUM_CODE, PoSystemParameterEO.MANUAL_PO_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_REQ_NUM_CODE, PoSystemParameterEO.MANUAL_REQ_NUM_TYPE, PoSystemParameterEO.DEFAULT_QUOTE_WARNING_DELAY, PoSystemParameterEO.ENFORCE_BUYER_AUTHORITY_FLAG, PoSystemParameterEO.ENFORCE_BUYER_NAME_FLAG, PoSystemParameterEO.ENFORCE_VENDOR_HOLD_FLAG, PoSystemParameterEO.NOTIFY_IF_BLANKET_FLAG, PoSystemParameterEO.RFQ_REQUIRED_FLAG, PoSystemParameterEO.PO_DOCUMENT_REPORT_ID, PoSystemParameterEO.PO_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.RFQ_DOCUMENT_REPORT_ID, PoSystemParameterEO.RFQ_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.LINE_TYPE_ID, PoSystemParameterEO.RECEIVING_FLAG, PoSystemParameterEO.ALLOW_ITEM_DESC_UPDATE_FLAG, PoSystemParameterEO.DISPOSITION_WARNING_FLAG, PoSystemParameterEO.ENFORCE_FULL_LOT_QUANTITIES, PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID, PoSystemParameterEO.MIN_RELEASE_AMOUNT, PoSystemParameterEO.PRICE_TYPE_LOOKUP_CODE, PoSystemParameterEO.NOTIFICATION_WARNING_DELAY, PoSystemParameterEO.PRICE_BREAK_LOOKUP_CODE, PoSystemParameterEO.INVOICE_CLOSE_CODE, PoSystemParameterEO.RECEIVE_CLOSE_CODE, PoSystemParameterEO.INVOICE_CLOSE_TOLERANCE, PoSystemParameterEO.RECEIVE_CLOSE_TOLERANCE, PoSystemParameterEO.CANCEL_REQS_ON_PO_CANCEL_FLAG, PoSystemParameterEO.REQIMPORT_GROUP_BY_CODE, PoSystemParameterEO.EXPENSE_ACCRUAL_CODE, PoSystemParameterEO.INVENTORY_ACCRUAL_CODE, PoSystemParameterEO.ORDER_TYPE_ID, PoSystemParameterEO.ORDER_SOURCE_ID, PoSystemParameterEO.SALESREP_ID, PoSystemParameterEO.TERM_ID, PoSystemParameterEO.NEXT_APPROVER_LOOKUP_CODE, PoSystemParameterEO.GLOBAL_ATTRIBUTE1, PoSystemParameterEO.GLOBAL_ATTRIBUTE2, PoSystemParameterEO.GLOBAL_ATTRIBUTE3, PoSystemParameterEO.GLOBAL_ATTRIBUTE4, PoSystemParameterEO.GLOBAL_ATTRIBUTE5, PoSystemParameterEO.GLOBAL_ATTRIBUTE6, PoSystemParameterEO.GLOBAL_ATTRIBUTE7, PoSystemParameterEO.GLOBAL_ATTRIBUTE8, PoSystemParameterEO.GLOBAL_ATTRIBUTE9, PoSystemParameterEO.GLOBAL_ATTRIBUTE10, PoSystemParameterEO.GLOBAL_ATTRIBUTE11, PoSystemParameterEO.GLOBAL_ATTRIBUTE12, PoSystemParameterEO.GLOBAL_ATTRIBUTE13, PoSystemParameterEO.GLOBAL_ATTRIBUTE14, PoSystemParameterEO.GLOBAL_ATTRIBUTE15, PoSystemParameterEO.GLOBAL_ATTRIBUTE16, PoSystemParameterEO.GLOBAL_ATTRIBUTE17, PoSystemParameterEO.GLOBAL_ATTRIBUTE18, PoSystemParameterEO.GLOBAL_ATTRIBUTE19, PoSystemParameterEO.GLOBAL_ATTRIBUTE20, PoSystemParameterEO.GLOBAL_ATTRIBUTE_CATEGORY, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_AMOUNT, PoSystemParameterEO.PRICE_CHANGE_AMOUNT, PoSystemParameterEO.AUTO_OFFSET_METHOD, PoSystemParameterEO.PO_OUTPUT_FORMAT, PoSystemParameterEO.BUYING_COMPANY_IDENTIFIER, PoSystemParameterEO.GAPLESS_INV_NUM_FLAG, PoSystemParameterEO.MAX_ATTACHMENT_SIZE, PoSystemParameterEO.EMAIL_ATTACHMENT_FILENAME, ot.name as order_type, pltv.line_type, pps.name as position_structure_name FROM PO_SYSTEM_PARAMETERS_ALL PoSystemParameterEO, oe_transaction_types ot, po_line_types_val_v pltv, per_position_structures pps where PoSystemParameterEO.org_id = :1 and PoSystemParameterEO.ORDER_TYPE_ID = ot.transaction_type_id and nvl(ot.po_required_flag, 'N') = 'N' and nvl(ot.agreement_required_flag, 'N') = 'N' and PoSystemParameterEO.LINE_TYPE_ID = pltv.line_type_id and PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID = pps.position_structure_id

      at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:980)
      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.po
      PurchasingOptionsCO.processRequest
      1. oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
      2. oracle.apps.po.setup.webui.PurchasingOptionsCO.processRequest(PurchasingOptionsCO.java:141)
      2 frames
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:594)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1155)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:962)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:929)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:653)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:962)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:929)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:653)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2490)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1888)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
      18 frames
    5. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:216)
      1 frame
    6. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    7. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      3 frames
    8. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    9. com.evermind.server
      ServletRequestDispatcher$2.oc4jRun
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
      5 frames
    10. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
      1 frame
    11. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
      2 frames
    12. Unknown
      _RF._jspService
      1. _RF._jspService(_RF.java:225)
      1 frame
    13. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    14. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      3 frames
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    16. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    17. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    18. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    19. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    20. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
      6 frames
    21. oracle.oc4j.network
      ServerSocketAcceptHandler$AcceptHandlerHorse.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      2. oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
      3. oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
      4. oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
      4 frames
    22. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame