Query statement for fetching employees having bank accounts but not any PPM with these bank accounts assigned (Doc ID 2357370.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

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

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