Results for “balance_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CN_LEDGER_JOURNAL_ENTRIES_ALL is the base table in the Oracle Incentive Compensation (CN) module that stores the individual debit and credit lines comprising incentive compensation journal entries. Each row represents a single posting line within a compensation ledger journal entry, capturing the accounting effect (debit or credit amount), the reason code, and the business context under which the entry was generated. In Oracle EBS 12.1.1 and 12.2.2, this table serves as the transactional store of compensation-related accounting distributions that feed downstream general ledger integration and compensation reconciliation reporting.
From a dimensional modeling perspective, the ETRM heuristic classifies this table as a link structure. It sits at the intersection of several reference entities — the SRP period, the journal entry batch, the ledger balance type, and the operating unit — and its primary role is to associate those dimensions with a quantified debit or credit measure. Modelers should treat it as an associative link rather than a hub or satellite.
Key Information Stored
The most significant columns can be grouped into identifiers, financial measures, and audit attributes.
- LEDGER_JE_ID — Surrogate primary key (CN_LEDGER_JOURNAL_ENTRIES_PK) uniquely identifying each journal entry line.
- BATCH_ID — Foreign key to CN_LEDGER_JE_BATCHES_ALL, grouping lines into a single journal entry batch run.
- SRP_PERIOD_ID — Foreign key to CN_SRP_PERIODS_ALL, tying the line to the compensation period for which the entry was generated.
- BALANCE_ID — Foreign key to CN_LEDGER_BAL_TYPES_ALL_B, identifying the balance type (for example, paid, earned, or adjustment) affecting the posting.
- CREDIT / DEBIT — The monetary amounts that constitute the accounting entries; only one side is typically populated per row.
- JE_DATE — The effective accounting date of the journal entry line.
- REASON — Free-text or coded explanation of why the entry was created, useful for audit and reconciliation.
- ORG_ID — Operating unit identifier supporting Multi-Org partitioning across legal entities.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS controlling row-level access.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO columns recording insert and update audit trail.
Common Use Cases and Queries
Typical applications include reconciling compensation postings to the general ledger, analyzing debit and credit balances by period, and auditing adjustment activity.
A common reporting pattern aggregates debits and credits by compensation period and balance type:
SELECT j.SRP_PERIOD_ID,
j.BALANCE_ID,
SUM(j.DEBIT) AS total_debit,
SUM(j.CREDIT) AS total_credit
FROM CN.CN_LEDGER_JOURNAL_ENTRIES_ALL j
WHERE j.ORG_ID = :p_org_id
GROUP BY j.SRP_PERIOD_ID, j.BALANCE_ID;
To trace all lines belonging to a specific journal batch, developers join to the batch header on BATCH_ID, and to resolve the period name they join CN_SRP_PERIODS_ALL on SRP_PERIOD_ID. Because ORG_ID drives Multi-Org access, queries should always restrict on the operating unit to avoid cross-entity data leakage. Feeder queries for GL interface programs typically filter rows by JE_DATE range and batch status.
Related Objects
- CN_LEDGER_JE_BATCHES_ALL — Parent batch table; join on CN_LEDGER_JOURNAL_ENTRIES_ALL.BATCH_ID = CN_LEDGER_JE_BATCHES_ALL.BATCH_ID.
- CN_SRP_PERIODS_ALL — Compensation period definition; join on SRP_PERIOD_ID.
- CN_LEDGER_BAL_TYPES_ALL_B — Balance type reference; join on BALANCE_ID.
- FND_SECURITY_GROUPS — Secures row visibility; join on SECURITY_GROUP_ID.
- CN_LEDGER_JOURNAL_ENTRIES_PK — Primary key constraint enforcing LEDGER_JE_ID uniqueness.
These relationships define the core access path for both concurrent-program integration and ad hoc compensation reporting.
-
Individual lines of journal entries
-
This table is a backup of the ce_fc_opening_bal table before the bank account foreign key upgrade.
-
Individual lines of journal entries
-
This table is a backup of the ce_fc_opening_bal table before the bank account foreign key upgrade.
-
Third Party Balances Table Summarized By Third Party Identifier And Period For A Code Combination And Set Of Books ID
-
Lookup table for account names
-
Lookup table for account names
-
Lookup table for account names
-
Records audit trail for any changes to the balances in case of Fee and Holds Balance Type
-
This table contains balance amount for a party in the context of an Account.
-
Lookup table for account names
-
This table stores the opening bank balance or GL cash account balance for a particular Start Date pertaining to a set of forecast results
-
This table stores the opening bank balance or GL cash account balance for a particular Start Date pertaining to a set of forecast results
-
Third Party Balances Table Summarized By Third Party Identifier And Period For A Code Combination And Set Of Books ID
-
VIEW: JL.JL_CO_GL_BALANCES# 12.2.2
-
VIEW: JL.JL_CO_GL_BALANCES# 12.2.2
-
TABLE: IGS.IGS_FI_BALANCES 12.1.1