Get worker's last salary based on HR Action like 'ENDPROBATION'
We need a formula to get the last salary of an employee in year N-1 for a specific HR action.
I'm actually working on a Compensation Default and Override formula type to get the updated salary after the probation period. The process of ending the probation period tracked in the system through an HR action 'ENDPROBATION'.
To do this, I used the DBI "DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ACT_ACTION_CODE IS 'N/A'" and passed the action code as a parameter.
PER_HIST_ASG_ACT_ACTION_CODE = 'ENDPROBATION' (line 61)
But when I compile the formula, I get the following error: