Search Results forecast_all

Overview

APPS.CE_FORECAST_ORGS_V is a Cash Management (CE) reporting view that presents a consolidated, security-filtered list of organizations for which cash forecasts may be entered, maintained, or reported. It functions as the organization validation source for forecasting in Oracle E-Business Suite Treasury and Cash Management. The view aggregates organization identifiers across multiple Oracle application products — Payables, Purchasing, Payments, Receivables, Assets, Order Entry, and Projects — into a single uniform column set, then appends a synthetic "All Organizations" row derived from the FORECAST_ALL lookup type.

Its principal role is to drive list-of-values and validation logic in forecast entry forms and concurrent reporting. Because forecasting can be performed at the operating unit, legal entity, or business group level depending on configuration, the view provides a single query point that normalizes these disparate sources. In Oracle EBS 12.1.1 and 12.2.2, it is also subject to the standard MOAC and security predicates applied by the underlying per-product views, meaning the returned rows reflect the organization access of the querying responsibility.

Underlying Base Objects

The view is a UNION ALL over seven product-specific organization views, plus one row set drawn from the lookups view. The documented components are:

• CE_FORECAST_AP_ORGS_V — Payables organizations
• CE_FORECAST_PO_ORGS_V — Purchasing organizations
• CE_FORECAST_PAY_ORGS_V — Payments organizations
• CE_FORECAST_AR_ORGS_V — Receivables organizations
• CE_FORECAST_AS_ORGS_V — Assets organizations
• CE_FORECAST_OE_ORGS_V — Order Entry organizations
• CE_FORECAST_PA_ORGS_V — Projects organizations
• CE_LOOKUPS — source of the FORECAST_ALL lookup row

The dependency chain also references the FND_PROFILE, HR_GENERAL, and HR_SECURITY packages, which are invoked inside the per-product views to enforce profile-driven defaults and HR organization security. The FORECAST_ALL branch contributes a pseudo-organization: the lookup code is cast to ORG_ID, the lookup meaning supplies the display name, and the remaining columns are returned as NULL. This allows callers to offer a wildcard "all organizations" selection where the forecast definition permits it.

Key Columns

• APP_SHORT_NAME — Application short name identifying the product whose organization set contributed the row (for example, AP, AR, PO, PAY).
• ORG_ID — Operating unit or organization identifier. For the FORECAST_ALL row, this is the numeric lookup code rather than a true organization ID.
• NAME — Organization name as presented to the user in list-of-values and reports.
• SET_OF_BOOKS_ID — Ledger (12.2.2) or set of books (12.1.1) associated with the organization; NULL for the wildcard row.
• SET_OF_BOOKS_NAME — Display name of the corresponding ledger.
• CURRENCY_CODE — Functional or ledger currency of the organization, used to filter forecasts by reporting currency.
• DESCRIPTION — Descriptive text associated with the organization entry.

Because the view is a union of homogeneous projections, all consumer queries can rely on a stable seven-column contract regardless of which product the row originates from.

Common Use Cases and Queries

The view is typically queried to populate forecast organization list-of-values, to validate a user-supplied ORG_ID, or to enumerate organizations by ledger. A representative query retrieving all organizations for a given ledger is:

• SELECT org_id, name, app_short_name, currency_code FROM apps.ce_forecast_orgs_v WHERE set_of_books_id = :ledger_id ORDER BY name;
• SELECT org_id, name FROM apps.ce_forecast_orgs_v WHERE app_short_name = 'AR' AND org_id = :org_id; — validation that an organization is available for Receivables forecasting.
• SELECT org_id, name FROM apps.ce_forecast_orgs_v WHERE set_of_books_id IS NULL; — isolates the FORECAST_ALL wildcard entry for scenarios where an all-organization forecast is permitted.
• SELECT DISTINCT set_of_books_id, set_of_books_name FROM apps.ce_forecast_orgs_v ORDER BY 2; — builds a ledger selection list for forecast reporting parameters.

Because results are constrained by the underlying security views and profile options, no additional organization security predicate is normally required in calling code. Reports and concurrent programs that join to this view should nonetheless treat the FORECAST_ALL row specially, since its ORG_ID, ledger, and currency columns are not true organization attributes.