My Oracle Support Banner

LACLS: Automatic Load Brazilian Bank Return into Fusion Receivables (Doc ID 2359000.1)

Last updated on MAY 17, 2019

Applies to:

Latin America Cloud Local Solution (LACLS) - Version 12 to 13 [Release 12 to 13]
Information in this document applies to any platform.


Latin America Cloud Local Solution (LACLS) created a feature using Oracle Integration Cloud Service (OIC) where will be possible to upload information from Bank Collection Documents Return flat file into the Brazilian Localization Cloud Receivables without user handle the bank flat file.


There is also another solution available in this document for customers that do not have OIC. This solution is based in Excel Spreadsheet where macros were added to do the necessary data transformation.

Macro view process of the OIC solution:

Customer will transfer the flat file bank into ERP Cloud environment using FTP, after that it will start the OIC that was defined to read the bank flat file and process the jobs in ERP Cloud.

Process with Excel Macro Overview:

The customer will open the customized bank return spreadsheet and select the desired bank return flat file. The information contained into the bank return flat file will be inserted into the bank return spreadsheet automatically. The Load and Import processes must be submitted manually by the customer using the Cloud Application.


This document provides information to support the implementation solution and the ICS components for Brazilian Automatic Load AR Bank Return by Latin America Cloud Local Solution (LACLS) for Brazil.


Brazilian Automatic Load AR Bank Return based on OIC has the following banks:

Brazilian Bank Return Loader with Excel Macro Accelerator is ready to work with the following banks:

NOTE: Another Brazilian Banks will be delivery on demand by Service Request in My Oracle Support under product 13207 - Latin America Cloud Local Solution (LACLS).


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.