Human Capital Management - EBS (MOSC)

MOSC Banner

PTO Carry Over process processing ex-employees

 Hello,

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center