7 Responses to R12 Supplier Bank Accounts

  1. Kunal says:

    If the supplier is having multiple sites, the query will return multiple records.

  2. Andy says:

    Hi,
    Do you have any experience of what customers have done when it comes to re-implementing 11i AuditTrail that exists on Vendors and AP Bank tables? My customer has apps AuditTrail on PO_VENDORS, AP_BANK_ACCOUNTS_ALL, AP_BANK_ACCOUNT_USES_ALL and AP_BANK_BRANCHES tables, and now everything is shifted in R12, this will no doubt need re-working for them.
    For PO_VENDORS I believe I just need to setup the audit on AP_SUPPLIERS, but I’m worried that audittrail on HZ tables will capture more than just Bank changes.
    Would the following seem suitable?
    For AP_BANK_ACCOUNTS_ALL, use instead IBY_EXT_BANK_ACCOUNTS
    For AP_BANK_BRANCHES_ALL, ??? Not sure there is anything suitable ??
    For AP_BANK_ACCOUNT_USES_ALL, use HZ_CODE_ASSIGNMENTS ??
    Many thanks,
    Andy

  3. The new tables are now under Cash Management product as follows:
    CE_BANK_ACCOUNTS: contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch.
    CE_BANK_ACCT_USES_ALL: stores Operating Unit level bank account use information
    CE_PAYMENT_DOCUMENTS: Payment Documents to be used for Printed type Payments
    CE_BANK_BRANCHES_V: view: Bank/Branches Info
    CE_BANK_ACCT_USES_OU_V: view: Internal Bank Account Uses Info
    The following tables were obsoleted:
    AP_BANK_BRANCHES
    AP_BANK_ACCOUNTS_ALL
    AP_BANK_ACCOUNTS_USES_ALL

  4. Also refer the metalink note : TCA New Banks And Bank Branches Model In Release 12 [ID 403994.1]

  5. shan says:

    HI Dibyajyoti Koch
    CAN U PLEASE TELL WHERE TO USER ‘CE_’ TABLES AND ‘ ‘IBY_’ TABLES

    Thanks in advance
    Shan

  6. Abhi says:

    Hi,
    I am bit confuse here. Now we have two tables CE_BANK_ACCOUNTS and IBY_EXT_BANK_ACCOUNTS and both are capturing Bank data.
    Could you please explain me why we have 2 different table for same purpose?

    Thanks

    • CE_BANK_ACCOUNTS is used for internal back accounts. In simple words, if you have a company, you will open bank accounts in various banks in the name of the company for any sort of monetary transactions. These bank account details will be stored in this table. This table contains Legal Entity Level bank account information.

      IBY_EXT_BANK_ACCOUNTS is used for external back accounts. This table contains the bank accounts of your suppliers to which account your company will pay and the bank accounts of the customers from which account your company will get money.

      Normally IBY_EXT_BANK_ACCOUNTS contains much higher volume of records as compared to CE_BANK_ACCOUNTS, since it deals with all your suppliers and customers.

      Hope it helps.

      Thanks
      DJ

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: