Search Results op_comm_cds




Overview
Explore in AI Chat

Overview

The OP_COMM_CDS table is a core data object within the Process Manufacturing Logistics (GML) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the detail table for commission codes, storing the specific rules and assignments that determine how commissions are calculated and allocated. Its primary role is to link a commission code with a specific sales representative and a qualifying commission event, thereby defining the precise conditions under which a commission is earned. This table is essential for the accurate and automated processing of sales incentives and compensation within the manufacturing and distribution operations managed by the GML product family.

Key Information Stored

The table's structure, as indicated by its primary and foreign keys, centers on three critical identifiers. The COMMISSION_CODE column is the primary link to the OP_COMMISSION table, which holds the master definition of the commission code, including its calculation method and rates. The SLSREP_CODE column links to the OP_SLSR_MST table, identifying the specific sales representative eligible for the commission. The COMMISSION_EVENT column defines the specific transaction or activity that triggers the commission calculation. Additionally, the TEXT_CODE column provides a foreign key link to the OP_TEXT_HDR table, allowing for the association of descriptive notes or terms and conditions with the commission detail record. Together, these columns create a granular rule set for commission entitlement.

Common Use Cases and Queries

This table is central to commission reporting and validation. A common operational use case involves verifying the active commission rules for a sales representative prior to processing sales orders or shipments. For reporting, analysts frequently query this table to list all commission assignments or to audit commission setups. A typical SQL pattern involves joining OP_COMM_CDS to its related master tables to produce a readable report.

  • Sample Query: To retrieve a list of all commission details with descriptive information:
    SELECT cds.COMMISSION_CODE, cds.SLSREP_CODE, cds.COMMISSION_EVENT, comm.DESCRIPTION AS COMM_DESC, slsr.NAME AS REP_NAME FROM GML.OP_COMM_CDS cds, GML.OP_COMMISSION comm, GML.OP_SLSR_MST slsr WHERE cds.COMMISSION_CODE = comm.COMMISSION_CODE AND cds.SLSREP_CODE = slsr.SLSREP_CODE ORDER BY cds.SLSREP_CODE, cds.COMMISSION_CODE;
  • Another critical use case is during transactional processing, where the application queries this table to find the valid commission code for a given sales representative and event, which is then used to populate commission lines on relevant documents.

Related Objects

The OP_COMM_CDS table has defined relationships with several key tables, as per its foreign key constraints. Its primary parent is the OP_COMMISSION table, which provides the master definition for the commission code. The OP_SLSR_MST table is the master source for all sales representative data. For descriptive text, it references the OP_TEXT_HDR table. As a detail table, OP_COMM_CDS is likely referenced by transactional interfaces and programs within the GML module that calculate and generate commission transactions, though these are not explicitly listed in the provided metadata. Any custom reports or integrations involving sales commissions must account for the rules stored in this table.