Supplier Management

Get Involved. Join the Conversation.

Topic

    Dave Dengate
    Displaying Unmasked Bank Account
    Topic posted April 3, 2017 by Dave DengateBlue Ribbon: 750+ Points, tagged Public Sector, Supplier Creation, Supplier Profile Management 
    780 Views, 10 Comments
    Title:
    Displaying Unmasked Bank Account
    Summary:
    When Maintaining Bank Accounts we need to see the full Bank Account number
    Content:

    There are occasions when our Account Payable's manager need to see the full bank account number to ensure we are creating duplicates or allocating the wrong Bank Account to a Supplier.

    Is there a way within Fusion where the full Bank Account Number (I.e. 12345678, not xxxx5678) can be displayed.?

    Comment

     

    • Iliyas Syed

      Hi,

      Please refer this document "Oracle Fusion Applications Credit Card and Bank Account Encryption (Doc ID 1504285.1)"

      Regards,

      Iliyas Syed

    • Janardhana Kondaveeti

      Hi Dave,

      The issue is caused by the following set-up:Manage Cash Management Profile Options

      For Internal Bank accounts, the profile option  quoted below is correct. It only has one option.  On View pages, Bank account numbers are always masked.
      If you want to see the unmasked number, you can do it from the below steps

      Login to Application->Navigator->setup and maintenance->search "Manage Cash Management Profile Options"
      and select Profile option code: "CE_MASK_INTERNAL_BANK_ACCT_NUM" and search

      1. We currently only have one security option set in Functional Set up Manager  : "Manage Cash Management Profile Options"
      Profile option code: CE_MASK_INTERNAL_BANK_ACCT_NUM

      The profile option : CE_MASK_INTERNAL_BANK_ACCT_NUM: Profile Values is "No Masking" and save and close the application

      reset the issue.!


      Thanks,
      Janardhan

    • Dave Dengate

      Thanks for both the posts, however it is the External Bank Account that our AP manager needs to view Unmasked.

      Regards

      Dave

    • Dave Dengate

      Vince,

      I had to write a BI Publisher report which would bring back all Bank Accounts for a entered Sort Code. The SQL for the data model is :-

      select distinct 
        "IBY_EXT_BANK_ACCOUNTS_V"."BANK_NAME" as "BANK_NAME",
         "IBY_EXT_BANK_ACCOUNTS_V"."BANK_ACCOUNT_NUMBER" as "BANK_ACCOUNT_NUMBER",
        "IBY_EXT_BANK_ACCOUNTS_V"."BANK_ACCOUNT_NAME" as "BANK_ACCOUNT_NAME",
        "IBY_EXT_BANK_ACCOUNTS"."BANK_ACCOUNT_NUM" as "BANK_ACCOUNT_NUM"
       from "FUSION"."IBY_EXT_BANK_ACCOUNTS" "IBY_EXT_BANK_ACCOUNTS",
       "FUSION"."IBY_EXT_BANK_ACCOUNTS_V" "IBY_EXT_BANK_ACCOUNTS_V"
       where   "IBY_EXT_BANK_ACCOUNTS_V"."EXT_BANK_ACCOUNT_ID"="IBY_EXT_BANK_ACCOUNTS"."EXT_BANK_ACCOUNT_ID"
        and   "IBY_EXT_BANK_ACCOUNTS_V"."BANK_NAME" LIKE :Sort_Code

      Hope this helps
      Dave

    • Mitesh Kumbhat

      You cannot disable encryption once enabled. However you can change masking settings to display all digits.

      Additionally, below MOS note can be useful to identify supplier bank account assignments:

      • Searching Supplier Bank Account Assignments in Fusion (Doc ID 2433249.1)
    • Alan Rowland

      My users have the same request.  The R12 EBS functionality would be much easier to work with than going back and forth between a BI report and the application.

      • Mitesh Kumbhat

        Agreed. However as the product boundary is different in Fusion compared to EBS for this case, this is an open ER in POZ. Meanwhile considering the customer's pain point, we have thought to provide an alternative solution in the interim.

    • Suresh Kumarasamy

      We have the same requirement, our AP manager want to see full bank account numbers. If somebody able to make role wise restriction to view only selected role, please share it with this forum. 

    • Ashish Patidar

      Hi 

      You can do the unmasking of external bank account numbers from 'Manage System Security Options'

      For Internal bank account masking/unmasking you can follow the profile option 'CE_MASK_INTERNAL_BANK_ACCT_NUM'