My Oracle Support Banner

Import Bulk Customers Doesn't Read TheCustomer Banks Records From Interface (Doc ID 2611225.1)

Last updated on NOVEMBER 15, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Running Import Bulk Customers for RA_CUSTOMER_BANKS_INT_ALL sheet from FBDI template "CustomerImportTemplate.xlsm" the records are populated in interface table but no record is processed in batch ID.

EXPECTED BEHAVIOR
-----------------------
Expect the customer bank accounts to be generated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download the FBDI template "CustomerImportTemplate.xlsm"
2. Create the batch id by navigating to Receivables >> Billing >> Manage Data Import
3. Populate the data in RA_CUSTOMER_BANKS_INT_ALL spreadsheet and generate csv file
4. Go to Scheduled Processes and select ESS job “Load Interface File for Import” to run
5. Select "Import Trading Community Data in Bulk" in parameter Import Process and for Data File Select "Upload New File"
6. Once all the files are loaded and program completes with status Succeeded, run the ESS job "Import Bulk Customer Data"

Cause

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
Symptoms
Cause
Solution
References


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