Search Results ce_forecast_oe_orgs_v




Overview
Explore in AI Chat

Overview

CE_FORECAST_OE_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 a retrofitted view, meaning it was adapted to support the multi-organization architecture introduced in Release 12 while preserving compatibility with pre-existing Cash Management forecasting logic. Its purpose is to present the set of Order Entry (OE) operating units and their associated ledgers and currencies in a form consumed by the Cash Management cash forecasting engine, allowing forecasts to be built at the correct operating unit and set of books level.

The view returns a normalized list of organization and ledger combinations rather than transactional data. Each row identifies an operating unit (or a ledger directly) along with its set of books, functional currency, and description. This makes the view a configuration lookup used to seed or filter forecast query logic, not a transactional reporting source.

The literal value 'OE' is emitted as APP_SHORT_NAME for every row, indicating that the row belongs to the Order Entry application context. This constant is significant because Cash Management forecasting processes may combine sources from multiple modules (for example, Order Entry, Receivables, and Payables), and the APP_SHORT_NAME column allows the calling process to distinguish the OE-sourced rows.

Underlying Base Objects

According to the documented metadata, CE_FORECAST_OE_ORGS_V is defined over four referenced base objects:

The view is defined as a UNION ALL of two branches. The first branch joins HR_OPERATING_UNITS to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID and filters for the operating unit returned by FND_PROFILE.VALUE('ORG_ID'). The second branch is taken only when FND_PROFILE.VALUE('ORG_ID') IS NULL; it retrieves the ledger from FND_PROFILE_OPTION_VALUES where APPLICATION_ID = 300 and PROFILE_OPTION_ID = 1148, then joins to GL_SETS_OF_BOOKS. This structure ensures that a single, predictable set of ledger/organization rows is returned whether or not an operating unit is currently selected in the session.

Key Columns

  • APP_SHORT_NAME — constant 'OE', identifying the Order Entry context.
  • ORG_ID — the operating unit organization identifier; NULL in the profile-option fallback branch.
  • NAME — the operating unit name; NULL in the fallback branch.
  • SET_OF_BOOKS_ID — the ledger identifier, sourced from HRO.SET_OF_BOOKS_ID or from the profile option value.
  • SET_OF_BOOKS_NAME — the ledger name from GL_SETS_OF_BOOKS.
  • CURRENCY_CODE — the ledger functional currency.
  • DESCRIPTION — the ledger description.
  • LEGAL_ENTITY_ID — present in the column list, but the view text selects TO_NUMBER(NULL) with the original HRO.LEGAL_ENTITY_ID expression retained only as a comment. The column is therefore always NULL in this implementation.

Common Use Cases and Queries

This view is typically queried by Cash Management forecasting programs and by diagnostics that need to confirm which operating unit and ledger will be used for an OE forecast. A representative query retrieves the active organization and ledger context:

  • SELECT app_short_name, org_id, name, set_of_books_id, set_of_books_name, currency_code FROM ce_forecast_oe_orgs_v;
  • Filtering to the OE source when combining with other forecast-source views: SELECT * FROM ce_forecast_oe_orgs_v WHERE app_short_name = 'OE';
  • Verifying ledger currency for a given context: SELECT set_of_books_name, currency_code FROM ce_forecast_oe_orgs_v WHERE set_of_books_id = :p_sob_id;

Because ORG_ID and NAME are populated only when an operating unit is set, and the fallback branch returns a single ledger row, the row count of the view is context-driven. Administrators troubleshooting forecasting scope should confirm that FND_PROFILE.VALUE('ORG_ID') returns the intended operating unit; otherwise the fallback ledger defined by profile option 1148 will govern.