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
3 comments:
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
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
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