Results for “extract_level_code”

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

Overview

GL_TRACK_DELTA_BALANCES is a General Ledger (GL) schema table in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a control and registration table that records which balance-tracking requests have been submitted so that incremental (delta) balances can be maintained in the companion table GL_BALANCES_DELTA. Rather than storing the balances themselves, GL_TRACK_DELTA_BALANCES stores the descriptor rows that identify the ledger, program, period, actual flag, and extraction level for which delta tracking is enabled. This makes it a metadata-driven coordinator for incremental balance extraction, typically driven by concurrent programs and reporting integrations that must avoid full balance re-reads.

From a dimensional modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The single outbound reference to GL_SETS_OF_BOOKS_11I (via LEDGER_ID) indicates the table hangs off the ledger hub rather than acting as an independent hub or a many-to-many link. This is a heuristic suggestion only; the table's business composite key is what truly governs its grain.

Key Information Stored

The table is defined in the GL schema with 12 documented columns. The primary key, GL_TRACK_DELTA_BALANCES_PK, is a composite business key rather than a system-generated surrogate, and it is mirrored by the unique index GL_TRACK_DELTA_BALANCES_U1 on the same column set. The most significant columns are:

• LEDGER_ID — Identifies the ledger (set of books) whose delta balances are being tracked; also the foreign key to GL_SETS_OF_BOOKS_11I.
• PROGRAM_CODE — Identifies the program or process code that requested the incremental balance tracking.
• PERIOD_NAME — The accounting period for which delta tracking applies.
• ACTUAL_FLAG — Distinguishes the balance type (for example actual versus budget) being tracked.
• EXTRACT_LEVEL_CODE — Specifies the granularity of the extraction, controlling how far the delta detail is aggregated.
• CURRENCY_TYPE_CODE — Indicates the currency basis (for example entered, accounted, or converted) associated with the tracking request.
• ENABLED_FLAG — Determines whether the tracked delta request is active.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each tracking request.

Common Use Cases and Queries

Typical usage centers on confirming that a delta-tracking request exists before extracting incremental balances, auditing which programs enabled tracking for a period, and troubleshooting mismatches between requested and available delta data. A representative query joins tracking rows to the ledger and filters by status:

• Verify active tracking for a ledger and period: SELECT ledger_id, program_code, period_name, actual_flag, extract_level_code, enabled_flag FROM gl_track_delta_balances WHERE ledger_id = :ledger_id AND period_name = :period AND enabled_flag = 'Y';
• Locate the programs that registered tracking for a given extraction level and currency type.
• Reconcile GL_BALANCES_DELTA contents against the requests registered here to identify missing or orphaned deltas.
• Audit creation and update history using the standard who-columns for operational troubleshooting.

Related Objects

• GL_SETS_OF_BOOKS_11I — Referenced by GL_TRACK_DELTA_BALANCES.LEDGER_ID; join on LEDGER_ID to resolve ledger name and attributes.
• GL_BALANCES_DELTA — The consumer table holding the actual incremental balance rows produced for registered requests.
• GL_BALANCES — The base balance table against which deltas are compared.
• GL_JE_BATCHES and GL_JE_HEADERS — Journal sources whose postings drive the incremental changes captured as deltas.
• GL_PERIOD_STATUSES — Supplies period context (open, closed, or never opened) for the PERIOD_NAME values recorded here.
• GL_CODE_COMBINATIONS — Provides the accounting flexfield detail referenced by downstream balance and delta reporting.