Results for “hist_created_by”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OE_SALES_CREDIT_HISTORY is an ONT (Order Management) audit table in the Oracle E-Business Suite, owned by the ONT schema. It stores the history of attribute changes for an Entity Sales Credits record, preserving prior values of a sales credit line each time a qualifying attribute is modified. Sales credits represent the allocation of revenue credit to salespersons or sales groups on an order line, and this table is the historical companion to the active OE_SALES_CREDIT entity. It is populated by Order Management when a sales credit record is updated, and it is primarily consumed by audit, compliance, and sales compensation reconciliation reporting. The table is valid in both EBS 12.1.1 and 12.2.2, and the ETRM 12.2.2 documentation shows a physical schema of 45 columns.

Based on the mined foreign key structure, the Data Vault classification is heuristic and suggests a satellite pattern. The table has no downstream foreign key dependents (standalone), and it retains change history for attributes associated with a parent sales credit entity. This makes it consistent with a historical satellite, capturing point-in-time attribute values rather than serving as a hub or a link.

Key Information Stored

The most significant columns fall into identification, attribution, and audit categories:

• SALES_CREDIT_ID — Surrogate identifier tying the history row to the corresponding sales credit entity.
• HEADER_ID — Order header identifier for the order to which the sales credit belongs.
• LINE_ID — Order line identifier associated with the sales credit.
• SALESREP_ID — The salesperson whose credit allocation is being tracked.
• PERCENT — The percentage of credit assigned to the salesperson or group.
• SALES_CREDIT_TYPE_ID — Foreign key to SO_SALES_CREDIT_TYPES_115, defining the credit type (for example, quota or revenue credit).
• SALES_GROUP_ID — Identifier for the sales group associated with the credit.
• HIST_CREATION_DATE — Timestamp marking when the historical record was created.
• HIST_TYPE_CODE — Code indicating the type of historical event captured.
• HIST_CREATED_BY — User who triggered creation of the history row.
• HIST_COMMENTS — Free-text comments describing the change recorded.
• REASON_CODE / REASON_ID — Reason for the change, supporting auditability.
• RESPONSIBILITY_ID — The responsibility under which the change was made.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — Standard EBS audit columns inherited by the historical record.

The surrogate primary key is SALES_CREDIT_ID combined with historical context; business-key candidates include HEADER_ID, LINE_ID, SALESREP_ID, and SALES_CREDIT_TYPE_ID where uniqueness within a history event is required. Versioning columns such as VERSION_NUMBER and VERSION_FLAG support chronological sequencing of changes.

Common Use Cases and Queries

Typical uses include audit trails for sales credit adjustments, compensation dispute resolution, and reporting on historical credit allocation changes over time. A common query retrieves the change history for a given sales credit:

• SELECT sales_credit_id, header_id, line_id, salesrep_id, percent, hist_type_code, hist_creation_date FROM oe_sales_credit_history WHERE sales_credit_id = :p_id ORDER BY hist_creation_date DESC;
• Join to the credit type table to resolve the type name: SELECT h.sales_credit_id, t.name, h.percent, h.hist_creation_date FROM oe_sales_credit_history h, so_sales_credit_types_115 t WHERE h.sales_credit_type_id = t.sales_credit_type_id;
• Resolve historical changes by header: SELECT header_id, COUNT(*) FROM oe_sales_credit_history WHERE header_id = :p_header GROUP BY header_id;

Reporting frequently compares live sales credit records against their historical counterparts to quantify the frequency and magnitude of adjustments.

Related Objects

• OE_SALES_CREDIT — The active sales credit entity from which history rows are generated.
• OE_ORDER_HEADERS_ALL — Joined on HEADER_ID (order_header_id) to obtain order context.
• OE_ORDER_LINES_ALL — Joined on LINE_ID (line_id) for order line detail.
• SO_SALES_CREDIT_TYPES_115 — Documented foreign key target via SALES_CREDIT_TYPE_ID.
• JTF_RS_SALESREPS — Joined on SALESREP_ID to resolve salesperson names and attributes.
• FND_RESPONSIBILITY — Joined on RESPONSIBILITY_ID to resolve the responsibility used during the change.
• ASO_* / Order Management APIs — Sales credit maintenance APIs that trigger insertion of history records.