search cancel

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


Article ID: 140153


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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 


There is an assignment where the team_id is NULL


  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