Search Results oe_ak_header_scredits_v




Overview
Explore in AI Chat

Overview

The view APPS.OE_AK_HEADER_SCREDITS_V is a reporting and integration interface within the Oracle E-Business Suite ONT – Order Management product. It is registered in the ETRM metadata with Status: VALID and is owned by the APPS schema. The view exposes sales credit assignment data associated with order headers and lines, and it is defined entirely over the OE_SALES_CREDITS synonym. Its principal design characteristic is the deliberate renaming and mapping of Oracle Applications descriptive flexfield (DFA/DFF) segments into the generic ATTRIBUTE1 through ATTRIBUTE15 and CONTEXT columns, together with three synthetic columns generated by RPAD expressions.

The view is exposed under the OA Framework / AK (Oracle Application Framework) naming convention, which signals that it is consumed by Oracle's internal AJAX-enabled UI layers as well as by external reporting and integration routines. It is one of the objects commonly reached through the Order Management sales credit inquiry and adjustment interfaces. When a user searches for the dw_update_advice_flag identifier, this view is a primary candidate because that column is projected directly from the underlying base table without transformation.

Underlying Base Objects

Per the documented ETRM metadata for release 12.2.2, the single referenced base object is:

  • OE_SALES_CREDITS (SYNONYM) — the order management sales credit assignment table, which stores the salesperson, credit type, and percentage allocation applied to an order header or line.

The view is a straight projection: every column in the SELECT list originates from that one synonym, including the descriptive flexfield segment columns. The three trailing columns are computed with literal RPAD expressions — RPAD('X', 1, '-'), RPAD('T', 1, '-'), and RPAD('X', 30, '-') — and are aliased in the documented column list as RETURN_STATUS, DB_FLAG, and OPERATION. These are synthetic, constant-valued columns used by the consuming framework (or by concurrent/DW extract programs) as status markers rather than as stored business data.

Key Columns

  • HEADER_ID — Foreign key to the order header, identifying the order to which the sales credit belongs.
  • LINE_ID — Optional identifier for the order line when the credit is line-level rather than header-level.
  • SALES_CREDIT_ID — Primary identifier for the sales credit record.
  • SALES_CREDIT_TYPE_ID — Reference to the sales credit type (for example, quota or non-quota credit).
  • SALESREP_ID — The salesperson identifier; in the view it is projected as TO_NUMBER(TO_CHAR(SALESREP_ID)), a normalization expression that enforces numeric conversion.
  • PERCENT — The percentage of the order value credited to the salesperson.
  • DW_UPDATE_ADVICE_FLAG — The data-warehouse update advice flag carried across from OE_SALES_CREDITS. This flag signals whether a downstream data warehouse or change-data-capture process has been advised of a change to the credit record.
  • WH_UPDATE_DATE — Timestamp indicating when the record was last propagated to the warehouse.
  • CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield context and segment columns.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle audit (WHO) columns.
  • RETURN_STATUS, DB_FLAG, OPERATION — Synthetic constant columns generated by the RPAD expressions described above.

Common Use Cases and Queries

The view is typically used for sales credit reporting, data warehouse extraction, and change detection. A representative query to audit warehouse propagation status is:

  • SELECT HEADER_ID, LINE_ID, SALES_CREDIT_ID, SALESREP_ID, PERCENT, DW_UPDATE_ADVICE_FLAG, WH_UPDATE_DATE FROM OE_AK_HEADER_SCREDITS_V WHERE DW_UPDATE_ADVICE_FLAG = 'Y';
  • SELECT HEADER_ID, SUM(PERCENT) FROM OE_AK_HEADER_SCREDITS_V GROUP BY HEADER_ID HAVING SUM(PERCENT) <> 100; — to validate that header-level credit allocations sum to 100 percent.
  • SELECT SALESREP_ID, COUNT(*), SUM(PERCENT) FROM OE_AK_HEADER_SCREDITS_V WHERE TRUNC(LAST_UPDATE_DATE) >= TRUNC(SYSDATE) - 7 GROUP BY SALESREP_ID; — for a weekly sales credit activity report.

Because the view filters nothing and joins nothing, query predicates should be pushed down to the underlying OE_SALES_CREDITS synonym, and callers should index or restrict on HEADER_ID where possible to avoid full scans.