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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.