Search Results cn_quotas_uk1

Overview

The CN_QUOTAS_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation module (CN). It serves as the master repository for plan elements, specifically defining quota definitions. A quota represents a performance target or goal that is assigned to salespeople or teams, forming the quantitative basis for commission calculations. This table is central to the configuration and execution of compensation plans, as quotas are linked to compensation formulas, credit types, and assignment rules. Being an "ALL" table, it is multi-org enabled, storing data for all operating units accessible to a user, with data partitioned by the ORG_ID column.

Key Information Stored

The table's structure is designed to define the complete attributes of a quota. The primary identifier is the QUOTA_ID (primary key). Each quota must have a unique NAME (enforced by the CN_QUOTAS_UK1 unique key). Critical foreign key columns link the quota to other essential setup entities: the CALC_FORMULA_ID references CN_CALC_FORMULAS_ALL to determine the computation logic; the CREDIT_TYPE_ID references CN_CREDIT_TYPES_ALL_B to define the type of transaction credit (e.g., revenue, quantity) measured; and the INTERVAL_TYPE_ID references CN_INTERVAL_TYPES_ALL_B to specify the performance period (e.g., quarterly, annually). Other typical columns, inferred from standard EBS design patterns, would include descriptive fields, effective start and end dates (START_DATE, END_DATE), creation and last update audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), and the ORG_ID for multi-org partitioning.

Common Use Cases and Queries

This table is primarily accessed for quota administration, reporting, and integration. Common scenarios include generating a list of all active quotas for a specific operating unit, analyzing quota assignments, and troubleshooting commission calculations. A typical query would join CN_QUOTAS_ALL with related setup tables to provide a comprehensive quota definition report.

Sample SQL Pattern:
SELECT q.NAME AS quota_name,
q.QUOTA_ID,
ct.NAME AS credit_type,
it.NAME AS interval_type,
cf.NAME AS formula_name
FROM cn_quotas_all q,
cn_credit_types_all_b ct,
cn_interval_types_all_b it,
cn_calc_formulas_all cf
WHERE q.credit_type_id = ct.credit_type_id
AND q.interval_type_id = it.interval_type_id
AND q.calc_formula_id = cf.calc_formula_id
AND q.org_id = :p_org_id
AND SYSDATE BETWEEN q.start_date AND NVL(q.end_date, SYSDATE);

Related Objects

As indicated by its extensive foreign key relationships, CN_QUOTAS_ALL is a pivotal parent table. Key dependent objects include:

• CN_QUOTA_ASSIGNS_ALL and CN_SRP_QUOTA_ASSIGNS_ALL: Store assignments of quotas to compensation plans and salespeople.
• CN_PERIOD_QUOTAS_ALL and CN_SRP_PERIOD_QUOTAS_ALL: Hold period-specific quota targets and achievements.
• CN_COMMISSION_LINES_ALL: Commission transactions reference the quota they satisfy.
• CN_POSTING_DETAILS_ALL: Posting records link back to the source quota.
• CN_QUOTA_RULES_ALL and CN_TRX_FACTORS_ALL: Define rules and adjustment factors applied to the quota.
• CN_RT_QUOTA_ASGNS_ALL and CN_SRP_RATE_ASSIGNS_ALL: Manage rate table assignments based on quotas.

These relationships underscore the table's integral role in connecting quota definitions to operational assignment, performance tracking, and final commission calculation processes within the Incentive Compensation module.