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:
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
select * from prassignment where team_id is null
If any data is returned, please contact support
Please also check
I am having problems to post a specific timesheet. What could be the reasons?