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
Query to fetch count of colleagues for whom balances have got loaded into system
Summary:
After execution of "Load initial balances" job in system as part of HDL upload of balances. Now I need to know for how many colleagues balance information is loaded into system
Content (required):
Would like to know which table have to queried to determine count of colleagues for whom balances have got loaded. Tried querying for count of distinct payroll_relationship_id in the table pay_latest_balances. The count in the results doesn't seem correct. So wanted to know what would be the right way to do.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
1