My Oracle Support Banner

R12: Program PRC: Interface Supplier Cost ends with ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT") (Doc ID 2200646.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Project Costing - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run PRC: Interface Supplier Costs process,
the following error occurs.

ERROR
-----------------------
06:29:19: PA_COSTING.CreateNewCdl: Gl Accounted Flag[Y]l_gl_date[]x_gl_date[05-OCT-16]
06:29:19: PA_COSTING.CreateNewCdl: log_message: In OTHERS exception of import1
06:29:19: PA_COSTING.CreateNewCdl: Error: ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT")
06:29:19: PA_COSTING.CreateNewCdl: log_message: Inside Upd_PktSts_Fatal
06:29:19: PA_COSTING.CreateNewCdl: log_message: Updated 1 packet statuses to T
06:29:19: PA_COSTING.CreateNewCdl: log_message: Error in import1 procedure
06:29:19: PA_COSTING.CreateNewCdl: log_message: Stage=In OTHERS exception of import1
06:29:19: PA_COSTING.CreateNewCdl: log_message: ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT")
06:29:19: transaction import failed with sqlcode =
06:29:19: -20003
06:29:19: ORA-20003: import1_prog:ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT")In OTHERS exception of import1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the process PRC: Interface Supplier Costs
2. Ends in error above.


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


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