Search Results so_sales_credits




Overview
Explore in AI Chat

Overview

The SO_SALES_CREDITS table is a core transactional table within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically in versions 12.1.1 and 12.2.2. It serves the critical function of storing and managing sales credit assignments for both sales orders and individual order lines. This data is essential for accurately tracking sales performance, calculating commissions, and attributing revenue to the correct sales representatives or teams. The table's existence is fundamental to the sales force automation and incentive compensation processes that integrate with the Order Management cycle.

Key Information Stored

The table's primary key is the unique SALES_CREDIT_ID. Its structure is defined by several key foreign key relationships that link it to other major entities in the system. The HEADER_ID column links the credit record to a specific sales order in the SO_HEADERS_ALL table, allowing for credits assigned at the header level. Conversely, the LINE_ID column links to the SO_LINES_ALL table for credits assigned to a specific line item. The SALESREP_ID column references the RA_SALESREPS_ALL table, identifying the specific salesperson receiving the credit. Finally, the SALES_CREDIT_TYPE_ID references the SO_SALES_CREDIT_TYPES_115 table, which defines the type or role of the credit (e.g., primary, secondary, tertiary). Additional columns typically store the credited percentage or amount for the associated sales representative.

Common Use Cases and Queries

A primary use case is generating sales commission reports by joining SO_SALES_CREDITS with sales order and salesperson tables. Analysts run queries to analyze sales performance by rep, team, or credit type. The table is also central to the order booking process, where the system creates records based on the sales credit rules defined for the transaction type or salesperson. A common reporting query pattern involves joining to SO_HEADERS_ALL for order information, SO_LINES_ALL for line details, and RA_SALESREPS_ALL for representative data. For example, a query to list all sales credits for a given order number would filter on SO_HEADERS_ALL.ORDER_NUMBER after joining via HEADER_ID. Troubleshooting often involves verifying that the sum of credited percentages for an order or line does not exceed 100%.

Related Objects

SO_SALES_CREDITS maintains integral relationships with several key EBS tables, as documented by its foreign keys:

  • SO_HEADERS_ALL: Linked via SO_SALES_CREDITS.HEADER_ID. This connects sales credits to the parent sales order.
  • SO_LINES_ALL: Linked via SO_SALES_CREDITS.LINE_ID. This connects sales credits to specific order lines.
  • RA_SALESREPS_ALL: Linked via SO_SALES_CREDITS.SALESREP_ID. This identifies the credited sales representative.
  • SO_SALES_CREDIT_TYPES_115: Linked via SO_SALES_CREDITS.SALES_CREDIT_TYPE_ID. This defines the classification of the sales credit.

These relationships ensure referential integrity and are crucial for any data extraction, reporting, or integration involving sales attribution.