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

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