Search Results so_order_types_all




Overview
Explore in AI Chat

Overview

APPS.CE_FC_OEO_DISC_V is an internal Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as CE.CE_FC_OEO_DISC_V. It is classified as an internal, unsupported object: Oracle Corporation does not support direct access to its data except through standard Oracle Applications programs. As its name suggests, the view belongs to the Cash Management (CE) family of "FC" (forecast/clearing) objects and relates to order-entry discount exposure ("OEO_DISC"), presenting order-level transactional amounts alongside security profile, order type, payment terms, and operating unit context.

In EBS 12.1.1 and 12.2.2 the view functions as a reporting and integration surface. Because it joins security-profile and access-control objects, it is oriented toward filtered, user-scoped queries — a row's visibility typically depends on the operating unit and security profile of the session. This makes it suitable for exposure reporting, reconciliation of order-related discounts or amounts against receivables terms, and downstream data extraction, but not for direct transactional DML.

Underlying Base Objects

The view is defined over a set of views, synonyms, and packages rather than base tables directly:

The view references these objects but is itself referenced by no database object, confirming its role as a terminal reporting object.

Key Columns

  • REFERENCE_ID (VARCHAR2, 122) — primary identifying reference for the row.
  • ORDER_NUMBER (NUMBER) — the source order number.
  • TRX_AMOUNT (NUMBER) — the transactional amount associated with the order or line.
  • LINE_NUMBER (NUMBER) — the order line identifier.
  • STATUS (VARCHAR2, 80) — the current status of the order or transaction.
  • PROFILE_CLASS (VARCHAR2, 30) — the security/access profile classification used to scope row visibility. This column is central to the user's search for "profile_class", as it exposes the profile-based segmentation applied by the view.
  • ORDER_TYPE (VARCHAR2, 30) — the order type from SO_ORDER_TYPES_ALL.
  • TERMS (VARCHAR2, 15) — the payment terms from RA_TERMS.
  • ORGANIZATION (VARCHAR2, 240) — the operating unit / organization name from HR_OPERATING_UNITS.

Common Use Cases and Queries

Typical scenarios include exposure summaries grouped by profile class, terms, or operating unit; reconciliation of order amounts against receivables; and extracts feeding downstream reporting. Because the view honors security context, a session normally returns only rows permitted for the current user and operating unit.

Return all rows for the current session context:

  • SELECT REFERENCE_ID, ORDER_NUMBER, TRX_AMOUNT, LINE_NUMBER, STATUS, PROFILE_CLASS, ORDER_TYPE, TERMS, ORGANIZATION FROM APPS.CE_FC_OEO_DISC_V;

Aggregate exposure by profile class and organization:

  • SELECT PROFILE_CLASS, ORGANIZATION, SUM(TRX_AMOUNT) TOTAL_AMOUNT FROM APPS.CE_FC_OEO_DISC_V GROUP BY PROFILE_CLASS, ORGANIZATION ORDER BY TOTAL_AMOUNT DESC;

Filter by order type and status for a specific operating unit:

  • SELECT ORDER_NUMBER, LINE_NUMBER, TRX_AMOUNT, STATUS, TERMS FROM APPS.CE_FC_OEO_DISC_V WHERE ORDER_TYPE = :p_order_type AND STATUS = :p_status;

As an unsupported internal view, it should be used for read-only reporting and integration only, with the understanding that its definition may change without notice.