Results for “payment_factor”

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

Overview

The table CN_QUOTA_RULE_UPLIFTS_ALL resides in the CN schema and belongs to the Oracle Incentive Compensation (CN) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the payment and target uplift percentages applied to revenue classes assigned to a quota rule, maintained across specific date ranges. In practice, an uplift represents a multiplier or additive adjustment that scales a representative's attainment or payout calculation relative to a defined baseline.

From a data modeling perspective, the metadata's heuristic Data Vault classification identifies this object as satellite-leaning. This suggestion reflects the table's role as a dependent structure that captures descriptive, time-bound attributes about a parent entity — specifically the quota rule identified by QUOTA_RULE_ID — rather than serving as an independent hub of business keys or a pure many-to-many link.

The _ALL suffix indicates that the table is partitioned or filtered by operating unit through the ORG_ID column, and access is further constrained by SECURITY_GROUP_ID referencing FND_SECURITY_GROUPS. This multi-org and security-group design is consistent with standard EBS concurrency and access architecture.

Key Information Stored

The physical schema documents 30 columns. The most significant are summarized below.

• QUOTA_RULE_UPLIFT_ID — Surrogate primary key, defined by the CN_QUOTA_RULE_UPLIFTS_PK constraint. This is the identifier users typically reference when searching the object.
• ORG_ID — Operating unit discriminator. It participates in the unique index CN_QUOTA_RULE_UPLIFTS_U1 alongside the primary key column.
• QUOTA_RULE_ID — Foreign key to CN_QUOTA_RULES_ALL, identifying the parent quota rule to which the uplift belongs.
• START_DATE and END_DATE — The effective date range during which the uplift percentage applies.
• PAYMENT_FACTOR — The multiplier or percentage used to adjust payment calculations.
• QUOTA_FACTOR — The multiplier or percentage used to adjust quota or target attainment.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling record-level access.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER — support standard EBS auditing and optimistic locking.
• Descriptive flexfield columns — ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — allow user-defined extensions.

The unique index CN_QUOTA_RULE_UPLIFTS_U1 on (QUOTA_RULE_UPLIFT_ID, ORG_ID) represents the business-key candidate; the surrogate key alone remains the declared primary key.

Common Use Cases and Queries

Typical scenarios include auditing uplift configuration for a plan element, validating overlapping date ranges, and reconciling payment factors used in compensation runs.

• Retrieve all uplifts for a rule: SELECT QUOTA_RULE_UPLIFT_ID, START_DATE, END_DATE, PAYMENT_FACTOR, QUOTA_FACTOR FROM CN_QUOTA_RULE_UPLIFTS_ALL WHERE QUOTA_RULE_ID = :p_rule_id AND ORG_ID = :p_org_id;
• Find active uplifts for a given date: filter with START_DATE <= SYSDATE AND (END_DATE IS NULL OR END_DATE >= SYSDATE).
• Detect overlapping periods for the same rule to prevent double-counting in payout logic.
• Join to CN_QUOTA_RULES_ALL to report uplift factors alongside plan element and revenue class context.

Related Objects

• CN_QUOTA_RULES_ALL — Parent table joined on QUOTA_RULE_ID.
• CN_SRP_RULE_UPLIFTS_ALL — Child table referencing QUOTA_RULE_UPLIFT_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for access control.