Finally Closing A Requisition Results. Error:ORA-01400: Cannot Insert NULL In "PO_BC_DISTRIBUTIONS"

(Doc ID 1915796.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Requisitions

When attempting to finally close the Purchase requisition, the following error occurs.

 INSERT_PACKET_CREATE_EVENT-020: ORA-01400: cannot insert NULL into ("PO"."PO_BC_DISTRIBUTIONS"."ENTERED_AMT") Cause: A SQL error has occurred in INSERT_PACKET_CREATE_EVENT. The SQL error is ORA-01400: cannot insert NULL into ("PO"."PO_BC_DISTRIBUTIONS"."ENTERED_AMT"). Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.

The issue can be reproduced at will with the following steps:
1, Create requisition in both iProcurement & Requisition Form.
2, Submit for Approval.
3, Requisition Approved.
4, In requisition Summary window, tools --> Control --> Choose: Finally close --> Click: Ok
5, Desition box: Your Budgetary Control action completed with exceptions
5.1, Click: OK :- Nothing Happened
5.2, Click: View Results :- "PO_MSG_NULL_MESSAGE" displays in result message
6, Enabled FND Debug in statement level and notice the below
;SQLERRM = ORA-01400: cannot insert NULL into ("PO"."PO_BC_DISTRIBUTIONS"."ENTERED_AMT")

The issue has the following business impact:
We can't proceed further the business scenario with the error; We have UAT scheduled on 28-July-2014, No of user affected is 35.


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