1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Supplier intermediary banking details

Discussion in 'Oracle Financials' started by kartheekbk, Dec 22, 2015.

  1. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    Hi Forum,

    Can you please help to get the list of suppliers having the intermediary banking details in R12 ?

    Please let me how to get it from the back end tables ?

    Thanks!

    Regards,
    Kartheek B
     
  2. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    Hi Forum,

    I got the solution now-

    by joining the below two tables we can get the intermediary bank details of the suppliers-

    iby_intermediary_accts
    IBY_EXT_BANK_ACCOUNTS


    useful info about intermediary bank ::
    When you create a supplier bank account, irrespective of whether you provide the intermediary bank account details or not, two blank records will be entered in the table iby_intermediary_accts.

    So, if you provide the data the records will be created with data. If you do not provide the data, still, two records will be created without any data.

    You can distinguish the account1 and account 2 by the intermediary_acct_id.

    For example, say you have create a new bank account with bank_acct_id 2116 and the two intermediary_acct_ids in the iby_intermediary_accts is 2934 and 2935. In this case, the intermediary bank account 1 details will be stored with the intermediary_acct_id 2934 and the intermediary bank account 2 details will be stored with the intermediary_acct_id 2935.

    So, the principle is the bank account 1 record will go to the first Id and the bank account 2 record will be assigned with later Id.



    Regards,
    Kartheek B