Error While Creating Non Catalog Request JBO-26041 INSERT INTO PO_REQUISITION_LINES_ALL
(Doc ID 762638.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle iProcurement - Version 12.0.6 to 12 [Release 12]Information in this document applies to any platform.
iProcurement - Version: 12.0.6 to 12.x
Symptoms
While creating Non-Catalog Request, user encounters an error when adding item to shopping cart.
You have encountered an unexpected error. Please contact the system administrator.
Click here for exception details.
Click here for exception details.
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post
data to database during "Insert": SQL Statement "INSERT INTO
PO_REQUISITION_LINES_ALL(REQUISITION_LINE_ID,REQUISITION_HEADER_ID,LINE_NUM,LAST_UPDATE_DATE,LAST_UP
DATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,ITEM_DESCRIP
TION,CATEGORY_ID,UNIT_MEAS_LOOKUP_CODE,UNIT_PRICE,QUANTITY,LINE_TYPE_ID,SOURCE_TYPE_CODE,ITEM_ID,ITE
M_REVISION,SUGGESTED_BUYER_ID,ENCUMBERED_FLAG,RFQ_REQUIRED_FLAG,NEED_BY_DATE,BLANKET_PO_HEADER_ID,BL
ANKET_PO_LINE_NUM,CURRENCY_CODE,RATE_TYPE,RATE_DATE,RATE,CURRENCY_UNIT_PRICE,SUGGESTED_VENDOR_NAME,S
UGGESTED_VENDOR_LOCATION,SUGGESTED_VENDOR_CONTACT,SUGGESTED_VENDOR_PHONE,SUGGESTED_VENDOR_PRODUCT_CO
DE,UN_NUMBER_ID,HAZARD_CLASS_ID,URGENT_FLAG,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,DESTINATION_T
YPE_CODE,DESTINATION_ORGANIZATION_ID,DESTINATION_SUBINVENTORY,VENDOR_ID,VENDOR_SITE_ID,VENDOR_CONTAC
T_ID,WIP_ENTITY_ID,WIP_OPERATION_SEQ_NUM,ATTRIBUTE_CATEGORY,DESTINATION_CONTEXT,ORG_ID,CATALOG_TYPE,
CATALOG_SOURCE,MANUFACTURER_NAME,MANUFACTURER_PART_NUMBER,REQUESTER_EMAIL,REQUESTER_FAX,REQUESTER_PH
ONE,UNSPSC_CODE,SUPPLIER_DUNS,NEW_SUPPLIER_FLAG,ITEM_SOURCE_ID,SUPPLIER_REF_NUMBER,ATTRIBUTE1,ATTRIB
UTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIB
UTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CURRENCY_AMOUNT,NONCAT_TEMPLATE_ID,ASSIGNMENT_
END_DATE,CONTRACTOR_REQUISITION_FLAG,LABOR_REQ_LINE_ID,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR
_CONTACT_EMAIL,ASSIGNMENT_START_DATE,ORDER_TYPE_LOOKUP_CODE,PURCHASE_BASIS,MATCHING_BASIS,NEGOTIATED
_BY_PREPARER_FLAG,BASE_UNIT_PRICE,TAX_ATTRIBUTE_UPDATE_CODE) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,
:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:4
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post
data to database during "Insert": SQL Statement "INSERT INTO
PO_REQUISITION_LINES_ALL(REQUISITION_LINE_ID,REQUISITION_HEADER_ID,LINE_NUM,LAST_UPDATE_DATE,LAST_UP
DATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,ITEM_DESCRIP
TION,CATEGORY_ID,UNIT_MEAS_LOOKUP_CODE,UNIT_PRICE,QUANTITY,LINE_TYPE_ID,SOURCE_TYPE_CODE,ITEM_ID,ITE
M_REVISION,SUGGESTED_BUYER_ID,ENCUMBERED_FLAG,RFQ_REQUIRED_FLAG,NEED_BY_DATE,BLANKET_PO_HEADER_ID,BL
ANKET_PO_LINE_NUM,CURRENCY_CODE,RATE_TYPE,RATE_DATE,RATE,CURRENCY_UNIT_PRICE,SUGGESTED_VENDOR_NAME,S
UGGESTED_VENDOR_LOCATION,SUGGESTED_VENDOR_CONTACT,SUGGESTED_VENDOR_PHONE,SUGGESTED_VENDOR_PRODUCT_CO
DE,UN_NUMBER_ID,HAZARD_CLASS_ID,URGENT_FLAG,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,DESTINATION_T
YPE_CODE,DESTINATION_ORGANIZATION_ID,DESTINATION_SUBINVENTORY,VENDOR_ID,VENDOR_SITE_ID,VENDOR_CONTAC
T_ID,WIP_ENTITY_ID,WIP_OPERATION_SEQ_NUM,ATTRIBUTE_CATEGORY,DESTINATION_CONTEXT,ORG_ID,CATALOG_TYPE,
CATALOG_SOURCE,MANUFACTURER_NAME,MANUFACTURER_PART_NUMBER,REQUESTER_EMAIL,REQUESTER_FAX,REQUESTER_PH
ONE,UNSPSC_CODE,SUPPLIER_DUNS,NEW_SUPPLIER_FLAG,ITEM_SOURCE_ID,SUPPLIER_REF_NUMBER,ATTRIBUTE1,ATTRIB
UTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIB
UTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CURRENCY_AMOUNT,NONCAT_TEMPLATE_ID,ASSIGNMENT_
END_DATE,CONTRACTOR_REQUISITION_FLAG,LABOR_REQ_LINE_ID,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR
_CONTACT_EMAIL,ASSIGNMENT_START_DATE,ORDER_TYPE_LOOKUP_CODE,PURCHASE_BASIS,MATCHING_BASIS,NEGOTIATED
_BY_PREPARER_FLAG,BASE_UNIT_PRICE,TAX_ATTRIBUTE_UPDATE_CODE) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,
:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:4
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |