How To Automate The File Based Load Functionality
(Doc ID 1609728.1)
Last updated on SEPTEMBER 11, 2020
Applies to:Oracle Fusion General Ledger - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Oracle Fusion General Ledger Cloud Service - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 1.0]
Oracle Fusion Financials Common Module - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Oracle Fusion Financials Common Module Cloud Service - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Information in this document applies to any platform.
The File based load functionality available starting in Release 7 is implemented using the Content Management server (UCM).
The general steps are as provided in <Note 1584415.1. Prepare your data and generate a data file by using the product-specific templates and control files. The templates are obtained from the Oracle Enterprise Repository (OER):
2. Transfer the data file generated in step 1. to the integrated content management server and then follow the steps below:
Login to Fusion Application
Navigator->Tools->File Import and Export.
Provide the parameters which are the file generated in 1 and the predefined account 'fin/generalLedger/import'
3. Run ESS program Load Interface File for Import. This program loads the data in gl_interface.
4. Correct data load errors, if necessary.
5. Run the journal import program to import the information from the gl_interface table into the GL journal tables. Correct data import errors, if necessary.
Is there a way to automate the upload of the prepared spreadsheet to the content management server?
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