Results for “prorated_amount”

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

Overview

CN_SRP_QUOTA_CATES_ALL is a transactional table in the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite, owned by the CN schema. It stores the quota components assigned to individual salespersons, forming the bridge between a salesperson's role assignment and the quota categories, models, and rates that drive compensation calculations. Each row represents a quota category allocation for a specific salesperson role, capturing the monetary amounts, over-target earnings (OTE), proration factors, and estimated achievement and payout figures used during incentive plan processing.

The table resides in both Oracle EBS 12.1.1 and 12.2.2. In 12.2.2 the documented physical schema includes 48 columns, and the table is enabled with Multi-Org access through the ORG_ID column. Based on the mined foreign key structure, the heuristic Data Vault classification is satellite-leaning, meaning the table predominantly stores descriptive and measurable attributes that hang off broader hub or link entities such as salesperson roles and quota categories, rather than acting as an independent hub of business keys.

Key Information Stored

The surrogate primary key is SRP_QUOTA_CATE_ID, enforced by the constraint CN_SRP_QUOTA_CATES_PK. Two unique indexes provide business-key candidates: CN_SRP_QUOTA_CATES_U1 on (SRP_QUOTA_CATE_ID, ORG_ID) and CN_SRP_QUOTA_CATES_U2 on (SRP_ROLE_ID, QUOTA_CATEGORY_ID), the latter confirming that a given role may hold only one allocation per quota category.

• SRP_ROLE_ID — foreign key to CN_SRP_ROLE_DTLS_ALL, identifying the salesperson role the quota applies to.
• QUOTA_CATEGORY_ID — foreign key to CN_QUOTA_CATEGORIES, the category being allocated.
• ROLE_QUOTA_CATE_ID — foreign key to CN_ROLE_QUOTA_CATES, linking to the underlying role-level quota category definition.
• ROLE_MODEL_ID — foreign key to CN_ROLE_MODELS_ALL, identifying the compensation model applied.
• SRP_ID and ROLE_ID — salesperson and role identifiers carried for reporting convenience.
• AMOUNT, PLANNING_AMT, and FIELD_AMT — quota amounts at plan, planning, and field level.
• OTE and PRORATED_OTE — over-target earnings, both original and prorated, with PRORATED_OTE_ORIG retaining the source value.
• PRORATED_AMOUNT and PRORATED_AMOUNT_ORIG — prorated quota amount and its original equivalent.
• PRORATION_FACTOR, PRORATION_METHOD, and RATES_CALCULATED_USING — the proration mechanics applied.
• EST_ACHIEVEMENT, EST_PAYOUT, and PAYMENT_AMOUNT — achievement and payout estimates used in crediting.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, plus standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, OBJECT_VERSION_NUMBER).

Common Use Cases and Queries

Compensation analysts and plan administrators query this table to review quota allocations per salesperson, reconcile prorated versus original amounts, and audit estimated payouts before final crediting. A typical reporting query joins the table to CN_SRP_ROLE_DTLS_ALL and CN_QUOTA_CATEGORIES to produce a per-rep quota summary:

• Quota allocation extracts filtered by ORG_ID and quota category for a given plan period.
• Proration validation, comparing PRORATED_AMOUNT against PRORATED_AMOUNT_ORIG and PRORATION_FACTOR to detect mid-period plan changes.
• Payout estimation reports using EST_ACHIEVEMENT, EST_PAYOUT, and PAYMENT_AMOUNT.
• Rate reconciliation joining to CN_SRP_QUOTA_RATES_ALL on SRP_QUOTA_CATE_ID to verify which rates were calculated.
• Model-level rollups joining to CN_ROLE_MODELS_ALL to analyze quota distribution across compensation models.

Related Objects

• CN_SRP_ROLE_DTLS_ALL — joined on SRP_ROLE_ID; the parent salesperson role detail.
• CN_ROLE_QUOTA_CATES — joined on ROLE_QUOTA_CATE_ID; the role-level quota category template.
• CN_ROLE_MODELS_ALL — joined on ROLE_MODEL_ID; the compensation model definition.
• CN_QUOTA_CATEGORIES — joined on QUOTA_CATEGORY_ID; the quota category master.
• CN_SRP_QUOTA_RATES_ALL — child table referenced via SRP_QUOTA_CATE_ID; stores rates derived from each quota allocation.
• CN_SRP_COMP_ANCHORS_ALL — child table referenced via SRP_QUOTA_CATE_ID; holds compensation anchor records.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for access control.