You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get Absence Balance in worksheet

Received Response
31
Views
3
Comments

Summary:

We wanted to get the employees Absence Balance in worksheet in User Table column

Content (required):

We are trying to get the employees balance with below FF of type - Compensation Default and Override formula but it is not working


DEFAULT FOR ORA_RAEP_TRE_LAST_UPDATE_DATE IS '0001/01/01 00:00:00' (DATE)

L_MSG = 'XX'

L_VALUE = 0

DAYS = 0

accrual_bal = 0

L_DEFAULT_VALUE = 0


l_hr_assignment_id = ASG_HR_ASG_ID


l_effective_date= GET_CONTEXT(END_DATE,ORA_RAEP_TRE_LAST_UPDATE_DATE) /* If you want to get accrual balance base on another date, you can change the effective date*/

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!