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

How to get the accrual balances for the all type of absences against to particular person in table .

Accepted answer
edited Nov 20, 2017 5:46AM in Workforce Management 1 comment


Extracting Employee Leave balance from BI




We are using oracle fusion hcm cloud application for OTL and Absence Management, By below navigation we can see the accrual balances of the type of leaves(absences plan).


Navigator-->About Me-->Time-->then clcik 'Actions'-->Maintain Absence Records-->Under this we can see the 'Accrual Balances' for the all types of absences.

Note : Have attached the this screenshot for reference.


We need  to extract this data and transfer to payroll system(third party), for this we have planned to use BI Reports. When we try to extract this accrual balances for particulars person, we can't able to find the exact information in tables. Is there any table/view/functions to identify the accrual balances for particular person ...? Please help here to move forward.

Howdy, Stranger!

Log In

To view full details, sign in.


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