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, 2 years 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: ""
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) xxOrigineFROM 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)