Search Results as_sales_credits




Overview
Explore in AI Chat

Overview

The AS_SALES_CREDITS table is a core data structure within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). It functions as the central repository for sales credit assignments, a critical component of sales performance management and compensation. This table stores the definitive record of which sales resources—individuals or groups—are credited for specific sales opportunities, and it dictates the allocation of revenue credit for commission calculations. Its role is integral to the sales pipeline and forecasting processes, linking sales activities directly to the compensation and performance tracking of the sales force.

Key Information Stored

The table's primary identifier is the SALES_CREDIT_ID. Its structure is defined by key foreign key relationships that connect sales credits to other central entities in EBS. The most significant columns include LEAD_ID and LEAD_LINE_ID, which link the credit to a specific sales opportunity (lead) and its line item within the AS_LEADS_ALL and AS_LEAD_LINES_ALL tables. The SALESFORCE_ID column references the JTF_RS_RESOURCE_EXTNS table to identify the individual salesperson, while SALESGROUP_ID references JTF_RS_GROUPS_B for team-based credit. For partner sales, PARTNER_CUSTOMER_ID and PARTNER_ADDRESS_ID link to the Trading Community Architecture (HZ_PARTIES and HZ_PARTY_SITES). Additional columns typically store the percentage of credit allocated and active status flags, though specific non-key column details are not enumerated in the provided metadata.

Common Use Cases and Queries

This table is primarily accessed for sales performance analytics, commission reporting, and data validation. Common operational and reporting queries include calculating total credited revenue per salesperson, validating credit allocations for a specific opportunity, and auditing credit distributions before commission runs. A typical analytical query pattern would join AS_SALES_CREDITS to resource and lead tables to aggregate data.

  • Sample Query (Credit Summary by Salesperson):
    SELECT r.resource_name, SUM(sc.credit_percentage) AS total_credit_percentage
    FROM osm.as_sales_credits sc,
        jtf_rs_resource_extns r
    WHERE sc.salesforce_id = r.resource_id
    AND sc.lead_id = :p_lead_id
    GROUP BY r.resource_name;
  • Data Validation: Queries are often executed to ensure the sum of credit percentages for a single lead or line item does not exceed 100%.

Related Objects

AS_SALES_CREDITS has extensive relationships within the EBS schema, as confirmed by its foreign keys. It is a parent table to the denormalized summary table AS_SALES_CREDITS_DENORM. It is fundamentally a child table of the lead objects (AS_LEADS_ALL, AS_LEAD_LINES_ALL), drawing its transactional context from them. Its relationships to the resource management tables (JTF_RS_RESOURCE_EXTNS, JTF_RS_GROUPS_B) are essential for assigning credit to the correct recipients. Furthermore, its links to the Trading Community (HZ_PARTIES) enable partner-centric credit tracking. Any custom reporting or integration involving sales compensation or opportunity attribution will likely traverse this table and its related entities.