oracle.apps.fnd.framework.OAException

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.

  • R12 extending PoRequisitionLinesVO not working
    via by user12003600,
  • View Definition Not Found Error
    via by 878608,
  • VO Extension issue
    via by user5425941,
  • Vo extension error in iprocurement
    via by 1977211,
  • WhO column error in OAF page
    via by user9952568,
  • Not able to upload RTF files
    via by Diwakar Dhake,
    • 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 at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996) 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.icatalog.shopping.webui.ShoppingClientHelper.addToReqs(ShoppingClientHelper.java:258) at oracle.apps.icx.icatalog.shopping.webui.ShoppingClientHelper.addToReqsForSearchResults(ShoppingClientHelper.java:1381) at oracle.apps.icx.icatalog.shopping.webui.SearchResultsCO.processAddToReqFunction(SearchResultsCO.java:1325) at oracle.apps.icx.icatalog.shopping.webui.SearchResultsCO.processAddToCart(SearchResultsCO.java:1107) at oracle.apps.icx.icatalog.shopping.webui.SearchResultsCO.processFormRequest(SearchResultsCO.java:661)

    Users with the same issue

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