Saturday 7 April 2018

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.

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

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.
How to Enter and Upload GL Journal Data Through Spread Sheet in Oracle Fusion

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

 

3 comments:

Durga said...

I clicked on the Create Journal through spreadsheet link in Oracle Application but I see a blank excel document downloaded with only Oracle title at the top. Do I need to enable any setting in MS Excel

360 Degree Image Editing Service Are you looking at the ghost mannequin effect service? We provide the invisible man said...

gl ADFDI Fusion
Detailed comparison based on 24 parameters on why Simplified Loader templates are more convenient than ADFdi or FBDI. Simplified loader sheets allow to upload and download of data from Oracle Fusion. Simplified Loader supports Single Sign-On and requires no installation on the user's PC. - <a

href="https://simplifiedloader.com/Resources/compare_fbdi_adfdi_simplifiedloader/https://simplifiedloader.com/Resources/compare_fbdi_adfdi_simplifiedloader</a

360 Degree Image Editing Service Are you looking at the ghost mannequin effect service? We provide the invisible man said...

gl ADFDI Fusion
Detailed comparison based on 24 parameters on why Simplified Loader templates are more convenient than ADFdi or FBDI. Simplified loader sheets allow to upload and download of data from Oracle Fusion. Simplified Loader supports Single Sign-On and requires no installation on the user's PC.. - <a href="https://simplifiedloader.com/Resources/compare_fbdi_adfdi_simplifiedloader/https://simplifiedloader.com/Resources/compare_fbdi_adfdi_simplifiedloader</a

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *