PRC: Distribute Expense Report Adjustments Error ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT") INV_DATA NO_COMPILED_MULTIPLIER

(Doc ID 1495410.1)

Last updated on DECEMBER 03, 2015

Applies to:

Oracle Project Costing - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Grants Accounting - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Checked currency today: 03-Dec-2015

Symptoms

On : 12.1.3 product version, Expenditure Processing

When running PRC: Distribute Expense Report Adjustments get errors:


ERROR
-----------------------
pacgud: Error inserting cost distribution lines for New Eis,
pacgud: ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT")


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using Projects responsibility, navigate to Project Expenditure Inquiry, transfer source transaction of 'Oracle Payables Expense report' to another project and task.
2. Run PRC: Distribute Expense Report Adjustments

 

Note:  Other processes such as   PRC: Distribute Labor Costs and PRC: Distribute Usage and Miscellaneous Costs, PRC: Create and Distribute Burden Transactions and GMS: Costing and Fundschecking processes are affected too.The following will be the exceptions:

INV_DATA
NO_COMPILED_MULTIPLIER

The patch for the code fix will correct the exceptions and no data fix required.

 

 

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