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 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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 ?
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