oracle.apps.fnd.framework.OAException: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.framework.OAException

Oracle Community | user10088255 | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    Oracle Community | 7 years ago | user10088255
    oracle.apps.fnd.framework.OAException: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.framework.OAException
  2. 0

    Error While extending PoRequisitionLinesVO

    Oracle Community | 6 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
  3. 0

    Extending PoDistributionMergeEO casuing errors

    Oracle Community | 6 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 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 (+)

    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.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.framework.OAException

      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
      OrderLinesCO.processFormRequest
      1. oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
      2. oracle.apps.po.document.common.webui.DocumentLineBaseCO.processPPREventsOnServer(DocumentLineBaseCO.java:317)
      3. oracle.apps.po.document.common.webui.DocumentLineBaseCO.processFormRequestForLines(DocumentLineBaseCO.java:444)
      4. oracle.apps.po.document.order.webui.OrderLinesCO.processFormRequest(OrderLinesCO.java:75)
      4 frames
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:815)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      8. oracle.apps.fnd.framework.webui.OASubTabLayoutHelper.processFormRequest(OASubTabLayoutHelper.java:729)
      9. oracle.apps.fnd.framework.webui.beans.layout.OASubTabLayoutBean.processFormRequest(OASubTabLayoutBean.java:484)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      19. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1189)
      20. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
      23. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
      24. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      25. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
      29. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
      30. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      31. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2846)
      32. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1838)
      33. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
      34. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
      34 frames