R12: PA: Cannot Insert Null When Running For One Project - PRC: Distribute Supplier Cost Adjustments (Doc ID 2196593.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Expenditure Processing

PAVDVC - Cannot insert null when running for one project - PRC: Distribute Supplier Cost Adjustments

When run for project 147161, PRC: Distribute Supplier Cost Adjustments request errors with:




 

ERROR
-----------------------
pacgud: Error inserting cost distribution lines for New Eis
pacgud: ORA-01400: cannot insert NULL into ("PA"."PA_COST_DISTRIBUTION_LINES_ALL"."AMOUNT#1")
Program was terminated by signal 6




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run PRC: Distribute Supplier Cost Adjustments

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate bill for customer.

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