Search Results ce_forecast_ap_orgs_v




Overview
Explore in AI Chat

Overview

CE_FORECAST_AP_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 documented in the E-Business Suite Technical Reference Manual (ETRM) as a retrofitted object, meaning it was re-engineered to preserve compatibility across release levels while aligning with newer architecture. The view exposes the set of Payables operating units and their associated general ledger set of books, formatted specifically for consumption by Cash Management forecasting functionality.

Its principal role is to provide the Cash Management forecast engine with a normalized list of "AP" source organizations — the operating units whose unpaid invoices and scheduled payments feed cash outflow projections. Rather than querying Payables system parameters directly, the forecast process selects from this view to obtain organization, ledger, and currency context in a single result set. This abstraction isolates the forecasting logic from the underlying table structure, allowing Oracle to change base tables without breaking the forecast pipeline.

Underlying Base Objects

The view is defined as a UNION ALL of two branches over three referenced objects: AP_SYSTEM_PARAMETERS_ALL (a synonym resolving to the Payables system parameters table), GL_SETS_OF_BOOKS (a view over the accounting flexfield ledger definitions), and HR_OPERATING_UNITS (a view over organization definitions).

  • Branch 1 joins AP_SYSTEM_PARAMETERS_ALL to HR_OPERATING_UNITS on ORG_ID = ORGANIZATION_ID, and to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID. It returns operating units that are properly defined in both Payables and HR, populating the NAME column from HR_OPERATING_UNITS. In this branch, the LEGAL_ENTITY_ID column is explicitly nulled via TO_NUMBER(NULL), indicating the legal entity linkage was disabled during retrofit.
  • Branch 2 returns rows where AP.ORG_ID is null, joining only to GL_SETS_OF_BOOKS. Here NAME is returned as NULL and LEGAL_ENTITY_ID is also NULL. This branch captures legacy or global Payables configurations where no operating unit is assigned.

The constant literal 'AP' is used as APP_SHORT_NAME in both branches, identifying the record's application source for downstream filtering.

Key Columns

  • APP_SHORT_NAME — Always 'AP', flagging the row as originating from Payables.
  • ORG_ID — The operating unit identifier from AP_SYSTEM_PARAMETERS_ALL; may be NULL in the second UNION branch.
  • NAME — The operating unit name from HR_OPERATING_UNITS; NULL when ORG_ID is NULL.
  • SET_OF_BOOKS_ID — The ledger identifier, linking the organization to its accounting book.
  • SET_OF_BOOKS_NAME — The ledger name from GL_SETS_OF_BOOKS.
  • CURRENCY_CODE — The ledger currency, essential for converting forecast amounts.
  • DESCRIPTION — The ledger description from GL_SETS_OF_BOOKS.
  • LEGAL_ENTITY_ID — Documented but always NULL in the current view text, retained for signature compatibility.

Common Use Cases and Queries

This view is typically consulted when diagnosing Cash Management forecast results, validating which Payables organizations are included in a forecast run, or building custom cash-position reports that must align with the standard AP forecast scope.

To list all Payables organizations eligible for forecasting with their ledger and currency:

  • SELECT org_id, name, set_of_books_id, set_of_books_name, currency_code FROM ce_forecast_ap_orgs_v ORDER BY name;

To identify rows representing global configurations lacking an operating unit:

  • SELECT * FROM ce_forecast_ap_orgs_v WHERE org_id IS NULL;

To join the view to forecast results and enrich them with organization and ledger names:

  • SELECT v.name, v.currency_code, f.amount FROM ce_forecast_ap_orgs_v v, ce_forecast_results f WHERE v.org_id = f.org_id;

Because the view is read-only and defined over configuration tables, it should not be modified. Any need to filter or extend its output should be handled in the consuming query, not by altering the view definition.