PTO Carry Over process processing ex-employees
I have a requirement where the carryover is based on the employee's assignment like fulltime/partime, working hours etc.
So in my Accrual Carry Over fast formula, I am passing the ASG_NUMBER database item to a pl/sql function and calculating the carryover.
The problem is the PTO Carry Over process is erroring out saying -
===========================================================================================
Processing Plan Annual Leave Balance (61)...
Processing Assignment 5 (65)... successful.
Processing Assignment 10 (101)... successful.
Processing Assignment E0134 (269)... failed.
ORA-20001: Data ASG_NUMBER not found at line 34 of XXMHP_PTO_SIMPLE_CARRYOVER
Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed.