Oracle Fusion · Data dictionary
GL_JE_HEADERS
General LedgerUsed in 2 subject areas34 reporting columns
General Ledger (GL) — journal headers. One row per journal entry; grouped into batches via GL_JE_BATCHES.
Primary key: JE_HEADER_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCRUAL_REV_FLAG | ● | Indicator (Y/N) for the accrual rev. | |
| ACTUAL_FLAG | ● | Indicator (Y/N) for the actual. | |
| BALANCING_SEGMENT_VALUE | ● | Balancing segment value. | |
| CLOSE_ACCT_SEQ_VALUE | ● | Close account seq value. | |
| CONTROL_TOTAL | ● | Control total. | |
| CONVERSION_FLAG | ● | Indicator (Y/N) for the conversion. | |
| CR_BAL_SEG_VALUE | ● | Cr balance segment value. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CURRENCY_CONVERSION_DATE | ● | Currency conversion date. | |
| CURRENCY_CONVERSION_RATE | ● | Currency conversion rate. | |
| CURRENCY_CONVERSION_TYPE | ● | Type of currency conversion. | |
| DATE_CREATED | ● | Date created. | |
| DEFAULT_EFFECTIVE_DATE | ● | Default effective date. | |
| DESCRIPTION | ● | Description. | |
| DOC_SEQUENCE_VALUE | ● | Doc sequence value. | |
| DR_BAL_SEG_VALUE | ● | Dr balance segment value. | |
| JE_FROM_SLA_FLAG | ● | Indicator (Y/N) for the je from sla. | |
| JE_HEADER_ID | PK | ● | Identifier for the je header. |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LOCAL_DOC_SEQUENCE_VALUE | ● | Local doc sequence value. | |
| MULTI_CURRENCY_FLAG | ● | Indicator (Y/N) for the multi currency. | |
| NAME | ● | Name. | |
| ORIGINATING_BAL_SEG_VALUE | ● | Originating balance segment value. | |
| PERIOD_NAME | ● | Name of the period. | |
| POSTED_DATE | ● | Posted date. | |
| POSTING_ACCT_SEQ_VALUE | ● | Posting account seq value. | |
| POST_MULTI_CURRENCY_FLAG | ● | Indicator (Y/N) for the post multi currency. | |
| REVERSED_JE_HEADER_ID | ● | Identifier for the reversed je header. | |
| RUNNING_TOTAL_ACCOUNTED_CR | ● | Running total accounted cr. | |
| RUNNING_TOTAL_ACCOUNTED_DR | ● | Running total accounted dr. | |
| RUNNING_TOTAL_CR | ● | Running total cr. | |
| RUNNING_TOTAL_DR | ● | Running total dr. | |
| STATUS | ● | Status. |
24 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to GL_JE_HEADERS.
- Cash to General Ledger Reconciliation Report
- Manual Subledger Journals Report
- Account Analysis Report
- Account Ledger by Account Greece Report
- China Account Analysis Detail Report
- France GL Extract for ETAFI Report
- GL Detail by Budget Center with Project Detail
- GL Journal Unposted Report
- Greece Daily Journal Book - Line Descriptions Report
- Italian Journal Book Report
- Journal Entry Reversal Detail Report
- Journal Voucher Report for China Secondary Ledger Report
- Libro Partitario Report
- Pending Transaction Detail Report
- Revaluation Report
- Vietnam Journal Voucher Report
- Yevmiye Defteri - Electronic
- Audit Report for France
- General Ledger Account Details Report
- Journals Report
- General Journals Report
- Journals Batch Summary Report
- Journals Details Report
- Journals Day Book Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for GL_JE_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.