select MASKED_BANK_ACCOUNT_NUM, BA_MASK_SETTING from apps.iby_ext_bank_accounts
If the ba_mask_setting returns DISPLAY_ALL, the bank account number appearing in MASKED_BANK_ACCOUNT_NUM will not appear as masked .e.g 1234567809
However, if the setting for BA_MASK_SETTING is like DISPLAY_LAST, DISPLAY_FIRST , then the number under the column MASKED_BANK_ACCOUNT_NUM will appear as XXXXXX7809 (if display_last , 4 disgits is enabled).
How to change the settings:
In Release 12, external bank account masking is controlled by the following settings:
Funds Capture Setup Administrator > Payments Setup > System Security Options > Payment Instrument Masking.
The “External Bank Account Masking Setting” dropdown field has the following options:
- Display First Digits
- Display Last Digits
- Display None
Clicking on apply button fires a request set
Mask Sensitive Data Request Set (Report Set) with two programs:
Mask External Credit Card Data
Mask External Bank Acc