My Oracle Support Banner

BIC Code Is Not Populated In The Bank Branches When Created From CUSTOMERIMPORTTEMPLATE.xlsm (Doc ID 2327767.1)

Last updated on SEPTEMBER 12, 2022

Applies to:

Oracle Fusion Receivables Cloud Service - Version and later
Oracle Fusion Receivables - Version and later
Information in this document applies to any platform.


Users are trying to create Banks, Bank Branches and Customer Bank Accounts using RA_CUSTOMER_BANKS_INT_ALL sheet in CustomerImportTemplate.xlsm template.
The Template is populated with all the required data, including BIC Number and IBAN Number.

The Bank and Bank Branches are created successfully, but the BIC number is not populated.

When the latest version of the Package body "ar_customer_interface_pkg" is verified the Line for assignment to variable "bic" is commented

  --l_branch_rec.bic hz_contact_points.EFT_SWIFT_CODE%TYPE ;
If the Above line is modified as below, then the BIC code would get populated in the Bank Branches Tables

l_branch_rec.bic := bnk.EFT_SWIFT_CODE;


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.