Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Get Absence Plan balance standard function is not working properly
Summary:
While using GET_ACCRUAL_BALANCE & GET_PLAN_BALANCE i am not able fetch the plan balance as of given date like i have used change context and tried to entered the start date of calendar year of accrual plan but the plan balance is coming with respect to balance calculation date not with date which is provided in the change context
Code Snippet :::
L_start_date = to_date('01-01-'||To_char(IV_START_DATE,'RRRR'),'DD-MM-YYYY') /*get the start date of plan term */
L_Acrl_Balance = 0
L_Person_Id = GET_CONTEXT(PERSON_ID,0)
L_Term_Id = GET_CONTEXT(HR_TERM_ID,0)
0