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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by user12003600, 1 year 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
via Oracle Community by Jcgeorge-Oracle, 1 year ago
oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO PA_INTEGRATION_CONTROLS(OPERATING_UNIT,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,INTEGRATION_OPTION_NAME) VALUES (:1,:2,:3,:4,:5,:6,:7) RETURNING ROWID INTO :8; END;".
via Oracle Community by 525140, 1 year ago
oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO XX_PERSONALIZED_TMS(AREA_OF_OPERATIONS,PRODUCT,ACTIVITES_SUBACTIVITIES,COUNTRY,PROJECT,SECTOR,THEME,TASK_ID,TASK_NAME,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)".
via Oracle Community by 2792376, 1 year ago
,POSITION_CODE,SALARY,START_DATE,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)".
via Oracle Community by 768725, 1 year ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NumberFormatException, msg=For input string: ""
via Oracle Community by Hanimi, 1 year 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
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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.