Search Results oe_sales_credits

Overview

OKX_ORD_SLS_CREDITS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, registered under the OKX – Contracts Integration product. The view is documented as VALID in ETRM for releases 12.1.1 and 12.2.2 and exposes sales credit assignment data associated with order headers and order lines. Its name indicates its primary consumers: the OKX contracts integration layer and downstream order-related processes that require a read-oriented projection of sales credit information.

The view is functionally a pass-through definition: it SELECTs a defined column list from OE_SALES_CREDITS without joins, filters, or aggregation. As a result, row cardinality and uniqueness mirror the underlying base table, and the view primarily serves to provide a stable, integration-facing column contract for sales credit records. Because it includes the Open Interface/audit-oriented column WH_UPDATE_DATE, it is frequently located by developers and analysts searching for "wh_update_date" when tracing change-tracking attributes on sales credit rows.

Underlying Base Objects

The only documented referenced base object is OE_SALES_CREDITS, accessed through a SYNONYM in the APPS schema. OE_SALES_CREDITS stores sales credit allocations for order headers and lines, including the salesperson, credit percentage, and sales credit type. The view selects the following columns directly from that table: SALES_CREDIT_ID, HEADER_ID, SALESREP_ID, PERCENT, LINE_ID, CONTEXT, ATTRIBUTE1 through ATTRIBUTE15, DW_UPDATE_ADVICE_FLAG, WH_UPDATE_DATE, ORIG_SYS_CREDIT_REF, SALES_CREDIT_TYPE_ID, and LOCK_CONTROL.

No join conditions, WHERE clauses, or derived expressions are documented in the view text. Consequently, the view inherits all DML, concurrency, and locking characteristics of OE_SALES_CREDITS; it is not a materialized construct and provides no performance isolation from the base table.

Key Columns

• SALES_CREDIT_ID – Primary key of the sales credit record in OE_SALES_CREDITS.
• HEADER_ID – Foreign key to the order header (OE_ORDER_HEADERS_ALL), identifying the order to which the credit belongs.
• LINE_ID – Foreign key to the order line (OE_ORDER_LINES_ALL), where the credit is line-level rather than header-level.
• SALESREP_ID – Identifier of the salesperson receiving the credit.
• PERCENT – The percentage of credit allocated to the salesperson.
• SALES_CREDIT_TYPE_ID – Reference to the sales credit type, distinguishing quota, non-quota, and other credit categories.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 – Descriptive flexfield context and attribute columns, carrying client-specific extensions.
• DW_UPDATE_ADVICE_FLAG – Flag indicating whether an update advice should be published for the data warehouse or downstream integration.
• WH_UPDATE_DATE – The warehouse update timestamp used for change detection and incremental extraction by integration and reporting processes.
• ORIG_SYS_CREDIT_REF – Original system reference for the credit, supporting multi-source and legacy data reconciliation.
• LOCK_CONTROL – Lock control column used by the integration/interface layer to manage record-level concurrency.

Common Use Cases and Queries

Typical usage includes incremental extraction for data warehousing, reconciliation of sales credit allocation, and diagnostics of order credit records by order, line, or salesperson. Because the view exposes WH_UPDATE_DATE and DW_UPDATE_ADVICE_FLAG directly, it is well suited for delta-based integration queries.

Retrieve credits for a specific order header:

SELECT sales_credit_id, header_id, line_id, salesrep_id,
       percent, sales_credit_type_id
FROM   apps.okx_ord_sls_credits_v
WHERE  header_id = :p_header_id;

Extract rows changed since a prior high-water mark:

SELECT sales_credit_id, header_id, salesrep_id, percent,
       wh_update_date, dw_update_advice_flag
FROM   apps.okx_ord_sls_credits_v
WHERE  wh_update_date >= :p_last_run_date;

Identify credits pending update advice:

SELECT sales_credit_id, orig_sys_credit_ref, lock_control
FROM   apps.okx_ord_sls_credits_v
WHERE  dw_update_advice_flag = 'Y';

Queries should be restricted by indexed columns such as HEADER_ID, LINE_ID, or SALESREP_ID where possible, since the view performs no filtering of its own over OE_SALES_CREDITS.