PATCX: PRC: Distribute Usage And Miscellaneous Costs is Failing with 'Error ORA-01400: cannot insert NULL into ("PA"."PA_EXPENDITURE_ITEMS_ALL"."B)' (Doc ID 2972865.1)

Last updated on SEPTEMBER 15, 2023

Applies to:

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

Symptoms

When submitting PRC: Distribute Usage and Miscellaneous Costs, the program fails with the error "ORA-01400: cannot insert NULL into ("PA"."PA_EXPENDITURE_ITEMS_ALL"."B")
ORACLE error occurred while fetching AutoAccounting class category

The following information is found when reviewing the program log file with debug enabled.

ORA-01400: cannot insert NULL into ("PA"."PA_EXPENDITURE_ITEMS_ALL"."B
i_project_id [-1], i_start_project_number [0], i_end_project_number [0], i_end_date [0]

pascei() returned error while processing USG

Calling patcx.tc_extension api
create_burden_expenditure_item: Log: Stage:PATC:10.13.001
create_burden_expenditure_item: Log: End of patcx.tc_extension api patcx_bill_flag :N Assignment :patcx_status[Exp type is unique to KAPL]
create_burden_expenditure_item: Log: Stage:PATC:10.13.004
create_burden_expenditure_item: Log: Stage:PATC:10.13.002
create_burden_expenditure_item: Log: Stage:PATC:10.13.002 PATCX ERROR:Exp type is unique to XXXX

This is is reproduced with the following steps;