Results for “comp_anchor_id”

24 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CN_COMP_ANCHORS is a transactional configuration table in the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite, owned by the CN schema. It stores compensation anchor definitions, which express the business rule that when a specific percentage of quota is attained, a corresponding expected commission is earned. In practice, anchors define the shape of the commission curve, allowing plan administrators to communicate to participants that reaching a given attainment threshold yields a defined payout. The table is central to quota-driven compensation modeling and is referenced by the participant-facing anchor table, CN_SRP_COMP_ANCHORS_ALL.

From a Data Vault modeling perspective, the ETRM metadata classifies CN_COMP_ANCHORS heuristically as a link. This suggestion reflects the table's role as an associative structure connecting quota categories and role-quota category assignments to an attainment and commission outcome, rather than serving as a standalone hub of business entities.

Key Information Stored

The table contains 29 documented columns. The most significant are:

Common Use Cases and Queries

A frequent requirement is to retrieve the full anchor definition for a given quota category, including its quota category name:

  • Query CN_COMP_ANCHORS joined to CN_QUOTA_CATEGORIES on QUOTA_CATEGORY_ID to report attainment-versus-commission relationships.
  • Join to CN_ROLE_QUOTA_CATES on ROLE_QUOTA_CATE_ID to report anchors by role assignment.
  • Join to CN_SRP_COMP_ANCHORS_ALL on COMP_ANCHOR_ID to trace which participant-level (SRP) records reference a given compensation anchor.
  • Filter on SECURITY_GROUP_ID to respect the active responsibility's security context in custom reports.
  • Sort by ATTAINMENT to view the payout curve in ascending threshold order, and correlate with COMMISSION to validate the schedule.

A representative pattern is: SELECT c.COMP_ANCHOR_ID, c.QUOTA_CATEGORY_ID, c.ATTAINMENT, c.TYPE, c.COMMISSION FROM CN_COMP_ANCHORS c WHERE c.QUOTA_CATEGORY_ID = :quota_category_id ORDER BY c.ATTAINMENT; These queries support plan validation, payout modeling, and reconciliation of participant anchor records against the master definition.

Related Objects

  • CN_QUOTA_CATEGORIES — referenced by CN_COMP_ANCHORS.QUOTA_CATEGORY_ID; defines the quota category to which an anchor applies.
  • CN_ROLE_QUOTA_CATES — referenced by CN_COMP_ANCHORS.ROLE_QUOTA_CATE_ID; supplies role-level quota category assignments.
  • FND_SECURITY_GROUPS — referenced by CN_COMP_ANCHORS.SECURITY_GROUP_ID; controls row-level data access.
  • CN_SRP_COMP_ANCHORS_ALL — references CN_COMP_ANCHORS.COMP_ANCHOR_ID; holds participant-level (SRP) anchor records derived from these definitions.

Together these objects form the anchor segment of the Incentive Compensation configuration model, bridging quota definitions and participant payout records.