2 Replies Latest reply on Mar 7, 2012 5:55 PM by 480228

    Supplier Bank Accounts, unable to view banking details at site level - R12

    901754
      Hi All,

      I've loaded Supplier banks & branches, and linked bank account with supplier through API.

      However, when I query on the Supplier Banking Details screen (Payables Super User > Suppliers > Inquiry > Suppliers > Banking Details) and select Site for account assignment level and select the site name, I do not see anything.

      From the backend tables, I can see the bank accounts created and linked to suppliers. However, nothing is displayed after querying there or on the Search Supplier Bank Account Assignment screen either.

      Is it a configuration / setup / profile / security setting that's preventing the records from being displayed on the screen?

      Any help / advise is appreciated - apps version R12.1.3

      Thanks in advance,

      LG
        • 1. Re: Supplier Bank Accounts, unable to view banking details at site level - R12
          480228
          I've have the exact same problem. Hoping to see a response here soon. API script used to load test data is:

          set serveroutput on
          DECLARE
          --
          lv_return_status varchar2(1);
          lv_msg_count number;
          lv_msg_data varchar2(2000);
          --
          l_bank_id number;
          l_branch_id number;
          l_end_date date;
          l_start_date date;
          l_acct_id number;
          l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
          l_bank_acct_rec apps.iby_ext_bankacct_pub.extbankacct_rec_type;
          --
          BEGIN


          l_bank_acct_rec.bank_id := 14761;
          l_bank_acct_rec.branch_id := 662490;
          l_bank_acct_rec.country_code := 'US';
          l_bank_acct_rec.bank_account_name := 'YOUNG DAVID';
          l_bank_acct_rec.bank_account_num := '9999990380';
          l_bank_acct_rec.currency := 'USD';


          select party_id into l_bank_acct_rec.acct_owner_party_id
          from AP.ap_suppliers where segment1 = '18606407610';

          IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
          p_api_version => 1,
          p_ext_bank_acct_rec => l_bank_acct_rec,
          x_acct_id => l_acct_id,
          --x_start_date     => l_start_date,
          --x_end_date          => l_end_date,
          x_return_status => lv_return_status,
          x_msg_count => lv_msg_count,
          x_msg_data => lv_msg_data,
          x_response => l_response
          );
          dbms_output.put_line(lv_return_status||'-'||lv_msg_count||'-'||lv_msg_data|| '-' || l_acct_id);
          dbms_output.put_line(l_response.Result_Code ||'-'||l_response.Result_Message );
          end;
          /

          Edited by: user477225 on Mar 7, 2012 9:07 AM
          • 2. Re: Supplier Bank Accounts, unable to view banking details at site level - R12
            480228
            Using the overloaded version of the API appears to add a bank account that's displayed by the user interface in Vendors. No warranties since I can't explain why (just guess). Association value appears to be S for supplier and SS for site.

            set serveroutput on
            DECLARE
            --
            lv_return_status varchar2(1);
            lv_msg_count number;
            lv_msg_data varchar2(2000);
            --
            l_bank_id number;
            l_branch_id number;
            l_end_date date;
            l_start_date date;
            l_acct_id number;
            l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
            l_bank_acct_rec apps.iby_ext_bankacct_pub.extbankacct_rec_type;
            --
            BEGIN


            l_bank_acct_rec.bank_id := 14761;
            l_bank_acct_rec.branch_id := 662490;
            l_bank_acct_rec.country_code := 'US';
            l_bank_acct_rec.bank_account_name := 'YOUNG DAVID 2';
            l_bank_acct_rec.bank_account_num := '9999990380';
            l_bank_acct_rec.currency := 'USD';
            l_bank_acct_rec.acct_type := 'CHECKING';


            select party_id into l_bank_acct_rec.acct_owner_party_id
            from AP.ap_suppliers where segment1 = '18606407610';
            /*
            IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
            p_api_version => 1,
            p_ext_bank_acct_rec => l_bank_acct_rec,
            x_acct_id C,
            --x_start_date     => l_start_date,
            --x_end_date          => l_end_date,
            x_return_status => lv_return_status,
            x_msg_count => lv_msg_count,
            x_msg_data => lv_msg_data,
            x_response => l_response
            );
            */


            IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
            p_api_version => 1,
            p_init_msg_list => FND_API.G_FALSE,
            p_ext_bank_acct_rec => l_bank_acct_rec,
            p_association_level => 'S' ,
            p_supplier_site_id => null ,
            p_party_site_id => null ,
            p_org_id => 1712,
            p_org_type          =>     'OPERATING_UNIT',
            x_acct_id => l_acct_id,
            x_return_status => lv_return_status,
            x_msg_count => lv_msg_count,
            x_msg_data => lv_msg_data,
            x_response => l_response
            );

            dbms_output.put_line(lv_return_status||'-'||lv_msg_count||'-'||lv_msg_data|| '-' || l_acct_id);
            dbms_output.put_line(l_response.Result_Code ||'-'||l_response.Result_Message );
            end;
            /