Search Results oe_sales_credits_pk

Overview

OE_SALES_CREDITS is a transactional table in the Oracle Order Management (ONT) product, owned by the ONT schema. It stores information about sales credits associated with order headers and order lines. Sales credits represent the allocation of revenue or quota credit to one or more sales representatives (salesreps) for a given order, and this table captures the percentage split awarded to each participating salesrep. The table is classified as VALID in the ETRM metadata and is part of the core order capture and order management data model in Oracle E-Business Suite releases 12.1.1 and 12.2.2.

From a heuristic Data Vault modeling perspective, OE_SALES_CREDITS is best classified as a link table. It resolves a many-to-many relationship between order lines (or headers) and salesreps, and it can carry descriptive attributes such as the credit percentage. The foreign keys to OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and RA_SALESREPS_ALL indicate that the table functions as an associative entity connecting orders to their credited salesreps.

Key Information Stored

The table contains 34 documented columns. The most significant include:

• SALES_CREDIT_ID — The surrogate primary key, uniquely generated for each sales credit record and enforced by the OE_SALES_CREDITS_PK constraint and the OE_SALES_CREDITS_U1 unique index.
• HEADER_ID — Foreign key to OE_ORDER_HEADERS_ALL, identifying the order header to which the credit belongs.
• LINE_ID — Foreign key to OE_ORDER_LINES_ALL, identifying the specific order line associated with the credit.
• SALESREP_ID — Foreign key to RA_SALESREPS_ALL, identifying the sales representative receiving the credit.
• SALES_CREDIT_TYPE_ID — Foreign key to SO_SALES_CREDIT_TYPES_115, identifying the type or category of the sales credit.
• PERCENT — The percentage of credit allocated to the salesrep for the associated line or header.
• SALES_GROUP_ID — Identifier for the sales group associated with the credit.
• SALES_GROUP_UPDATED_FLAG — Indicator reflecting whether the sales group has been updated.
• ORIG_SYS_CREDIT_REF — The originating system reference for the credit, supporting integration and data lineage.
• DW_UPDATE_ADVICE_FLAG and WH_UPDATE_DATE — Warehouse-related flag and timestamp supporting data warehouse refresh processing.
• LOCK_CONTROL — Concurrency control column used to manage record locking during updates.
• INST_ID — Installation identifier supporting multi-organization or multi-instance deployments.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) columns enabling customer-specific extensibility.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns tracking record creation and modification.

The surrogate primary key, SALES_CREDIT_ID, is distinct from any business key; the unique index OE_SALES_CREDITS_U1 is defined on this same column, confirming its role as the system-generated identifier.

Common Use Cases and Queries

OE_SALES_CREDITS is commonly queried for sales compensation analysis, quota allocation reporting, and order-level credit visibility. A typical query joining the table to order headers and salesreps retrieves the credit percentage awarded per salesrep for a given order:

• Sales credit allocation reports: join OE_SALES_CREDITS to OE_ORDER_HEADERS_ALL on HEADER_ID and to RA_SALESREPS_ALL on SALESREP_ID to list all credited salesreps and percentages for an order.
• Line-level credit analysis: join to OE_ORDER_LINES_ALL on LINE_ID to determine credit distribution at the line level.
• Credit type segmentation: join SALES_CREDIT_TYPE_ID to SO_SALES_CREDIT_TYPES_115 to categorize credits by type.
• Data warehouse extraction: filter on DW_UPDATE_ADVICE_FLAG or WH_UPDATE_DATE to identify records pending warehouse refresh.
• Integration reconciliation: use ORIG_SYS_CREDIT_REF to trace credits back to the originating source system.

Sample SQL pattern: SELECT sc.SALES_CREDIT_ID, sc.HEADER_ID, sc.LINE_ID, sc.SALESREP_ID, sc.PERCENT FROM OE_SALES_CREDITS sc WHERE sc.HEADER_ID = :p_header_id.

Related Objects

The following objects are most significant in relation to OE_SALES_CREDITS, based on documented foreign key relationships:

• OE_ORDER_HEADERS_ALL — Referenced via OE_SALES_CREDITS.HEADER_ID; the parent order header record.
• OE_ORDER_LINES_ALL — Referenced via OE_SALES_CREDITS.LINE_ID; the parent order line record.
• RA_SALESREPS_ALL — Referenced via OE_SALES_CREDITS.SALESREP_ID; the sales representative dimension.
• SO_SALES_CREDIT_TYPES_115 — Referenced via OE_SALES_CREDITS.SALES_CREDIT_TYPE_ID; defines the credit type.
• OE_SALES_CREDITS_PK — Primary key constraint on SALES_CREDIT_ID.
• OE_SALES_CREDITS_U1 — Unique index on SALES_CREDIT_ID.

These relationships make OE_SALES_CREDITS an integral link between order capture data and salesrep compensation structures within Oracle Order Management.