Search Results ce_forecast_orgs_v




Overview
Explore in AI Chat

Overview

CE_FORECAST_ORGS_V is a consolidated reporting view owned by the APPS schema in Oracle E-Business Suite Cash Management (CE). Its purpose is to present the set of organizations that are valid for cash forecasting, one row per organization per source application, in a single uniform result set. Rather than requiring callers to query each application-specific forecast organization view separately, CE_FORECAST_ORGS_V unions the forecast organization views of Accounts Payable, Accounts Receivable, Assets, Order Entry, Payables, Projects, and Purchasing, and appends a synthetic row derived from the FORECAST_ALL lookup type.

The view is documented in ETRM as VALID and is described as "Retrofitted," indicating it was re-pointed or regenerated during an upgrade or patch cycle rather than authored fresh. It exposes only seven columns, giving it a narrow, stable contract suitable for LOV definitions, concurrent program parameters, and analytical queries that need to know which organizations can participate in a forecast. It is not a transactional object; it carries no amounts, dates, or forecast balances.

Underlying Base Objects

The view is defined as a chain of UNION ALL branches. Seven branches select from application-specific forecast organization views: CE_FORECAST_AP_ORGS_V, CE_FORECAST_PO_ORGS_V, CE_FORECAST_PAY_ORGS_V, CE_FORECAST_AR_ORGS_V, CE_FORECAST_AS_ORGS_V, CE_FORECAST_OE_ORGS_V, and CE_FORECAST_PA_ORGS_V. Each contributes the same seven-column projection.

An eighth branch reads CE_LOOKUPS, filtering LOOKUP_TYPE = 'FORECAST_ALL' and mapping LOOKUP_CODE through TO_NUMBER to produce an ORG_ID-like value, and MEANING to populate NAME. This branch deliberately returns NULL for APP_SHORT_NAME, SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME, CURRENCY_CODE, and DESCRIPTION, so the "all" option carries no application or ledger context.

Documented referenced objects also include the packages FND_PROFILE, HR_GENERAL, and HR_SECURITY. These are used indirectly by the underlying views to enforce operating unit and security profile restrictions, so the effective row set returned to a session respects the caller's MO security profile.

Key Columns

  • APP_SHORT_NAME — Application short name of the source module (for example SQLAP, AR, PO). NULL for the FORECAST_ALL lookup row.
  • ORG_ID — Operating unit / organization identifier. For the lookup branch this is the numeric LOOKUP_CODE converted with TO_NUMBER.
  • NAME — Organization name; for the lookup branch it holds the lookup MEANING.
  • SET_OF_BOOKS_ID — Ledger identifier associated with the organization. NULL for the lookup branch.
  • SET_OF_BOOKS_NAME — Ledger name associated with the organization. NULL for the lookup branch.
  • CURRENCY_CODE — Ledger currency for the organization. NULL for the lookup branch.
  • DESCRIPTION — Descriptive text for the organization. NULL for the lookup branch.

Common Use Cases and Queries

Typical uses include feeding organization LOVs in cash forecast setup and inquiry, validating a supplied ORG_ID before running forecast generation, and driving per-organization loops in custom forecast extracts. Because the view spans applications, it is convenient for reconciliation of which modules contribute organizations to forecasting.

  • List all forecast-enabled organizations for a ledger:
    SELECT org_id, name, app_short_name FROM ce_forecast_orgs_v WHERE set_of_books_id = :ledger_id ORDER BY name;
  • Retrieve the "all organizations" option:
    SELECT org_id, name FROM ce_forecast_orgs_v WHERE app_short_name IS NULL;
  • Check whether an organization is available for forecasting:
    SELECT COUNT(*) FROM ce_forecast_orgs_v WHERE org_id = :org_id;
  • Distinct contributing applications:
    SELECT DISTINCT app_short_name FROM ce_forecast_orgs_v;

Because HR security packages are involved, results are session-sensitive; the same query executed under different responsibilities may return different organization counts. When a query returns fewer rows than expected, verifying the MO security profile is the standard first diagnostic step.