Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Is there any Out-of-the-box Payroll Balance Feed report to get the Balance Definition to Element map

Santu
Santu Green Ribbon
edited Mar 21, 2018 10:26PM in Reporting and Analytics for HCM 7 comments

Answers

  • Sricharan Monigari
    Sricharan Monigari Diamond
    edited Mar 22, 2018 7:28AM

    Hi Santu,

    There is no seeded report to get these details. However you can use the attached SQL to get the balances and element mapping. You can provide the input of balance name or element name or LDG name to filter the results.You can tweak the query too as per your requirement.

    Thanks,

    Sricharan

  • Santu
    Santu Green Ribbon
    edited Mar 22, 2018 1:31PM

    Thank you!!

  • Bonnie Lafferty
    Bonnie Lafferty Bronze Crown
    edited Feb 7, 2019 4:27PM

    Hi Sricharan,

    My Reports Lead and I tried your sql and unfortunately were unable to get any data to populate. Are any of the fields required? We tried all fields with different values and still had no luck. Do you know if it still works with the 19A release?

    Any help would be greatly appreciated.

    Bonnie

  • Sricharan Monigari
    Sricharan Monigari Diamond
    edited Feb 8, 2019 8:03AM

    Hi Bonnie,

    Yes this still works after 19A... This SQL requires some parameters to be passed to get the output. If you don't need the input parameters, you can delete those lines in the where condition and extract everything.

    Thanks,

    Sricharan

  • Bonnie Lafferty
    Bonnie Lafferty Bronze Crown
    edited Jun 9, 2019 2:46PM

    Thanks Sricharan, we did get this to work.

  • Silpi
    Silpi Gold Medal

    The SQL did work for us too. Thank you so much for posting this. There is no seeded report to generate Payroll Balance vs Payroll Element.

  • Tiff.Dickson
    Tiff.Dickson Blue Ribbon

    There is a list of reports that have been published that includes a balance feed report. The report is actually quite good. The below Cloud Customer Connect link has a zip copy of the reports.

    Helpful Cloud Payroll BI Reports — Cloud Customer Connect (oracle.com)