How To Identify "Selected" Bank Accounts In The Database Tables Using BI
Last updated on JULY 18, 2017
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On the Personal Payment Method screen in Fusion, there can be multiple records for bank accounts, but only one row may be "selected".
We need to create a BI Publisher report to output the "selected" bank accounts for each worker, but we cannot find any table or column to identify which row is "selected".
Furthermore, the details of each bank record contain an "Active" flag in Fusion. Again, we cannot locate any table or column to identify which rows are marked as "active".
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms