Search Results ce_forecast_ext_views_pk

Overview

CE_FORECAST_EXT_VIEWS is a Cash Management (CE) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines the external data sources available to the Cash Forecasting engine. Cash Management allows forecast templates to incorporate balances and transactions that originate outside the Oracle ledger — for example, bank statement feeds, treasury systems, or third-party ERP instances. Each row in this table registers one such external source by mapping an external source type to the database view (and optionally a database link) that exposes the data in a queryable form. The forecasting engine then resolves these registrations at runtime and includes them in the generated forecast worksheet.

The documented Data Vault classification for this object is standalone, meaning the metadata mining did not identify foreign-key dependencies to other tables. As a modeling suggestion, this object is best treated as a small reference or configuration hub whose business key is the external source type itself, rather than as a transactional satellite. The absence of inbound or outbound foreign keys indicates the table is maintained directly by administrators rather than populated by concurrent programs.

Key Information Stored

The table contains eight documented columns. The most significant are listed below.

• EXTERNAL_SOURCE_TYPE — the business identifier for the external forecast source. This is the column named in both the primary key constraint CE_FORECAST_EXT_VIEWS_PK and the unique index CE_FORECAST_EXT_VIEWS_U1, which makes it the true business key of the table.
• EXTERNAL_SOURCE_VIEW — the name of the database view that the forecasting engine queries to retrieve the external data. This is the operative column: it tells Cash Management where the external rows reside.
• DB_LINK_NAME — an optional Oracle database link through which the external view is accessed. When populated, forecasts can consolidate data from a remote instance; when null, the view is assumed to be local to the CE schema.
• CREATED_BY, CREATION_DATE — standard WHO audit columns recording the user and timestamp of row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the identity and session of the most recent modification.

No surrogate sequence-generated identifier is documented; the primary key is the natural business key EXTERNAL_SOURCE_TYPE. The unique index CE_FORECAST_EXT_VIEWS_U1 on the same column is redundant with the primary key and serves as an additional integrity guarantee.

Common Use Cases and Queries

The primary use case is administrative validation: confirming which external sources are registered before building or running a forecast template. The canonical query lists all configured external sources:

• SELECT external_source_type, external_source_view, db_link_name FROM ce_forecast_ext_views ORDER BY external_source_type;
• Locating remote sources: SELECT external_source_type, db_link_name FROM ce_forecast_ext_views WHERE db_link_name IS NOT NULL;
• Auditing configuration drift: querying LAST_UPDATED_BY and LAST_UPDATE_DATE to determine when a source mapping was altered.

Because EXTERNAL_SOURCE_VIEW holds a view name, DBAs commonly join this table's contents to ALL_VIEWS or DBA_OBJECTS to verify that every registered view exists and is valid in the target schema. During upgrades from 12.1.1 to 12.2.2, comparing this table between environments helps identify custom external source registrations that must be migrated.

Related Objects

The documented relationship data classifies this table as standalone, with no foreign keys to other objects. Related objects are therefore identified by functional dependency rather than referential constraint:

• CE_FORECAST_TEMPLATES / CE_FORECAST_SOURCES — forecast template and source definitions that reference external source types when a template mixes internal and external data.
• CE_FORECAST_SOURCES / CE_FORECAST_SOURCE_ITEMS — define the line items drawn from each source, including external ones.
• CE_FORECAST_WORKSHEETS / CE_FORECAST_WORKSHEET_LINES — the generated output that materializes rows retrieved from the views named here.
• CE_FORECAST_EXT_VIEWS_PK and CE_FORECAST_EXT_VIEWS_U1 — the primary key and unique index enforcing uniqueness of EXTERNAL_SOURCE_TYPE.
• User-maintained external views referenced by EXTERNAL_SOURCE_VIEW, plus any corresponding database links named in DB_LINK_NAME.

No public API is documented for this table; maintenance is performed through the Cash Management setup UI or direct DML by authorized administrators.