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.

Symptoms

On : 12.1.3 version, Requisitions

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

ERROR
-----------------------
 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.
  

STEPS
-----------------------
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
po.plsql.PO_ENCUMBRANCE_POSTPROCESSING.INSERT_PACKET_CREATE_EVENT.020.EXCEPTION
;SQLERRM = ORA-01400: cannot insert NULL into ("PO"."PO_BC_DISTRIBUTIONS"."ENTERED_AMT")

BUSINESS IMPACT
-----------------------
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.

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