How to Enter and Upload GL Journal Data Through Spread Sheet in Oracle Fusion

How to Enter and Upload GL Journal Data Through Spread Sheet in Oracle Fusion

In Oracle Fusion , We can Upload GL journals through Excel spread Sheet. You may use Oracle ADF Desktop Integrator (ADFDI) to create journal worksheets in Microsoft Excel. From a journal worksheet you can enter journal entries, then upload and post them to General Ledger. Oracle Fusion has provided ADFDI feature to upload GL journals data through Spreadsheet. But before uploading data through spreadsheet we need to do some settings in our system to use the ADFDI feature. We need to install Desktop Integration Installer from Oracle Fusion Application to our system to use the ADFDI feature in Oracle Fusion. You can refer the post Excel and System Settings for ADFDI in Oracle Fusion to use ADFDI feature in Oracle Fusion.

 

 

How to Enter and Upload GL Journal Data Through Spread Sheet in Oracle Fusion

 

Step1:-

Create Journals Through Spread sheet.

Journal Entry -> Journals -> Create Journals in Spreadsheet 

In the dialog box, choose to open the template (or save it to your directory and then open it from there)

In the Connect box, select Yes to confirm you want to connect to the Fusion instance.                                                                      

Step2:-
The program will log into Oracle to determine the data access for the user. A dialogue box opens to  connect to the server which helps user to Login Click Yes to connect.

Save Spreadsheet. File -> Save: Upon logging into the system, ADFDI will create a journal spreadsheet ready for entry. Save the spreadsheet for current or future use.

Step3:-
In the spreadsheet, note that columns starting with a * are required. For ** columns at least one of them must be entered.
Additionally, columns with a [..] suffix can have a Search window displayed by double clicking on the cell.

Step4:-
Process Header Journal Information.
 Enter or search and select (depending on the column) the header information for the journal. 




Step5:-
Process Line Journal Information.
 Enter or search and select (depending on the column) the journal line information for the journal.  


Step6:- When finished, upload the journal.
 Click on Submit (B) to upload the Journal.

Then Search for the journal in general ledger through Manage Journal.
Journal -> Manage Journal

How to Enter and Upload GL Journal Data Through Spread Sheet in Oracle Fusion