Upload Payables Bank Returns Data

Bank return import file contains details sent by the bank on the status of payment requests that have been sent to the bank for payment.

Bank return import file contains the details of each payment using the reference of the Return Identifier, which uniquely identifies a specific payment request made to the bank. Different banks use different bank return codes. On importing the details, the status of the collection documents that are matched with the invoice installments get updated based on the corresponding return codes.

To access the template, complete these steps:

1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

2. In the Table of Contents, click File-Based Data Imports.

3. Click Payables Bank Returns Data Upload Interface.

4. In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

• Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

• Do not change the order of the columns in the template.

• You can hide or skip the columns you do not use, but do not delete them.

Settings That Affect the Payables Bank Returns Data Upload Interface

The template consists of two sheets:

• Instructions and CSV Generation

• Bank Returns

You can use this table to populate the Bank Returns sheet:

Name	Comments
BANK_RETURN_ID	Value generated during the processing of a payment request. It is passed to bank in a payment request file. It is also used to uniquely refer individual payment requests.
BANK_OCCURRENCE_CODE	Occurrence error details sent by the bank. It is also a foreign key to the JL_BR_AR_BANK_OCCURRENCES table.
OCCURRENCE_DATE	Occurrence error date sent by the bank.
PAYMENT_REQUEST_IDENTIFIER	ESS ID of the payment request.

How Payables Bank Returns Data Upload Is Processed

Brazil Bank Return Files Import and Validation flow starts with Users receiving Payer Banks Processing Return files with respective formats. Users have to implement a process to execute a conversion to Oracle Financials Cloud Import format and generate a .csv file based on that format. That file must be transmitted to Oracle Cloud UCM. Load and Import process and Validate process must be executed.

Load the Data into the Interface Tables

1. After you finish preparing the data in the parent and child sheets, click the Generate CSV File button. The process generates both a CSV file and a ZIP file.

2. Load the data using the Load Interface File for Import process:

   1. Sign in to the Oracle Public Cloud SFTP server.

   2. Transfer the ZIP file to the SFTP server location.

   3. Sign in to Oracle Fusion Cloud Applications.

   4. Navigate to Scheduled Processes.

   5. Select Load Interface File for Import.

   6. Select the process indicated in the Overview section to load the CSV file to the interface tables.

   7. Review the results of the process.

   8. If necessary, correct any errors in the CSV file and rerun the Load Interface File for Import process.

3. Correct load errors:

   1. If the load of the CSV file fails on any row, the Load Interface File for Import process ends in error and the Load File to Interface child process ends in either warning or error.

   2. All rows that were loaded from the CSV file are deleted including the ones that loaded successfully. This lets you edit the problematic data in the spreadsheet and resubmit without having to separate the successful rows from the rows that need modification.

   3. Review the log and output files of the Load File to Interface child process for information about the data that caused the failure.

   4. Correct the data in the template you used.

   5. Repeat steps 1 and 2 of this section: Generate the CSV file and load the data using the Load Interface File for Import process.

   6. Repeat all of these steps until all data is loaded successfully.