My Oracle Support Banner

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 29, 2020

Applies to:

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


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


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.