PAAPIMP - PRC: Interface Supplier Costs fails with Error ORA-01400: cannot insert NULL into ("PA"."PA_EXPENDITURE_ITEMS_ALL"."BILLABLE_FLAG")
Last updated on AUGUST 04, 2017
Applies to:Oracle Project Costing - Version 12.1.1 and later
Information in this document applies to any platform.
Concurrent Program:PAAPIMP_SI - PRC: Interface Supplier Costs
When attempting to run PAAPIMP_SI module: PRC: Interface Supplier Costs, the following error occurs.
ORA-20003: import1_prog:ORA-01400: cannot insert NULL into ("PA"."PA_EXPENDITURE_ITEMS_ALL"."BILLABLE_FLAG")
The audit report (AUD: Supplier Costs Interface Audit) may also indicate the following exception for transactions which should be imported:
"An ORACLE error has caused Transaction Import to abort"
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