Query statement for fetching employees having bank accounts but not any PPM with these bank accounts assigned

(Doc ID 2357370.1)

Last updated on FEBRUARY 05, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version

Person Number mapping for Create external bank account task without Personal Payment Method

For the scenario, after creating external bank account personal payment method has not been loaded.
We need to find out relationship table between bank account id and payroll relationship id.

In other words:
We need to find bank_account_number (bank_account_id) which is present in pay_bank_accounts and not in pay_personal_payment_methods_f and correlate with Person number.

Could you please provide underlying query for same ?

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