search cancel

Post Timesheet error "ORA-01400 ("CLARITY"."NBI_PROJ_RES_RATES_AND_COSTSCP"."TEAM_ID")"

book

Article ID: 140153

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

After running the Post Timesheet job, you see there is an approved timesheet that is not moving to a Posted status.
Looking at the bg-ca.log file, you see the following error:
Stored Procedure application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in CMN_JOB_RATE_MATRIX_SP - ORA-20000: Error in NBI_PROJ_RATES_AND_COSTS_SP - Performing project-related activities, inserting rows associated with the specific assignments: ORA-01400: cannot insert NULL into ("CLARITY"."NBI_PROJ_RES_RATES_AND_COSTSCP"."TEAM_ID") 
ORA-06512: at "CLARITY.CMN_JOB_RATE_MATRIX_SP", line 15 
ORA-06512: at line 1 

Cause

There is an assignment where the team_id is NULL

Resolution

  1. Run the following query:
    select * from prassignment where team_id is null
  2. If any data is returned, contact Broadcom support

Additional Information

Also check: Approved timesheets not posting - Master KB of known issues