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

Identifying the Main Legal Reporting Unit via BI

edited Feb 14, 2023 3:22PM in Reporting and Analytics for HCM 9 comments

Summary:

Identifying the Main Legal Reporting Unit via a SQL query.

Content (required):

Hello experts,

We have multiple LRUs, and TRUs, setup for our implementation, and were looking to extract the data out via a quick BI report to verify the setups.

We are looking to pull the primary or the main legal reporting unit, and the 'sub-units' that fall under the legal employer. We've managed to to pull all the below 3 records via a simple query, but weren't able to identify the 'Main Legal Reporting Unit' among the 3 of them.

Would we know the table / column / joins where this info might reside?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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