Query statement for fetching employees having bank accounts but not any PPM with these bank accounts assigned
Last updated on FEBRUARY 05, 2018
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 ?
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