Post timesheet: ORA-01400 ("CLARITY"."PPA_MATRIXCHECKOUT"."MATRIXKEY")

book

Article ID: 140152

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

After running the Post Tiemsheet job, I see there is an approved timesheet that is not moving to a Posted status
Looking at bg-ca.log file, we see the following error:
ORA-01400: cannot insert NULL into ("CLARITY"."PPA_MATRIXCHECKOUT"."MATRIXKEY") 

Cause

The post timesheet job does not find a rate to apply for an investment added to the resource's timesheet

Environment

Release:


Component:

Resolution

Ensure that the investments on the resource's timesheet have matrix associations properly set

Ensure that the resource of the timesheet affected contains a valid row on the rate matrix

Administration > Finance > Manage Matrix

Ensure the row covers the whole lifetime of the investments added to the timesheet

Additional Information

Please check also 


I am having problems to post a specific timesheet. What could be the reasons?

articleId=140155