Get Unexpected Error When Deleting Items From iProcurement Shopping Cart: ORA-01400: Cannot Insert NULL into ("PO"."PO_REQ_DISTRIBUTIONS_ALL"."CODE_COMBINATION_ID")
(Doc ID 1924979.1)
Last updated on FEBRUARY 02, 2024
Applies to:
Oracle iProcurement - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
When attempting to delete a line with no distribution,
the following error occurs.
ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO PO_REQ_DISTRIBUTIONS_ALL(DISTRIBUTION_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,REQUISITION_LINE_ID,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DISTRIBUTION_NUM,SET_OF_BOOKS_ID,REQ_LINE_QUANTITY,ENCUMBERED_FLAG,GL_ENCUMBERED_DATE,GL_ENCUMBERED_PERIOD_NAME,GL_CANCELLED_DATE,ENCUMBERED_AMOUNT,ATTRIBUTE_CATEGORY,PROJECT_ID,TASK_ID,EXPENDITURE_TYPE,EXPENDITURE_ORGANIZATION_ID,GL_CLOSED_DATE,EXPENDITURE_ITEM_DATE,ORG_ID,ALLOCATION_TYPE,ALLOCATION_VALUE,RECOVERY_RATE,REQ_AWARD_ID) 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)".
## Detail 0 ##
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PO"."PO_REQ_DISTRIBUTIONS_ALL"."CODE_COMBINATION_ID")
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter the items in the shopping cart
2. Click the delete icon
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 |
Cause |
Solution |