Oracle EBS GL Journal Import Worksheet
Month-end journals often start life in a spreadsheet. This worksheet lays them out the way the GL_INTERFACE table expects them and proves that debits equal credits before anyone loads the file, so the Journal Import run does not come back with unbalanced or invalid account errors.
| Line | Ledger | Accounting date | User JE source | User JE category | Currency | Company segment | Natural account | Cost center | Entered Dr | Entered Cr | Net (Dr minus Cr) | Line description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
$18,500 | |||||||||||||
-$18,500 | |||||||||||||
$4,200 | |||||||||||||
-$4,200 |
Columns follow the idea of GL_INTERFACE (STATUS, LEDGER_ID, ACCOUNTING_DATE, CURRENCY_CODE, ACTUAL_FLAG, USER_JE_SOURCE_NAME, USER_JE_CATEGORY_NAME, SEGMENT1..n, ENTERED_DR, ENTERED_CR). Your load script must supply STATUS = NEW, ACTUAL_FLAG = A, ledger ID, created-by and date-created values, and your own segment layout.
Automate journal prep from ERP data
Optional conversation on generating and checking recurring journals from your ledger and subledger data.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Replace the example rows with your journal lines. Keep one journal per set of lines sharing the same ledger, accounting date, source, category and currency, because Journal Import groups on those values. The net column shows debit minus credit per line and the summary shows the total difference. Export to Excel or CSV, then hand the file to whoever runs your SQL*Loader or API based load.
How Journal Import consumes the rows
Rows are inserted into GL_INTERFACE with a status of NEW. The Journal Import program in the General Ledger responsibility reads them, validates the code combinations, periods and currencies, and creates journal batches in GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES. Rows that fail validation stay in the interface with an error status code, and you either correct them in place or delete them and reload.
- Open period required for the accounting date
- Segment values must form a valid, enabled code combination
- Source name must exist in Journal Sources
- Use a unique group ID to isolate a load
Common mistakes
Out of balance journals usually come from rounding in foreign currency or a forgotten offset line. Another frequent error is an accounting date in a closed period, which sends the whole set to an error state. Do not edit GL_INTERFACE directly in production without a controlled script and a backup of the rows, and always have a second person review the totals before submission.
Frequently Asked Questions
What table does Oracle EBS Journal Import read?
Journal Import reads GL_INTERFACE. After a successful run, the data moves into the GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES tables. Rows with problems remain in the interface with a status code describing the error.
Can I upload an Excel file straight into Oracle GL?
In EBS, the usual options are a load script into GL_INTERFACE, or the Applications Desktop Integrator (ADI) journal wizard. This worksheet helps you prepare and check the data first, whichever route you choose.
Why does Journal Import reject my rows?
Typical reasons are a closed accounting period, an invalid account combination, an unknown journal source or category, or an unbalanced set. Check the status column in GL_INTERFACE and the Journal Import execution report.
Do all journal lines need the same currency?
Each journal has a single currency, so group lines accordingly. Foreign currency journals also need conversion type and rate information, which this simple worksheet does not cover.
If month-end journal prep is eating your close, tell us what the data source is. We can discuss automating the extract and checks while keeping a human approval step.
Related Tools
Oracle EBS Concurrent Program Registration Request Template
A request form that captures everything an EBS developer needs to register a custom concurrent program: executable, execution method, parameters, request group and incompatibilities.
OracleOracle EBS Profile Option Change Log Worksheet
Track every profile option change with its level, old and new value, reason and approver, so clones, upgrades and audits stop being guesswork.
OracleOracle EBS Tablespace Growth Forecast Calculator
Project compound growth of an EBS tablespace or database, find when it crosses an alert threshold and how much storage to add.
OracleOracle EBS User Access Review Template
A periodic access review record for EBS users and responsibilities, with scope, evidence, exceptions and reviewer sign-off.
More Oracle tools
See all- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS Inventory Accuracy Readiness Assessment
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Period Close Checklist
- Oracle EBS AP Invoice Interface Template
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS GL_INTERFACE Journal Import Error Codes ReferenceDecode every common Journal Import Execution Report error code, see which GL_INTERFACE columns cause it and how to fix it, for EBS R12.
- Oracle EBS BOM Interface Load WorksheetStage BOM component rows with the columns used by the Oracle BOM open interface, then export to Excel for loading.
- Oracle EBS GL Period Close ChecklistA month-end close sequence for Oracle General Ledger and the subledgers that feed it, with critical steps marked.
ERP fixes and how-tos
- Data Conversion in Oracle EBS: Interface Tables, Open Interfaces and ReconciliationHow data conversion works in Oracle EBS: extract, stage, validate, load through interface tables and APIs, then reconcile. Practical steps and common failures.
- Oracle Fusion General Ledger: Import Journals errors and rejected rowsFix Oracle Fusion General Ledger journal import errors: read GL_INTERFACE status, check source, ledger, period and account validity, then correct and reimport.
- Oracle EBS Month-End Close Checklist: GL, AP, ARStep-by-step Oracle EBS month-end close order: finish sub-ledger transactions, close AP and AR periods, transfer to GL, reconcile, then close GL. Menu paths included.
AI on your ERP
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
Integrations
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.
- How to automate email-to-transaction in Oracle E-Business SuiteTurn inbound POs, RFQs, invoices and supplier confirmations in shared mailboxes into Oracle EBS transactions through open interfaces, with review and audit.