Fusion Global Payroll : Need SQL Queries To Pull Data From Table That Stores Employees Bank Accounts
(Doc ID 2531529.1)
Last updated on OCTOBER 06, 2020
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.
On : 11.13.19.01.0 version, Reports and Analytics
Need to pull data from table that stores employees bank accounts
Reviewed the ER Diagrams provided by Oracle on the link below:
After reviewing the ER Diagrams, I was able to find the tables I am looking for but I am struggling with how to tie a table in the Payments (IBY) folder to tables in Global Payroll (PAY) or Global Human Resources (PER)?
I am looking at the table IBY_ACCOUNT_OWNERS and can see an ACCOUNT_OWNER_ID or ACCOUNT_OWNER_PARTY_ID, but can't find any values that match those values to try and get the tables joined.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document