How To Identify "Selected" Bank Accounts In The Database Tables Using BI (Doc ID 2287557.1)

Last updated on JULY 18, 2017

Applies to:

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

Goal

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".
 

Solution

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