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)