Post To WIP job fails - ORA-20669: ORA-01400: cannot insert NULL into

Products

• Clarity PPM On Premise

Issue/Introduction

The Post To WIP job is failing with the following error in the BG log:  

niku.njs (clarity:admin:42311161__E6C3FE52-511A-48E6-9FE4-EC842DD98730:Post Transactions to Financials) Error executing job: 1031 error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20878: -20669 - ORA-20669: -20669 - ORA-20669: ORA-01400: cannot insert NULL into ("CLARITY"."PPA_TRANSCONTROL_VALUES"."NATURAL_BILLRATE") ORA-06512: at "CLARITY.PAC_IMP_NPMTRANSIMPORT_SP", line 101

This issue could also occur if attempting to use the page for 'Post to WIP' and you may see an error message on the screen or in the APP log file.

 

 

Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component:

Cause

This error occurs because the Post To WIP job will access the real-time rate matrix definition in order to calculate the actual cost of the transaction. When it encounters an invalid value, it will throw the error.

Resolution

 

1. Run the query:  select * from PPA_MATRIXVALUES where numval1 is null  
2. If results are returned, the null values will need to be updated with valid rates in the application  
3. Within the application, locate and update the rate matrix rows containing the null values and save the changes  
4. Run the Post To WIP job to have the transactions processed correctly