Search Results preferred_grade




Overview
Explore in AI Chat

Overview

APPS.OE_AK_PREFERRED_GRADES_V is a lightweight Oracle EBS database view owned by the APPS schema and registered under the FND design data application short name ONT (Order Management). Its status is documented as VALID in ETRM 12.1.1 / 12.2.2. The view exposes a single column, PREFERRED_GRADE, of datatype VARCHAR2, and its internal view type is classified as "Internal." The Oracle documentation explicitly carries the warning that the object is for Oracle Internal Use Only and that Oracle Corporation does not support access to applications data through it except from standard Oracle Applications programs.

Functionally, the view belongs to the family of "AK" objects associated with the Oracle Application Framework/Attribute framework naming convention (AK). It is used within Order Management and related Oracle EBS flows to surface preferred grade values, such as grading attributes attached to customers, orders, or items, for use by seeded application logic rather than by external integrations.

Underlying Base Objects

According to the documented ETRM metadata for release 12.2.2, OE_AK_PREFERRED_GRADES_V references only the PUBLIC synonym DUAL. DUAL is the standard Oracle one-row, one-column pseudo-table used to fabricate single-row results (for example, constants, sequence selections, or sysdate expressions).

Because the only documented base object is DUAL, the view is not defined over OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, or any order-related transactional table. It is therefore a static or self-contained view whose result set is generated without dependency on order data. The dependency listing further states that OE_AK_PREFERRED_GRADES_V is not referenced by any other database object, meaning it is a leaf in the dependency tree and no other view, synonym, or PL/SQL unit within the APPS schema depends on it.

Key Columns

  • PREFERRED_GRADE (VARCHAR2): The sole documented column. It exposes a preferred grade value in character format. Because the view is built over DUAL, the column is typically returned as a literal or derived single value rather than as a query over master data such as grades, customers, or items.

Common Use Cases and Queries

The practical calling pattern is a simple SELECT against the APPS schema:

  • SELECT PREFERRED_GRADE FROM APPS.OE_AK_PREFERRED_GRADES_V;

Because the view references DUAL only, this query returns at most one row and is effectively constant. Typical scenarios include:

  • Seeded Oracle Applications code (Order Management / attribute framework) referencing the view to obtain a fixed preferred grade indicator.
  • Validation during EBS upgrades (12.1.1 to 12.2.2) to confirm the view compiles and remains VALID.
  • Diagnostic checks when tracing "preferred_grade" references in EBS metadata, verifying that no custom object has been built on top of it.

Custom integrations should not depend on this object. Oracle's documented warning restricts supported access to standard Oracle Applications programs, and since the view resolves only to DUAL and is referenced by no other database object, it is not a supported integration interface.