Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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
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?
Tagged:
0