Import Bank Return Files

This section lists the steps involved in the bank return files import process flow.

This image displays Bank Return Files Import Process flow:

The Brazil Bank Return Files Import and Validation flow starts with users receiving Customer Payments Banks Processing Return files with the respective formats. Users must implement a custom process to perform a conversion to the Oracle Financials Cloud Import format and generates a .CSV file. The file must be transmitted to Oracle Cloud UCM. Then, the Load and Import process and the Validate process are run.

You may choose Option 1 or Option 2:

1. Option 1:
   Follow these steps:
   1. Populate the XLSM sheet manually with the customer payments bank returns from the external files received from the bank third-party application.
   2. Save a copy of the file.
   3. Click the Generate CSV File button.
2. Option 2:
   Build the external process that creates the CSV file based on the bank returns files. Transfer the CSV data file to the content management server. To load data into the Interface tables, follow these steps:
   1. Sign in to Oracle Financials Cloud Applications.
   2. Navigate to Tools and click Scheduled Processes.
   3. Click Schedule New Process.
   4. Search and select the Load Interface File for Import job.
   5. Select the target import process Import Bank Returns for Customer Payments when the Process Details page appears.
   6. Enter the data file name.
   7. Click Submit.
   8. Search and select the Import Bank Returns for Customer Payments job.
   9. Click Submit.