Search Results supplier payees




The CN_SRP_PAYEE_ASSIGNS_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Incentive Compensation module (Oracle Incentive Compensation - OIC). This table stores payee assignment records, which define the relationship between sales representatives (SRPs) and their corresponding payees, ensuring accurate commission calculations and compensation payouts. Below is a detailed technical and functional breakdown of this table.

Table Overview

The CN_SRP_PAYEE_ASSIGNS_ALL table is part of the CN (Commission) schema in Oracle EBS and is designed to support multi-organization structures, as indicated by the _ALL suffix. It maintains payee assignments across operating units, enabling enterprises to manage compensation plans for sales teams globally. Key attributes include:
  • SRP_ID: References the salesperson (from CN_SRPS_ALL).
  • PAYEE_ID: Links to the payee (from CN_PAYEES_ALL), who may be the SRP or a third party.
  • START_DATE and END_DATE: Define the active period of the assignment.
  • ORG_ID: Specifies the operating unit for data security (VPD policies may restrict access).

Functional Role

This table facilitates:
  1. Commission Allocation: Determines how commissions are distributed among payees (e.g., splits between primary and secondary recipients).
  2. Temporal Assignments: Supports historical tracking of payee relationships via date-effective records.
  3. Multi-Org Compliance: Aligns with Oracle’s Multi-Org architecture, segregating data by ORG_ID.

Key Columns and Relationships

Column Type Description
SRP_PAYEE_ASSIGN_ID NUMBER Primary key, uniquely identifying each assignment.
SRP_ID NUMBER Foreign key to CN_SRPS_ALL.SRP_ID.
PAYEE_ID NUMBER Foreign key to CN_PAYEES_ALL.PAYEE_ID.
ASSIGNMENT_TYPE VARCHAR2 Indicates if the assignment is 'PRIMARY', 'SECONDARY', or other.
PERCENTAGE NUMBER Commission split percentage (e.g., 80% for primary, 20% for secondary).

Integration Points

The table interacts with:
  • Compensation Plans: Referenced during commission calculations via CN_COMMISSION_API.
  • Payroll: Payee assignments flow to payroll systems through Oracle HRMS interfaces.
  • Audit & Reporting: Changes are logged in CN_AUDIT_TABLE for compliance.

Technical Considerations

  1. Indexing: Typically indexed on SRP_ID, PAYEE_ID, and ORG_ID for performance.
  2. Partitioning: In large deployments, partitions by ORG_ID or date ranges may be used.
  3. API Usage Modifications should use CN_SRP_PAYEE_ASSIGNS_PKG to enforce business rules.

Common Use Cases

  • Onboarding: Assigning new hires to payees during HR setup.
  • Restructuring: Updating assignments post-reorganization.
  • Audits: Validating commission splits for SOX compliance.

Conclusion

The CN_SRP_PAYEE_ASSIGNS_ALL table is a cornerstone of Oracle Incentive Compensation, ensuring accurate and auditable payee relationships. Its design supports complex commission structures while adhering to Oracle EBS architectural standards. Proper maintenance of this table is essential for reliable compensation processing and reporting.

  • Table: CN_SRP_PAYEE_ASSIGNS_ALL 12.2.2

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_SRP_PAYEE_ASSIGNS_ALL,  object_name:CN_SRP_PAYEE_ASSIGNS_ALL,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_SRP_PAYEE_ASSIGNS_ALL contains information of payees assigned to salesperson plan element. You need one row for each payee assignment to a saleperson plan element which is date effective. ,  implementation_dba_data: CN.CN_SRP_PAYEE_ASSIGNS_ALL , 

  • Table: CN_SRP_PAYEE_ASSIGNS_ALL 12.1.1

    owner:CN,  object_type:TABLE,  fnd_design_data:CN.CN_SRP_PAYEE_ASSIGNS_ALL,  object_name:CN_SRP_PAYEE_ASSIGNS_ALL,  status:VALID,  product: CN - Incentive Compensation ,  description: CN_SRP_PAYEE_ASSIGNS_ALL contains information of payees assigned to salesperson plan element. You need one row for each payee assignment to a saleperson plan element which is date effective. ,  implementation_dba_data: CN.CN_SRP_PAYEE_ASSIGNS_ALL ,