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 Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Query to fetch Run Result Element Entries & Balances for particular time period

Summary:

We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving multiple entries. If anyone can help on this, it would be great.

SELECT papf.person_number,

    To_char(ppa.effective_date, 'MM/DD/YYYY') AS Process_Date,

    To_char(ppa.date_earned, 'MM/DD/YYYY')  AS Pay_Run_Date,

    pet.element_name             AS Element_Name,

    pivt.name                 AS Input_Value_Name,

    pev.screen_entry_value          AS Value,

    ptp.period_name              AS Period_Name,

    pap.payroll_name             AS Payroll_Name

FROM  per_all_people_f papf,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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