Results for “cn_quotas_all”

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

Overview

CN_QUOTAS_ALL is the master definition table for plan elements (quotas) within the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the configuration of each quota plan element, including target amounts, period structures, rate schedules, credit types, calculation formulas, and payment characteristics. Plan elements defined here drive the compensation engine, feeding quota assignments, calculation runs, transaction factor resolution, period quotas, and payment processing.

The table resides in the CN schema, is flagged VALID, and is documented with 67 columns in the ETRM 12.2.2 physical schema. The primary key is CN_QUOTAS_PK on QUOTA_ID, and the business-key candidate is the unique index CN_QUOTAS_UK1 on NAME (with CN_QUOTAS_U1 on QUOTA_ID, ORG_ID also documented). A heuristic Data Vault classification of this object is a hub: it holds the durable identity of each quota (the QUOTA_ID business key) with descriptive attributes, while dependent and transactional relationships are carried by satellite and link-style tables that reference it.

Key Information Stored

The surrogate primary key is QUOTA_ID, and NAME is the documented unique business-key candidate; ORG_ID scopes the record to a business unit, and SECURITY_GROUP_ID supports multi-org security. The most significant descriptive columns include:

• QUOTA_TYPE_CODE, USAGE_CODE, PERIOD_TYPE_CODE — classify the plan element (quota type, usage, and period basis).
• TARGET — the target amount or quantity the quota measures against.
• START_PERIOD_ID, END_PERIOD_ID, START_DATE, END_DATE — effective and active period range of the quota.
• RATE_SCHEDULE_ID, DISC_RATE_SCHEDULE_ID — the rate schedule and discount rate schedule applied to the element.
• CALC_FORMULA_ID, INTERVAL_TYPE_ID, CREDIT_TYPE_ID, BONUS_CREDIT_TYPE_ID — foreign-key references to the calculation formula, interval type, and credit type definitions that govern earning behavior.
• PAYMENT_TYPE_CODE, PAYMENT_AMOUNT, PAYMENT_GROUP_CODE — payment configuration for the element.
• CUMULATIVE_FLAG, ITD_FLAG, SPLIT_FLAG, VESTING_FLAG, QUOTA_STATUS — behavior flags governing accumulation, inception-to-date treatment, splits, vesting, and lifecycle status.
• QUOTA_GROUP_CODE, INCENTIVE_TYPE_CODE, PERFORMANCE_GOAL — grouping and goal-setting attributes.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ATTRIBUTE1–ATTRIBUTE15 provide audit and extensibility support. DELETE_FLAG and OBJECT_VERSION_NUMBER support logical deletion and optimistic locking.

Common Use Cases and Queries

Typical reporting and validation queries resolve quota definitions for a given organization and active period, or join to dependent assignment and period tables:

• Retrieve active quotas for an org: SELECT quota_id, name, quota_type_code, target FROM cn_quotas_all WHERE org_id = :p_org AND delete_flag = 'N' AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
• List quotas sharing a formula or rate schedule by joining CALC_FORMULA_ID to CN_CALC_FORMULAS_ALL or RATE_SCHEDULE_ID to CN_RATE_SCHEDULES_ALL.
• Trace quota assignments for a salesrep by joining CN_QUOTA_ASSIGNS_ALL on QUOTA_ID.
• Reconcile period-level attainment via CN_PERIOD_QUOTAS_ALL on QUOTA_ID.
• Audit posting activity against a quota through CN_POSTING_DETAILS_ALL on QUOTA_ID.

Related Objects

CN_QUOTAS_ALL acts as a reference hub with numerous dependents keyed on QUOTA_ID. The most significant related objects include:

• CN_QUOTA_ASSIGNS_ALL — assigns quotas to salesreps; join on QUOTA_ID.
• CN_PERIOD_QUOTAS_ALL — period-by-period quota targets; join on QUOTA_ID.
• CN_COMMISSION_LINES_ALL — calculated commission lines; join on QUOTA_ID.
• CN_QUOTA_RULES_ALL — rule definitions scoped to a quota; join on QUOTA_ID.
• CN_CALC_FORMULAS_ALL, CN_CREDIT_TYPES_ALL_B, CN_INTERVAL_TYPES_ALL_B, CN_RATE_SCHEDULES_ALL — referenced masters via CALC_FORMULA_ID, CREDIT_TYPE_ID, INTERVAL_TYPE_ID, and RATE_SCHEDULE_ID respectively.
• CN_PAYMENT_TRANSACTIONS_ALL and CN_POSTING_DETAILS_ALL — payment and posting activity; join on QUOTA_ID.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for multi-org security context.