Search Results ce_forecast_pa_orgs_v




Overview
Explore in AI Chat

Overview

CE_FORECAST_PA_ORGS_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified in ETRM as VALID and is documented as "Retrofitted," indicating that the object was carried forward and re-validated against the current data model rather than being authored anew for the release. The view supplies the set of Projects (PA) operating unit and set-of-books combinations that the Cash Management forecasting engine can consume when building cash forecasts that incorporate project-related activity. In effect, it acts as an organization and ledger lookup that presents PA implementations in a uniform format aligned with the forecasting framework's expectations.

Its role is primarily that of a reporting and integration helper: internal CE forecasting logic and related inquiry pages use the view to resolve valid organization identifiers, names, and ledger attributes for the Projects application without requiring the caller to join the underlying HR and GL objects directly.

Underlying Base Objects

The view is defined over three documented referenced objects:

The view text is a UNION ALL of two branches. The first branch joins PA_IMPLEMENTATIONS_ALL to HR_OPERATING_UNITS and GL_SETS_OF_BOOKS for rows where ORG_ID is not null, returning the operating unit name in the NAME column. The second branch handles rows where PA.ORG_ID IS NULL, returning NULL for the name while still resolving set-of-books attributes. Both branches emit the literal 'PA' as APP_SHORT_NAME and supply a NULL LEGAL_ENTITY_ID, as the legal entity reference in the underlying select is commented out and replaced by TO_NUMBER(NULL).

Key Columns

  • APP_SHORT_NAME — literal 'PA', identifying the source application as Projects.
  • ORG_ID — the operating unit identifier from PA_IMPLEMENTATIONS_ALL; may be null in the second UNION branch.
  • NAME — the operating unit name from HR_OPERATING_UNITS, or NULL when ORG_ID is null.
  • SET_OF_BOOKS_ID — the ledger identifier associated with the PA implementation.
  • SET_OF_BOOKS_NAME — ledger name from GL_SETS_OF_BOOKS.
  • CURRENCY_CODE — the ledger currency, used by forecasting to determine functional currency amounts.
  • DESCRIPTION — ledger description.
  • LEGAL_ENTITY_ID — always NULL, retained for structural compatibility with the forecasting organization framework.

Common Use Cases and Queries

Typical scenarios include validating which Projects organizations are available to cash forecasting, populating organization list-of-values on forecasting setup pages, and joining forecast results to ledger currency information.

Example: list all valid PA organizations with ledger details.

  • SELECT org_id, name, set_of_books_id, set_of_books_name, currency_code FROM apps.ce_forecast_pa_orgs_v WHERE org_id IS NOT NULL ORDER BY name;

Example: resolve the ledger currency for a specific organization.

  • SELECT name, set_of_books_name, currency_code FROM apps.ce_forecast_pa_orgs_v WHERE org_id = :p_org_id;

Because the LEGAL_ENTITY_ID column is always null, reports requiring legal entity attribution must source that value separately from HR_OPERATING_UNITS or the legal entity configuration tables.