Problem: Running the PRC: Interface Supplier Costs completes in error. The output log shows the following error:

ORA-20003: import1_prog:ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "APPS.PA_TRX_IMPORT", line 11279
ORA-06512: at "APPS.PA_TRX_IMPORT", line 9201
ORA-01400: cannot insert NU

Solution: Refer to “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)”. This issue was caused by a data error. Open an SR to get a datafix for the issue.

Read more »