Search Results aso_sales_credits




Overview
Explore in AI Chat

Overview

The ASO_SALES_CREDITS table is a core data object within the Oracle E-Business Suite (EBS) Order Capture (ASO) module. It serves as the primary repository for storing sales credit assignments, which define the commission or revenue attribution for sales representatives and groups on sales transactions. This table is critical for the accurate calculation, tracking, and reporting of sales compensation and performance metrics. It supports the sales credit functionality for both quotations and orders processed through the Order Management and Trade Management flows in releases 12.1.1 and 12.2.2. The integrity of its data is maintained through a primary key constraint and several defined foreign key relationships to parent transactional and master data tables.

Key Information Stored

The table's structure is designed to capture the essential elements of a sales credit assignment. The primary identifier is the SALES_CREDIT_ID column. Crucially, the table links the credit to a specific transaction via the QUOTE_HEADER_ID and/or QUOTE_LINE_ID columns, allowing credits to be assigned at either the header or line level. The sales resource (individual salesperson) receiving the credit is identified by the RESOURCE_ID, which references the JTF_RS_RESOURCE_EXTNS table. For credits assigned to a team or group, the RESOURCE_GROUP_ID column references JTF_RS_GROUPS_B. Additional columns, implied by standard practice and the table's purpose, would typically store the percentage or amount of the credit, the role of the resource (e.g., primary, secondary), and standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing.

Common Use Cases and Queries

This table is central to operations involving sales compensation and revenue analysis. Common use cases include generating commission statements, analyzing sales performance by representative or team, and auditing credit distributions on specific quotes or orders. A typical reporting query might join ASO_SALES_CREDITS to quote and resource tables to list all credits for a given time period. For example:

  • Identifying credits for a specific quote: SELECT * FROM aso.aso_sales_credits WHERE quote_header_id = <header_id>;
  • Summarizing credits by sales representative: SELECT resource_id, SUM(credit_amount) FROM aso.aso_sales_credits scr JOIN aso.aso_quote_headers_all q ON scr.quote_header_id = q.quote_header_id WHERE q.creation_date BETWEEN :p_start_date AND :p_end_date GROUP BY resource_id;

Data from this table is also essential for interfaces to external commission calculation systems.

Related Objects

As indicated by its foreign keys, ASO_SALES_CREDITS has strong dependencies on several key EBS tables. Its primary transactional relationships are with ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL, anchoring sales credits to the quotations from which orders originate. For master data, it relies on the Resource Manager (JTF) tables: JTF_RS_RESOURCE_EXTNS for individual salesperson details and JTF_RS_GROUPS_B for sales team definitions. While not explicitly listed in the provided metadata, this table is also likely referenced by or interfaces with objects in the Order Management (OE) and Commission (CN) modules for order import and compensation processing, respectively. Custom reports and integrations will frequently join to this table to extract sales credit data.