Search Results ce_forecast_opening_bal_n2

Overview

CE.CE_FORECAST_OPENING_BAL is a transactional table in the Cash Management (CE) module of Oracle E-Business Suite, holding the opening bank balance or GL cash account balance for a given start date that pertains to a defined set of cash forecast results. Each row associates an opening balance amount with a forecast run, a specific balance date, and either a bank account or a GL cash accounting flexfield, allowing the forecasting engine to anchor projected cash positions on a known starting point.

Under the heuristic Data Vault classification supplied in the metadata, this table is satellite-leaning. In Data Vault terms it behaves as a descriptive satellite attached to forecast and account hub or link structures, capturing point-in-time measures (opening balance, prior-day cashflow) qualified by a balance date and standard Who audit columns. Modeling efforts should treat BALANCE_ID as the durable row identifier and FORECAST_ID, BANK_ACCOUNT_ID, CODE_COMBINATION_ID, and LEGAL_ENTITY_ID as the referencing keys that connect the satellite to its parent hubs and links.

Key Information Stored

The table is defined with 14 columns in the documented 12.2.2 schema. The most significant are:

• BALANCE_ID – Surrogate primary key (CE_FORECAST_OPENING_BAL_PK) and the column underpinning the unique index CE_FORECAST_OPENING_BAL_U1, which is the documented business-key candidate. It is mandatory and numeric (15).
• FORECAST_ID – Identifier of the forecast run to which the balance belongs; the primary driver of most non-unique index access paths.
• BALANCE_TYPE – VARCHAR2(30) discriminator indicating whether the row represents a Bank Account or a GL Cash Account balance, determining which of the two account columns is meaningful.
• BANK_ACCOUNT_ID – Bank account identifier; foreign key to AP_BANK_ACCOUNTS_ALL.
• CODE_COMBINATION_ID – Accounting Flexfield identifier for the GL cash account associated with the bank account.
• OPENING_BALANCE – The opening balance amount itself, unconstrained numeric.
• BALANCE_DATE – Effective date of the opening balance.
• PRIOR_DAY_CFLOW – Prior-day cashflow figure carried alongside the opening balance.
• LEGAL_ENTITY_ID – Legal entity identifier; foreign key to FV_LEGAL_ENTITIES.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Who audit columns present on the table.

Common Use Cases and Queries

The table is typically queried to reconcile forecast starting positions, validate that an opening balance exists for each forecast and account combination before a forecast run, and report opening balances by legal entity, bank account, or GL cash account. A representative retrieval follows the documented query text:

• Opening balance by forecast and date: SELECT forecast_id, balance_date, balance_type, opening_balance FROM ce.ce_forecast_opening_bal WHERE forecast_id = :forecast_id AND balance_date = :balance_date.
• Bank-account view: join BALANCE_ID rows filtered by BALANCE_TYPE = 'Bank Account' to AP_BANK_ACCOUNTS_ALL on BANK_ACCOUNT_ID for account names and numbers.
• GL cash-account view: filter BALANCE_TYPE = 'GL Cash Account' and join CODE_COMBINATION_ID to GL_CODE_COMBINATIONS for segment reporting.
• Legal-entity rollup: aggregate OPENING_BALANCE and PRIOR_DAY_CFLOW by LEGAL_ENTITY_ID for a given FORECAST_ID, exploiting index CE_FORECAST_OPENING_BAL_N4.

Related Objects

The documented foreign keys and indexes tie this table to the following significant objects:

• AP_BANK_ACCOUNTS_ALL – referenced by BANK_ACCOUNT_ID; supplies bank account definition.
• FV_LEGAL_ENTITIES – referenced by LEGAL_ENTITY_ID; supplies legal entity context.
• GL_CODE_COMBINATIONS – implicit parent of CODE_COMBINATION_ID for GL cash account validation and reporting.
• CE_FORECASTS / forecast result structures – the FORECAST_ID column links rows to the parent forecast definition, and indexes CE_FORECAST_OPENING_BAL_N2, N3, and N4 lead with FORECAST_ID to support that access path.

Collectively, these relationships make CE.CE_FORECAST_OPENING_BAL the anchoring satellite that connects forecast runs to the bank and GL cash accounts whose balances seed each projection.