1 Reply Latest reply: Dec 10, 2012 6:51 AM by IdrisAli RSS

    Customer Conversion - Banks

    User910243567
      As part of customer conversion, I need to import bank information. Can you please let me know the fields i need to populate for this.

      I have gone through user guide and found below information that;

      1. I need to populate interface table ‘RA_CUSTOMER_BANKS_INT_ALL

      mandatory fields:
      • ORIG_SYSTEM_CUSTOMER_REF
      • PRIMARY_FLAG
      • START_DATE
      • LAST_UPDATED_BY
      • LAST_UPDATE_DATE
      • CREATED_BY
      • CREATION_DATE
      • BANK_ACCOUNT_NAME
      • BANK_ACCOUNT_CURRENCY_CODE
      • BANK_ACCOUNT_NUM
      • BANK_BRANCH_NAME

      Can someone explain me briefly about this.

      Thanks for your response.
        • 1. Re: Customer Conversion - Banks
          IdrisAli
          Hi,

          Are you on 11i or R12

          Bank conversion using Customer Interface is pretty straight forward , as you listed... just populate the mandatory fields

          • ORIG_SYSTEM_CUSTOMER_REF - Customer Id ( for which you are provind bank accout details).
          • PRIMARY_FLAG - 'Y' if its primary bank account for this customer
          • START_DATE
          • LAST_UPDATED_BY
          • LAST_UPDATE_DATE
          • CREATED_BY
          • CREATION_DATE
          • BANK_ACCOUNT_NAME - Any name to identify bank account
          • BANK_ACCOUNT_CURRENCY_CODE - Currency
          • BANK_ACCOUNT_NUM - Account Number
          • BANK_BRANCH_NAME - Name of bank branch
          BANK_NAME - Name of Bank..

          -Idris