Simplified Loader’s GL Template provides functionality to upload one or many journal batches using the Excel Spreadsheet in a single click. This simplifies data input and review as Excel makes it very convenient to perform the calculation of totals etc.
GL Journal Template is best suited for the Finance team and data migration. The portable nature of Simplified Loader Excel sheets makes it possible to distribute the file to any user (inside or outside your organization) who wishes to GL Journal details. The Finance team can distribute the Template to other users of the organization to enter Journal which they want to upload in Oracle Fusion. Using Simplified Loader to capture journal details simplifies the end-to-end journal entry process. The same file is used to enter details by the end-user and upload data into Oracle Fusion. GL Journal Template allows us to submit the Journal Import process from within the Spreadsheet and review any import errors. Therefore, the user does not need to use any other screen to complete the end to end journal import process.
Oracle provides FBDI and ADFdi sheets to upload journals into Oracle Fusion. Compared with FBDI, Simplified loader Templates are 95% more convenient to use in terms of organizing data in Excel, steps involved in data upload, and resolving errors. Similarly, in comparison with ADFdi, Simplified Loader Templates are not restricted to use a rigid column sequence set by Oracle. ADFdi sheets cannot be shared with all users. ADFdi needs a plugin and valid login credentials to Oracle Fusion. Please review a detailed comparison with FBDI and ADFdi Template here.
Load Journal for Import
Loading Journals into Oracle Fusion is a two-step process. i.e. Load and Import. Simplified Loader is designed to give users more control over each step, which reduces the chances of failure.
After preparing the Journal in an Excel Spreadsheet, the first step is to load the Journal into Oracle Fusion. “Load Journal for Import” enables the users to upload Journal into Oracle GL interface tables. This operation loads data and reports any failure in real-time. In case of any failure, the error message gets displayed against the Journal.
Load Journal for Import supports loading single or multiple journals in a single click of a button.
Once the Journals are loaded to interface tables, the next step is to import them. “Import Journals” functionality enables the users to submit the import process (ESS Job) in Oracle Fusion. Import Journal functionality gives the flexibility to select Ledgers, Period, etc., to run the import process.
Refresh Import Process Status
The status of the import job can be checked directly from the Simplified Loader Template. Click on the Refresh Import Process Status button to get the status of the last import jobs submitted by Simplified Loader.
Get Group ID Status
It is essential to know the result of journals import status. However, it is critical to understand the error if the Journal is posted successfully. There are cases where journals are submitted with accounts violating cross-validation rules, missing exchange rates, etc. “Get Group ID Status” functionality enables the user to view the status of each journal batch from within the Spreadsheet.
Get Journal Batch
General Ledger Template allows reusing the GL Batch information collected over time. If a Journal already exists in GL and the user wants to create a similar journal or know the information stored in the journal batch, use the operation “Get Journal Batch”. Using the “Get Journal Batch” functionality, the users can download a GL Journal Batch from Oracle Fusion by providing the batch name. This functionality downloads the batch, header and line level information in a single click. You are not limited to download a single batch at a time. Multiple batch names can be entered and downloaded in Excel.
“Get CVR” operation pulls Cross-Validation Rules data from Oracle Fusion into CVR sheet in Simplified Loader template. This operation is a prerequisite to Validate Account against CVR operation.
Validate Account against CVR
“Validate Account against CVR” operation takes segment values entered in the DataSheet and validates segment values against CVR. The validation takes place using offline data in the CVR sheet. In the case of validation failure, the Error Message gets populated in DataSheet.
1) Roles or privileges required for GL Journal Template.
The user must have a General Accountant role to upload transactions.