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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for GL_JE_BATCHES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table