My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.