Adding To Cart Delivers Error - ORA-01400: Cannot Insert NULL Into ("PO"."PO_REQUISITION_LINES_ALL"."DELIVER_TO_LOCATION_ID") (Doc ID 580002.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle iProcurement - Version 12.0.4 and later
Information in this document applies to any platform.


Symptoms

Attempting to add the item to the cart results in an error.

Error:
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Error:
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_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DELIVER_TO_LOCATION_ID,
...............,BASE_UNIT_PRICE,TAX_ATTRIBUTE_UPDATE_CODE) VALUES (.....)
## Detail 0 ## java.sql.SQLException: ORA-01400: cannot insert NULL into
("PO"."PO_REQUISITION_LINES_ALL"."DELIVER_TO_LOCATION_ID") at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966) at
....


Replication Steps:
1. Login to the E-Business Suite - select iProcurement.
2. Proceed to create a requisition
3. Add items - error occurs.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms