PAAPIMP - PRC: Interface Supplier Costs fails with Error ORA-01400: cannot insert NULL into ("PA"."PA_EXPENDITURE_ITEMS_ALL"."BILLABLE_FLAG") (Doc ID 1265338.1)

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

Symptoms

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"

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