Search Results ce_forecast_ar_orgs_v




Overview
Explore in AI Chat

Overview

CE_FORECAST_AR_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 ETRM repository with the description "Retrofitted," indicating that the object was recreated or migrated during an upgrade cycle to preserve pre-existing behavior or interface contracts.

The view exposes the set of Oracle Receivables operating units that participate in cash forecasting and cash positioning. Each row pairs a Receivables organization (ORG_ID) with the general ledger set of books (SET_OF_BOOKS_ID) under which that organization operates, and surfaces the corresponding ledger name, currency, and description. Because cash forecasting in CE must aggregate expected receipts across multiple operating units, this view provides the standard list of AR organizations that the forecasting engine enumerates when building forecast templates and when associating forecast data with a ledger.

Functionally, the view acts as a bridging layer between the Receivables system parameters, the HR operating unit definition, and the General Ledger ledger definition, presenting a denormalized organization/ledger combination that CE concurrent programs and UI regions can consume without embedding the join logic themselves.

Underlying Base Objects

The view is defined as a UNION ALL of two queries over three referenced base objects:

The first branch joins all three objects and returns a populated NAME and an ORG_ID. The second branch handles the case where AR_SYSTEM_PARAMETERS_ALL has a row with a valid SET_OF_BOOKS_ID but a null ORG_ID; in this branch the NAME column is returned as NULL and the join to HR_OPERATING_UNITS is dropped. Both branches hard-code the literal 'AR' as APP_SHORT_NAME, and both return TO_NUMBER(NULL) for LEGAL_ENTITY_ID — the original legal entity derivation from HRO.LEGAL_ENTITY_ID is commented out in the view text, so the column is effectively always null.

Key Columns

  • APP_SHORT_NAME — literal application identifier, always 'AR'.
  • ORG_ID — Receivables operating unit identifier; NULL for ledger-only rows.
  • NAME — operating unit name from HR_OPERATING_UNITS; NULL when ORG_ID is NULL.
  • SET_OF_BOOKS_ID — ledger identifier from AR_SYSTEM_PARAMETERS_ALL.
  • SET_OF_BOOKS_NAME — ledger name from GL_SETS_OF_BOOKS.
  • CURRENCY_CODE — ledger currency, used to align forecast amounts with the correct monetary unit.
  • DESCRIPTION — ledger description text.
  • LEGAL_ENTITY_ID — reserved column, currently returns NULL in both branches.

Common Use Cases and Queries

Typical uses include LOV population for the operating unit or ledger prompt in cash forecast setup, validation of AR-to-ledger mappings before running forecast generation, and diagnostic queries to detect organizations missing a ledger assignment. A representative query follows:

  • List all AR organizations and their ledgers:
    SELECT app_short_name, org_id, name, set_of_books_name, currency_code FROM apps.ce_forecast_ar_orgs_v ORDER BY set_of_books_name, name;
  • Isolate ledger-only rows (no operating unit):
    SELECT set_of_books_id, set_of_books_name, currency_code FROM apps.ce_forecast_ar_orgs_v WHERE org_id IS NULL;
  • Find operating units sharing a single ledger:
    SELECT set_of_books_name, COUNT(*) FROM apps.ce_forecast_ar_orgs_v WHERE org_id IS NOT NULL GROUP BY set_of_books_name;

Because the view performs UNION ALL and outer-join semantics loosely, consumers should filter on ORG_ID when only fully qualified operating units are required.