Tuesday, March 5, 2013

Mask or Un-Mask Bank Account Numbers in R12

Mask or Un-Mask Bank Account Numbers in R12


Please follow the below steps to Mask or Un-Mask Bank Account Numbers in R12

Mask or Un-Mask Internal Bank Accounts


To Mask or Un-Mask Internal Bank Accounts you should use the below profile option:-

CE: Mask Internal Bank Account Numbers

The above profile option has the below 3 values:-

  1. Mask - First four visible
  2. Mask - Last four visible
  3. No - Masking



Mask or Un-Mask External Bank Accounts


To Mask or Un-Mask external bank accounts (i.e., supplier bank accounts) follow the below steps:-

Step-1:
Go to Oracle Payables responsibility
(N) Setup > Payments > Payment Administrator




Step-2:
Click on Go to Task icon referring to System security Options
(N) Payments Setup > Shared Setup > System Security Options




As shown above, if you select the value DISPLAY FIRST DIGITS and number of digits to display as 10 then the first 10 characters of the supplier / external bank account will be displayed without masking and the rest will be masked.

2 comments:

Ahsan said...

Good one.
regards
Ahsan

Amit Kumar said...

Hii Arun

I have a few columns which I need to put masking format on.

I need guidance on how to mask the attached documents (APPLSYS.FND_ATTACHED_DOCUMENTS). Customer is deleting the row entries using scripts. I initially thought of setting attached_document_id to null then delete the null entries in post_masking. However, the column has a non-null constraint. Any suggestion?

Regards
Amit