Search Results oks_k_sales_credits




Overview
Explore in AI Chat

Overview

The OKS_K_SALES_CREDITS table is a core transactional table within the Oracle E-Business Suite (EBS) Service Contracts (OKS) module. It is designed to record and manage sales credit allocations for the sale of services associated with a service contract. This table is essential for tracking and attributing sales revenue to specific salespersons or partners, which directly supports commission calculations, sales performance reporting, and revenue recognition processes. Its existence underscores the integration of service contract management with the broader order-to-cash cycle, ensuring that sales efforts for services are financially accounted for in alignment with standard Oracle Applications practices.

Key Information Stored

The table's structure is defined by its relationships to other core contract entities. The primary key is a unique identifier (ID). The most critical columns are the foreign keys that link a sales credit record to its parent objects: CHR_ID links to the OKC_K_HEADERS_B table to associate the credit with a specific service contract header, and CLE_ID links to the OKC_K_LINES_B table to associate it with a specific line item within that contract. The CTC_ID column links to the OKC_CONTACTS table, identifying the specific salesperson or contact receiving the credit. While the provided metadata does not list all columns, typical sales credit tables in EBS also store percentage or amount-based credit allocations, making this table the definitive source for "who sold what" within the service contracts domain.

Common Use Cases and Queries

The primary use case is generating reports for sales commissions and performance analysis for service contract sales teams. Finance and sales operations personnel query this table to reconcile booked service contract revenue with credited sales resources. A common analytical query involves joining to contract headers and lines to summarize credits by salesperson, product, or period. For troubleshooting, support teams may query this table to validate credit assignments when disputes arise. A sample SQL pattern to retrieve basic credit information would be:

  • SELECT sc.id, h.contract_number, l.line_number, c.contact_name, sc.credit_percentage
  • FROM oks.oks_k_sales_credits sc,
  • okc.k_headers_b h,
  • okc.k_lines_b l,
  • okc.okc_contacts c
  • WHERE sc.chr_id = h.id
  • AND sc.cle_id = l.id
  • AND sc.ctc_id = c.id(+);

Related Objects

As defined by its foreign keys, OKS_K_SALES_CREDITS has direct, mandatory relationships with several foundational OKC (Oracle Contracts Core) tables. The OKC_K_HEADERS_B table is the parent for all contract headers, including service contracts. The OKC_K_LINES_B table stores all line items for contracts. The OKC_CONTACTS table is the master repository for contact information. The table is also intrinsically linked to the OKS module's logic and is likely referenced by key Service Contracts APIs, such as those used for contract creation, renewal, and amendment, which would propagate sales credit information. Reports and interfaces for commissions (like those feeding Oracle Incentive Compensation) would source their service contract data from this table or its derivative views.