Results for “cn_comp_anchors”
36 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:
- COMP_ANCHOR_ID — the surrogate primary key, enforced by CN_COMP_ANCHORS_PK and also carried on the unique index CN_COMP_ANCHORS_U1. This is the column most commonly referenced by join queries and by the dependent table CN_SRP_COMP_ANCHORS_ALL.
- QUOTA_CATEGORY_ID — foreign key to CN_QUOTA_CATEGORIES, identifying the quota category against which the anchor is defined.
- ROLE_QUOTA_CATE_ID — foreign key to CN_ROLE_QUOTA_CATES, linking the anchor to a role-specific quota category assignment.
- ATTAINMENT — the percentage of quota attained at which the anchor's payout behavior applies.
- TYPE — categorizes the anchor entry, distinguishing the manner in which the attainment-to-commission relationship is applied.
- COMMISSION — the expected commission amount associated with the defined attainment level.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data security.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns, available for customer-specific extensions.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, OBJECT_VERSION_NUMBER — the standard audit and optimistic-locking columns.
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.
-
CN_COMP_ANCHORS contains compensation anchors information. User need to define if certain % of quota is achieved, what is the expected commission.
-
CN_COMP_ANCHORS contains compensation anchors information. User need to define if certain % of quota is achieved, what is the expected commission.
-
TABLE: CN.CN_COMP_ANCHORS 12.2.2
-
TABLE: CN.CN_COMP_ANCHORS 12.1.1
-
VIEW: CN.CN_COMP_ANCHORS# 12.2.2
-
VIEW: CN.CN_COMP_ANCHORS# 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
Table storing anchor information at the salesperson (resource) level
-
Table storing anchor information at the salesperson (resource) level
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - CN Tables and Views 12.1.1
-
eTRM - CN Tables and Views 12.2.2
-
eTRM - CN Tables and Views 12.1.1
-
eTRM - CN Tables and Views 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1