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 FEBRUARY 04, 2022
Applies to:
Oracle iProcurement - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]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 (.....)
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
....
("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
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 |
| References |