Results for “performance_goal”

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

Overview

CN_QUOTA_RULES_ALL is a transactional configuration table within the Oracle EBS Incentive Compensation (CN) module. It stores quota rules, which associate revenue classes with plan elements and define the crediting, payment, and quota attainment logic applied to a specific quota. Each row represents a single quota rule belonging to a quota and mapped to a revenue class, enabling organizations to differentiate how revenue from distinct product lines or transaction categories contributes toward incentive targets and payouts.

The table is owned by the CN schema and is a multi-org (Organization) enabled object, as evidenced by the presence of ORG_ID and the security group column SECURITY_GROUP_ID, which is a foreign key to FND_SECURITY_GROUPS. Business key integrity is enforced through three unique indexes: CN_QUOTA_RULES_PK on QUOTA_RULE_ID, CN_QUOTA_RULES_U2 on (QUOTA_ID, REVENUE_CLASS_ID), and CN_QUOTA_RULES_U1 on (QUOTA_RULE_ID, ORG_ID). The table participates in extensive downstream processing, with several dependent tables (commission lines, uplifts, transaction factors, and posting details) referencing its primary key.

From a Data Vault modeling perspective, the FK structure suggests a hub-leaning classification: the table anchors a stable business key (QUOTA_RULE_ID) while referencing distinct hubs such as CN_QUOTAS_ALL and CN_REVENUE_CLASSES_ALL. This is a heuristic suggestion rather than a prescriptive design, as the table also carries descriptive attributes (NAME, TARGET, PAYMENT_FACTOR) that resemble satellite content.

Key Information Stored

The primary surrogate key is QUOTA_RULE_ID, generated by the CN_QUOTA_RULES_PK constraint. The most significant business columns include:

• ORG_ID – the operating unit context for multi-org security and partitioning.
• QUOTA_ID – foreign key to CN_QUOTAS_ALL, identifying the parent quota to which the rule belongs.
• REVENUE_CLASS_ID – foreign key to CN_REVENUE_CLASSES_ALL, the revenue class this rule governs.
• NAME and DESCRIPTION – user-facing identifiers and narrative detail for the rule.
• TARGET – the target amount or quantity associated with the quota rule.
• PERFORMANCE_GOAL – the attainment objective the rule measures against.
• PAYMENT_FACTOR and QUOTA_FACTOR – numeric multipliers that control how credited amounts translate to payment and quota credit respectively.
• PAYMENT_AMOUNT – the computed or configured payout value tied to the rule.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 – the standard Oracle flexfield descriptive columns for extensibility.
• SECURITY_GROUP_ID – links the rule to a security group for data access controls.
• OBJECT_VERSION_NUMBER – supports optimistic locking during concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – the standard audit Who columns.

The composite unique index CN_QUOTA_RULES_U2 on (QUOTA_ID, REVENUE_CLASS_ID) ensures that any given revenue class may map to a quota only once, preventing duplicate crediting definitions.

Common Use Cases and Queries

Typical usage involves joining quota rules to their parent quota and revenue class to report incentive configuration. A representative query retrieves all rules for a quota:

• Configuration reporting: SELECT qr.quota_rule_id, qr.name, rc.name AS revenue_class, qr.target, qr.payment_factor FROM cn_quota_rules_all qr JOIN cn_revenue_classes_all rc ON rc.revenue_class_id = qr.revenue_class_id WHERE qr.quota_id = :quota_id AND qr.org_id = :org_id;
• Attainment analysis: Joining to CN_COMMISSION_LINES_ALL via QUOTA_RULE_ID aggregates credited commission amounts against the rule's TARGET and PERFORMANCE_GOAL.
• Uplift and factor reconciliation: Joining to CN_QUOTA_RULE_UPLIFTS_ALL and CN_TRX_FACTORS_ALL on QUOTA_RULE_ID to trace how transaction-level factors influence the final payment through PAYMENT_FACTOR and QUOTA_FACTOR.
• Posting and payment validation: Querying CN_POSTING_DETAILS_ALL and CN_PAYMENT_TRANSACTIONS_ALL by QUOTA_RULE_ID to reconcile payouts back to their originating rule.

Reporting tools frequently extract this table to audit quota-to-revenue-class mappings and to verify that factor configurations are complete before a compensation processing run.

Related Objects

• CN_QUOTAS_ALL – parent table joined on QUOTA_ID; supplies quota header context.
• CN_REVENUE_CLASSES_ALL – joined on REVENUE_CLASS_ID; defines the revenue class being credited.
• CN_COMMISSION_LINES_ALL – references QUOTA_RULE_ID; holds commission calculation output.
• CN_QUOTA_RULE_UPLIFTS_ALL – references QUOTA_RULE_ID; stores uplift adjustments for the rule.
• CN_SRP_QUOTA_RULES_ALL – references QUOTA_RULE_ID; the sales rep plan assignment to quota rules.
• CN_TRX_FACTORS_ALL – references QUOTA_RULE_ID; transaction factor definitions.
• CN_POSTING_DETAILS_ALL and CN_PAYMENT_TRANSACTIONS_ALL – both reference QUOTA_RULE_ID for posting and payment traceability.
• FND_SECURITY_GROUPS – joined on SECURITY_GROUP_ID for security group resolution.