Search Results ce_forecast_as_orgs_v




Overview
Explore in AI Chat

Overview

CE_FORECAST_AS_ORGS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, belonging to the Cash Management (CE) product family. It is defined to expose the intersection of an Accounts Receivable system parameter setup (the "AS", or Accounts Receivable, source) with the operating unit and general ledger set of books it is configured against. According to the ETRM metadata, the object carries the description "Retrofitted", indicating it was introduced or re-pointed as part of an upgrade or retrofit effort rather than as a foundational transactional object. The view presents one row per Accounts Receivable system-parameter configuration, joining the AR organization identifier to its HR operating unit name and to the GL set of books name, currency, and description. Because of the spelling of the underlying object name, the view is written over AR_SYSTEM_PARAMETERS_ALL rather than the AP system parameters; the "AS" literal in the first select column functions as a source-type tag so downstream forecast or integration logic can distinguish this source from others. The view is a synonym-based reporting helper rather than a table that stores data.

Underlying Base Objects

The view text references three objects:

  • AR_SYSTEM_PARAMETERS_ALL (documented as a synonym) — supplies ORG_ID and SET_OF_BOOKS_ID, the Accounts Receivable system-level configuration key values.
  • HR_OPERATING_UNITS (documented as a view) — supplies NAME, the operating unit name, joined on ORGANIZATION_ID. The join is outer, as shown by the (+) operator.
  • GL_SETS_OF_BOOKS (documented as a view) — supplies NAME, CURRENCY_CODE, and DESCRIPTION, joined on SET_OF_BOOKS_ID.

The relationship is one row of AR system parameters to at most one operating unit name and one set of books. The use of an outer join on HR_OPERATING_UNITS means a row is returned even when no operating unit name can be resolved. LEGAL_ENTITY_ID is deliberately projected as TO_NUMBER(NULL), so the column exists structurally but carries no value; the original HR operating unit legal entity reference is commented out in the view text. This behavior is consistent with the "retrofitted" status and is significant for any code that expects a populated legal entity.

Key Columns

  • APP_SHORT_NAME — literal 'AS', identifying the row as originating from the AR system parameters source.
  • ORG_ID — the operating unit organization identifier from AR system parameters; the primary join and security key.
  • NAME — the HR operating unit name associated with that ORG_ID.
  • SET_OF_BOOKS_ID — the General Ledger set of books identifier.
  • SET_OF_BOOKS_NAME / CURRENCY_CODE / DESCRIPTION — the set of books display name, functional currency, and description.
  • LEGAL_ENTITY_ID — present for structural consistency but always NULL, since the implementation expresses it as TO_NUMBER(NULL).

Common Use Cases and Queries

Practically, CE_FORECAST_AS_ORGS_V supports cash forecasting and multi-organization reporting where the forecast source must be mapped to an operating unit and set of books. A typical query lists configured sources for an organization or set of books:

  • SELECT org_id, name, set_of_books_name, currency_code FROM ce_forecast_as_orgs_v ORDER BY name;
  • SELECT org_id, name, set_of_books_name, currency_code FROM ce_forecast_as_orgs_v WHERE set_of_books_id = :p_sob_id;
  • SELECT org_id, name, set_of_books_name, currency_code FROM ce_forecast_as_orgs_v WHERE org_id = :p_org_id;

Because the view returns one row per AR system parameter record, it is frequently joined to forecast or lookup data by ORG_ID to enrich reporting output with the operating unit and set of books names. Queries should not rely on LEGAL_ENTITY_ID returning a value; use HR operating unit or legal entity sources directly if a legal entity is required. Since the joins are outer where noted, callers should tolerate a NULL NAME when an operating unit mapping is unavailable. As with any data-extraction query against EBS views, filter by ORG_ID to respect operating unit security.