Fusion Global HR: How to join bank account details to a PERSON_ID or PER_ALL_PEOPLE_F table if Cannot Locate PAY_EXTERNAL_ACCOUNTS Table?

(Doc ID 2017620.1)

Last updated on DECEMBER 29, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Goal

How to join bank account details to a PERSON_ID or PER_ALL_PEOPLE_F table?

PAY_BANK_ACCOUNTS table is visible and does contain the data but need to associate it back to the owner of the bank account.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms