Search Results ce_forecast_po_orgs_v




Overview
Explore in AI Chat

Overview

The view CE_FORECAST_PO_ORGS_V is an Oracle E-Business Suite database object owned by the APPS schema and classified under the Cash Management (CE) product family. It is documented in Oracle's ETRM repository as a VIEW with a VALID status in both Oracle EBS 12.1.1 and 12.2.2, and its description is recorded simply as "Retrofitted," indicating that the object was carried forward from an earlier Oracle release (typically 11i) into the R12 architecture. In R12, the concept of the operating unit replaced the earlier organization-based model, and views such as this one were re-pointed to the R12 multi-org architecture to preserve backward compatibility for dependent Cash Management forecasting logic.

Functionally, the view assembles a consolidated list of "PO" (Payables) source organizations and their associated ledger context. It joins Financials System Parameters with HR operating units and GL sets of books to produce one row per org/ledger combination, plus a fallback row where the operating unit is null. This makes the view a supporting data source for cash forecasting and reconciliation reporting in Cash Management, where forecast lines must be attributed to a source organization and a ledger.

Underlying Base Objects

The documented base objects referenced by the view are:

The view text is a UNION ALL of two SELECT statements. The first joins all three objects to return ORG_ID, NAME, SET_OF_BOOKS_ID, ledger NAME, CURRENCY_CODE, DESCRIPTION, and a NULL LEGAL_ENTITY_ID (the original HR operating unit legal entity reference is commented out). The second returns the same columns but with NAME and LEGAL_ENTITY_ID set to NULL, restricted to rows where SET_OF_BOOKS_ID matches and ORG_ID is null — i.e., a ledger-only context absent a specific operating unit.

Key Columns

  • APP_SHORT_NAME — the literal application tag, returned as 'PO', denoting Payables as the source application.
  • ORG_ID — the operating unit identifier from Financials System Parameters.
  • NAME — the operating unit name from HR_OPERATING_UNITS (NULL in the fallback branch).
  • SET_OF_BOOKS_ID — the ledger (set of books) identifier.
  • SET_OF_BOOKS_NAME — the ledger name from GL_SETS_OF_BOOKS.
  • CURRENCY_CODE — the ledger currency.
  • DESCRIPTION — the ledger description.
  • LEGAL_ENTITY_ID — a placeholder returning TO_NUMBER(NULL), reserved for legal entity association.

Common Use Cases and Queries

The view is typically used to enumerate the Payables organizations/ledgers available to Cash Management forecasting, or to resolve an ORG_ID to its ledger and currency context. A representative query is:

SELECT org_id, name, set_of_books_id,
       set_of_books_name, currency_code, description
FROM   apps.ce_forecast_po_orgs_v
WHERE  currency_code = 'USD'
ORDER  BY set_of_books_name, name;

Another frequent pattern filters to rows with a valid operating unit:

SELECT org_id, name, set_of_books_id
FROM   apps.ce_forecast_po_orgs_v
WHERE  name IS NOT NULL;

Because the view exposes ledger and operating unit context for the Payables source, it is useful when building or troubleshooting forecast sources that must join CE forecast data back to a specific organization and ledger combination.