ETL92:Establishing Comp Time Plans Gives Error TRC: ACT Cannot Be Defined As A Valid TRC. (13500,112 (Doc ID 2993029.1)

Last updated on DECEMBER 13, 2023

Applies to:

Symptoms

It appears the PeopleCode on TL_COMP_TRC.TRC SaveEdit has a condition that is not looking at the correct effective dated record for what comp plans and employee is enrolled on in comparison to what comp plan is being created.
Establishing Compensatory Time Plans is giving following error:

Error:
TRC: ACT cannot be defined as a valid TRC. (13500,112)

Steps to Recreate in delivered demo:
1. Create new effective dated com plan for KUCTOP2, on 2/1/23 and add trc’s ‘KACMP’ & ‘KAWPH’ (component: COMP_TIME_PLAN)
2. Take demo employee KA3001 and make effective dated record for 2/1/23 and enroll them in com plan KUCTOP2 and set KACOMP1 & KACOMP1 to inactive (component: TL_EMPL_COMP)
3. Create a new effective dated comp plan for KACOMP1 on 10/31/23 and you will get the following error message, (component: COMP_TIME_PLAN)
  In the above scenario you can see that the employee is only enrolled in one comp plan at a time so the logic for the TL_COMP_TRC.TRC SaveEdit is not valid and is not looking at the most current effective dated record for the employee.
The Scenario above can be extended by the following:
4. For the employee (KA3001) above go back to the effective dated record 2/1/23, 01/15/2023 and 01/01/2000 then delete the record related to comp plan KACOMP1, as well as the 01/15/2023 comp plan record for KUCTOP2 (component: TL_EMPL_COMP)
5. Create a new effective dated comp plan for KACOMP1 on 10/31/23 and you will NOT get the following error message, (component: COMP_TIME_PLAN).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.