How to Unmask Bank Account Details when Masking and Encryption is Enabled

Summary:

Hello Everyone,

In Oracle Fusion Applications, we have enabled "Bank Account Encryption" and also "Bank Account Number Masking (last 4 digits)" through System Security Options.

However, we would like to extract Unmasked Bank Account Numbers, from BI Publisher SQL Query to send it to External Application WITHOUT changing the System Security Options.

Please let us know if anyone has achieved this.

Thanks in Advance!!