Create Journals though Spreadsheet in Oracle Fusion Applications

You can create Journal Entries in Oracle Fusion applications in two ways.
You can create it manually one-by-one or by Bulk through Excel Spreadsheets using the File-Based Data Import for Financials Cloud (commonly known as FBDI). For the manual process, you may refer to the tutorial found here: Create GL Journal Entry in Oracle Fusion Applications. For the bulk process, you first need to install FBDI on your Local PC and ensure you have the appropriate Microsoft Office version installed. For this article, we will use Microsoft Office o365 or 2016 and FBDI version 11.1.1.9.3 (build 5.0.2.18097).

Go to General Accounting > Journals 

Click on the Task Pane and choose Create Journal in Spreadsheet

Depending on the browser, you will be asked to either open the file in Microsoft Excel (for Mozilla) or it will download the file on your Local PC right away (for Chrome). Either way, proceed to open the file in Microsoft Excel:

Once the file has been opened in Excel, click on "Enable Editing" and proceed to confirm that you want to Connect:

You will be prompted to login using your Username and Password. Use the Username and Password that has the appropriate access to the Ledger you want to import transactions in.

Once login has been confirmed, the spreadsheet will now show the appropriate fields and you can proceed to input the Ledger Header and Line Details. The fields below in Red are the recommended fields you must populate:

For the Chart of Accounts (CoA), You may manually input the values or double-click on the field to select from the List of Values (LoV):

If you've completed entering the necessary information, proceed to click on "Submit" from the Ribbon. You will be prompted to select an option to either:

1. Save the data to the GL_INTERFACE table without importing into the GL Base Tables (GL_JE_HEADERS, GL_JE_LINES, etc.)
2. Save the data to the GL_INTERFACE table and subsequently import data into the GL Base Tables
3. Save the data to the GL_INTERFACE table and subsequently import data into the GL Base Tables and process them for Posting

Once the process has completed successfully, the status will show as "Row inserted successfully" in the "Row Status" column in the Spreadsheet.

On the other hand, Error Lines will show as "Error" and you may update any incorrect data and resubmit to try again.

To verify the uploaded data, navigate to the Springboard > General Accounting > Journals then click on the Task Pane and select "Manage Journals".

You may use the Ledger name you've provided to quickly search for your Journal Batch:

Below is a quick video demonstration on the topic above:

Create GL Journal Entry in Oracle Fusion Applications

To create a General Ledger Journal Entry in Oracle Fusion Applications, navigate to your springboard and go to General Accounting > Journals:

on the Journals dashboard, you can see items that are important to your process such as Journals that require your attention (Error or Incomplete) or journals pending for approval from your superiors, etc. These are being populated by Oracle Fusion's embedded intelligence. To proceed with creating a Journal, click on the Task Panel and select "Create a Journal":

In the "Create Journal" screen, you have three sections: Journal Batch, Journal Headers and Journal Lines. A Journal Batch name and a Journal name is not required but is recommended to make searching and viewing easier later on.

Journal Lines is where you'll put your accounting code combinations (sometimes called as Chart of Accounts or COA) and the Credit/Debit amounts.

Also make sure to select the correct Journal Category to correctly classify the Journal Entry:

Once done, you may save and mark this entry as Complete and Post it.

Depending on your organizational settings, this may require some approval from your direct superiors. This may be configured to skip approval.

You may revisit your entry by navigating to the Journals Dashboard > Task Panel > "Manage Journals" and search for your transaction using your Journal Batch name or period:

Below is a video demonstrating further:

Hope this helps! Don't forget to like, share and leave a comment. :)

Follow my other Social Media Accounts!
Facebook Page: https://www.facebook.com/theOracleProdigy/
Twitter: https://twitter.com/D_OracleProdigy