# Oracle EBS GL Journal Import Worksheet

> Source: https://netray.co/tools/oracle-ebs-gl-journal-import-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Prepare journal lines in the shape of GL_INTERFACE, check debits against credits per row set, and export to Excel or CSV before loading.

## Category

oracle

## Erp

Oracle E-Business Suite

## Audience

- GL accountant
- EBS finance analyst
- EBS developer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Line

**Key:** line

**Type:** number

#### Ledger

**Key:** ledger

**Type:** text

#### Accounting date

**Key:** acct_date

**Type:** date

#### User JE source

**Key:** source

**Type:** select

**Options:**

- Manual
- Spreadsheet
- Payroll
- Allocations

#### User JE category

**Key:** category

**Type:** select

**Options:**

- Adjustment
- Accrual
- Reclass
- Payroll

#### Currency

**Key:** ccy

**Type:** select

**Options:**

- USD
- EUR
- GBP
- INR

#### Company segment

**Key:** co

**Type:** text

#### Natural account

**Key:** acct

**Type:** text

#### Cost center

**Key:** cc

**Type:** text

#### Entered Dr

**Key:** dr

**Type:** number

**Format:** currency

#### Entered Cr

**Key:** cr

**Type:** number

**Format:** currency

#### Net (Dr minus Cr)

**Key:** net

**Type:** number

**Expr:** dr - cr

**Format:** currency

#### Line description

**Key:** desc

**Type:** text

**Rows:**

**Line:** 1

**Ledger:** US Primary

**Acct date:** 2026-09-30

**Source:** Spreadsheet

**Category:** Accrual

**Ccy:** USD

**Co:** 01

**Acct:** 6410

**Cc:** 210

**Dr:** 18500

**Cr:** 0

**Desc:** Sept freight accrual

**Line:** 2

**Ledger:** US Primary

**Acct date:** 2026-09-30

**Source:** Spreadsheet

**Category:** Accrual

**Ccy:** USD

**Co:** 01

**Acct:** 2210

**Cc:** 000

**Dr:** 0

**Cr:** 18500

**Desc:** Sept freight accrual

**Line:** 3

**Ledger:** US Primary

**Acct date:** 2026-09-30

**Source:** Spreadsheet

**Category:** Reclass

**Ccy:** USD

**Co:** 01

**Acct:** 5120

**Cc:** 340

**Dr:** 4200

**Cr:** 0

**Desc:** Reclass tooling to COGS

**Line:** 4

**Ledger:** US Primary

**Acct date:** 2026-09-30

**Source:** Spreadsheet

**Category:** Reclass

**Ccy:** USD

**Co:** 01

**Acct:** 1540

**Cc:** 340

**Dr:** 0

**Cr:** 4200

**Desc:** Reclass tooling to COGS

**Totals:**

#### Total debits

**Key:** dr

**Agg:** sum

**Format:** currency

#### Total credits

**Key:** cr

**Agg:** sum

**Format:** currency

#### Out of balance

**Key:** net

**Agg:** sum

**Format:** currency

**Summary:**

#### Balance difference

**Key:** balanced

**Expr:** sum_dr - sum_cr

**Format:** currency

**Primary:** true

**Description:** Must be zero for each journal before it is loaded.

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use the worksheet

**Body:** 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

**Body:** 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.

**Bullets:**

- 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### What table does Oracle EBS Journal Import read?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

oracle ebs gl_interface upload excel, oracle gl journal import template, oracle ebs journal import worksheet, gl_interface columns, oracle ebs manual journal upload, oracle ebs journal import debit credit balance, oracle apps gl journal template excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json