Search Results ce_fc_oeo_disc_v




Overview
Explore in AI Chat

Overview

CE_FC_OEO_DISC_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The name convention indicates it belongs to the Forecast (FC), Order Entry/Order Management (OEO), and Discount (DISC) family of forecast views used by the Cash Management cash forecasting engine. Its role is to expose, in a single consolidated rowset, the discount-related details of Order Management order lines that participate in cash forecasting, along with the descriptive context — line flow status meaning, order type name, terms name, and operating unit name — required to display or report on those lines. The view is a query layer rather than a base table, so it does not store data; it presents data sourced from the underlying forecast order views and validated by the Cash Management security model. It is typically consumed by cash forecasting reports, custom concurrent programs, and integration extracts that need a flattened, human-readable projection of forecastable order discount amounts.

Underlying Base Objects

The view text defines a UNION ALL of two SELECT statements. The first branch selects from CE_SO_FC_ORDERS_V, joined to FND_LOOKUP_VALUES (lookup type LINE_FLOW_STATUS), SO_ORDER_TYPES_ALL (for the order type name), and HR_OPERATING_UNITS (outer-joined on ORGANIZATION_ID). The second branch selects from CE_SO_FC_ORDERS_TERMS_V, adding RA_TERMS to resolve the payment terms name. FND_LOOKUP_VALUES is restricted to the user's language via USERENV('LANG'). Access is filtered through CE_SECURITY_PROFILES_V: rows are returned only when ORG_ID is null or when an operating-unit security profile grants access. The documented ETRM object list further references FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS, reflecting the multi-org access control and profile-based security enforcement wrapped around the underlying forecast order data.

Key Columns

  • REFERENCE_ID — the source reference identifier, converted to character form via TO_CHAR.
  • ORDER_NUMBER — the Order Management order number associated with the forecast line.
  • TRX_AMOUNT (SRC.AMOUNT) — the discount or transaction amount carried for the forecast line.
  • LINE_NUMBER — the order line number.
  • STATUS — the decoded line flow status meaning from FND_LOOKUP_VALUES (LINE_FLOW_STATUS).
  • PROFILE_CLASS — the forecast profile class to which the line belongs.
  • ORDER_TYPE — the order type name resolved from SO_ORDER_TYPES_ALL.
  • TERMS — the payment terms name from RA_TERMS; NULL in the orders-only branch.
  • ORGANIZATION — the operating unit name from HR_OPERATING_UNITS; NULL when ORG_ID is not supplied.

Common Use Cases and Queries

Typical usage is to report on order line discounts included in the cash forecast, reconciling forecast amounts to Order Management and to payment terms. A representative query is:

SELECT reference_id, order_number, trx_amount, line_number, status, profile_class, order_type, terms, organization FROM apps.ce_fc_oeo_disc_v WHERE order_number = :p_order_number;

Because the view enforces the CE security profile internally, callers should initialize the multi-org context (for example via MO_GLOBAL or FND_GLOBAL) before querying so that only authorized operating units are returned. Analysts also use it to summarize forecast discounts by profile class or order type, joining the result to cash forecast report outputs to explain variances between forecasted and actual discount amounts.