Oracle Fusion · Data dictionary
GL_JE_BATCHES
General LedgerUsed in 2 subject areas14 reporting columns
General Ledger (GL) — journal batches. One row per batch grouping multiple journals posted together.
Primary key: JE_BATCH_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTED_PERIOD_TYPE | ● | Type of accounted period. | |
| ACTUAL_FLAG | ● | Indicator (Y/N) for the actual. | |
| CONTROL_TOTAL | ● | Control total. | |
| DEFAULT_EFFECTIVE_DATE | ● | Default effective date. | |
| DESCRIPTION | ● | Description. | |
| FUNDS_STATUS_CODE | ● | Code identifying the funds status. | |
| GROUP_ID | ● | Identifier for the group. | |
| JE_BATCH_ID | PK | ○ | Identifier for the je batch. |
| NAME | ● | Name. | |
| POSTED_DATE | ● | Posted date. | |
| 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. |
11 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_BATCHES.
- Cash to General Ledger Reconciliation Report
- Manual Subledger Journals Report
- GL Journal Unposted Report
- Greece Daily Journal Book - Line Descriptions Report
- Italian Journal Book Report
- Journal Approval Audit History Report
- Journal Entry Reversal Detail Report
- Journal Voucher Report for China Secondary Ledger Report
- Pending Transaction Detail Report
- Yevmiye Defteri - Electronic
- Journals Batch Summary 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_BATCHES?
We ship parameterized SQL, BICC config, and dbt models you own.