Results for “je_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_JOURNAL_ENTRIES is a core transaction table in the Oracle Assets (OFA) module, residing in the FA schema. It stores journal entry information generated by Oracle Assets for transfer to Oracle General Ledger. Each row represents a logical grouping of asset transactions — additions, adjustments, depreciation, reclassifications, retirements, revaluations, transfers, and capital-in-progress (CIP) activity — that must be posted to the general ledger for a given book and accounting period.

The table acts as the bridge between Asset subledger activity and the GL interface. It records batch and group identifiers that tie journal entries back to the originating asset transaction batches, allowing the Create Journal Entries process and subsequent Journal Entry Inquiry screens to display, reconcile, and post asset accounting entries. The table is therefore central to period-end close for asset-intensive organizations.

Under the heuristic Data Vault classification mined from its foreign key structure, FA_JOURNAL_ENTRIES is modeled as a link table. It connects independent business entities — the set of books and the depreciation period — through its foreign keys, while also carrying descriptive and status attributes. This classification is a modeling suggestion rather than a documented Oracle designation.

Key Information Stored

• CJE_ID — Surrogate primary key (FA_JOURNAL_ENTRIES_PK) and the sole column of unique index FA_JOURNAL_ENTRIES_U1. It is also the business-key candidate referenced by downstream interface tables.
• SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS_11I, identifying the asset book's ledger.
• BOOK_TYPE_CODE and PERIOD_COUNTER — Together form the foreign key to FA_DEPRN_PERIODS, anchoring the entry to a specific book and accounting period.
• JE_STATUS — Tracks the processing state of the journal entry (for example, whether it has been created or posted).
• Transaction batch identifiers — ADDITION_BATCH_ID, ADJUSTMENT_BATCH_ID, DEPRECIATION_BATCH_ID, RECLASS_BATCH_ID, RETIREMENT_BATCH_ID, REVAL_BATCH_ID, TRANSFER_BATCH_ID, DEPRN_ADJUSTMENT_BATCH_ID, and their CIP equivalents, each linking the entry to the batch that generated it.
• Transaction group identifiers — ADDITION_GROUP_ID, DEPRECIATION_GROUP_ID, DEFERRED_DEPRN_GROUP_ID, and parallel CIP and other group columns, providing finer-grained grouping within batches.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN track record ownership and change history.

The table comprises 41 documented columns in ETRM 12.2.2. The surrogate key CJE_ID is distinct from the composite business identifier formed by SET_OF_BOOKS_ID, BOOK_TYPE_CODE, and PERIOD_COUNTER.

Common Use Cases and Queries

Typical scenarios include period-end reconciliation of asset journal entries, tracing a posted GL entry back to its asset batch, and validating that all expected entry types were generated for a period.

• Retrieve all journal entries for a book and period:
  SELECT cje_id, je_status, depreciation_batch_id FROM fa_journal_entries WHERE set_of_books_id = :sob AND book_type_code = :book AND period_counter = :pc;
• Join to FA_DEPRN_PERIODS to resolve period names for reporting.
• Join to GL_SETS_OF_BOOKS_11I to obtain ledger context.
• Filter by JE_STATUS to isolate entries pending post to GL.
• Aggregate by batch or group identifiers to reconcile subledger totals against GL balances.

Related Objects

• GL_SETS_OF_BOOKS_11I — referenced via SET_OF_BOOKS_ID.
• FA_DEPRN_PERIODS — referenced via BOOK_TYPE_CODE and PERIOD_COUNTER.
• FII_FA_NEW_EXP_CJE_IDS — references FA_JOURNAL_ENTRIES.CJE_ID.
• FII_FA_EXP_CJE_IDS — references FA_JOURNAL_ENTRIES.CJE_ID.
• FA_JOURNAL_ENTRIES_PK / FA_JOURNAL_ENTRIES_U1 — primary and unique indexes on CJE_ID.

Together these relationships support journal entry creation, inquiry, and transfer to General Ledger within the Oracle Assets subledger.