Before You Install the Recipe
You must perform the following configuration tasks on your Amazon S3 and Oracle ERP Cloud instances in order to connect to these external systems using Oracle Integration, and successfully import financial journal entries from an Amazon S3 bucket to Oracle ERP Cloud.
Configure Amazon S3
Complete the following configuration tasks on your Amazon S3 instance to connect to it from Oracle Integration and import financial journal entries.
- Obtain your AWS access keys. See Prerequisites for Creating a Connection in Using the Amazon Simple Storage Service (S3) Adapter with Oracle Integration 3.
- Set up your Amazon S3 bucket where you want the resulting log file to be stored.
- Note the AWS Region of the bucket.
- Select the bucket.
- Click the Properties tab, and note the AWS Region of the bucket.
Configure Oracle ERP Cloud
Complete the following configuration tasks on your Oracle ERP Cloud instance to connect to it from Oracle Integration, and import financial journal entries.
Perform the general configuration tasks for creating a connection. See Prerequisites for Creating a Connection in Using the Oracle ERP Cloud Adapter with Oracle Integration 3.
Financial journal entries have to be in a particular format so that Oracle Enterprise Scheduler (ESS) Jobs can be run and the financial data can be finally stored in a log file. To enable this, you have to download the journal import template from Oracle ERP Cloud and prepare a journal import file based on it.
- Download the journal import template (
JournalimportTemplate.xlsm
).- Navigate to Oracle Fusion Cloud Applications Suite in Oracle Help Center.
- Under Enterprise Resource Planning (ERP), click Financials.
- In the left navigation pane of the Oracle Financials Get Started page, click All Books.
- Under Implementation, open the File-Based Data Import (FBDI) for Financials guide.
- Under the General Ledger section of the guide, click Journal Import.
- In the File Links section, download the journal import template XLSM file (
JournalimportTemplate.xlsm
) and save it to your local machine.
- Prepare the journal import data file.