Friday, 25 July 2025

How to Perform Journal Import Using File-Based Data Import (FBDI) in Oracle Fusion General Ledger

How to Perform Journal Import Using File-Based Data Import (FBDI) in Oracle Fusion General Ledger

FBDI is Oracle’s preferred way to load bulk data into Fusion Cloud. This technical post covers how to upload General Ledger journal entries using FBDI templates.

Step 1: Download the JournalImportTemplate.xlsm

Visit the Oracle Enterprise Repository or the Oracle Fusion Documentations (docs.oracle.com)

1. Select Cloud Applications

2. Select Financials

3. Select All Books

4. Under Implementation -> File-Based Data Import(FBDI) for financials and search for "General Ledger -> Journal Import". 

Download the FBDI template named JournalImportTemplate.xlsm.

Step 2: Fill the Template

  • Go to the GL_INTERFACE tab
  • Fill in Ledger ID, Accounting Date, Currency, Account segments, Debit/Credit

Example: This is below sample data, but please fill in all the required columns as per the FBDI template and required fields

LEDGER_ID: 123
Journal Source : Provide the appropriate Journal source as per the configurations
Journal Category : Provide the appropriate Journal source as per the configurations
CURRENCY_CODE: INR
ENTERED_DR: 5000 ENTERED_CR: 0

Click Generate CSV File in the template.

Step 3: Upload to UCM

  1. Go to Tools → File Import and Export
  2. Upload the generated ZIP file
  3. Set account to fin/generalLedger/import

Step 4: Run Load Interface File for Import

  • Navigate to Scheduled Processes
  • Run Load Interface File for Import
  • Select your ZIP file and choose Import Process: Journal Import

Step 5: Submit Journal Import Process

Run the Import Journals process. Specify source and category used during file generation.

Step 6: Review and Post Journals

  1. Go to General Accounting → Journals → Manage Journals
  2. Review and post imported journal entries

Troubleshooting

ErrorCauseFix
Ledger ID missingInvalid IDUse SQL to find correct ledger
No journals importedCSV mismatchRe-generate from template