Search Results cn_interval_types_all_b




Overview
Explore in AI Chat

Overview

The CN_INTERVAL_TYPES_ALL_B table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module. It serves as the master repository for defining accumulation calendar interval types. These interval types are fundamental building blocks for configuring compensation plans, as they define the time periods—such as weeks, months, quarters, or custom fiscal intervals—over which performance metrics are measured and accumulated. Administrators assign these predefined interval types to specific plan elements and quotas, enabling the system to calculate commissions, bonuses, and incentives accurately over designated timeframes. The table supports a multi-org structure, as indicated by the "_ALL_B" suffix, allowing interval type definitions to be shared or partitioned across different operating units.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal the essential data structure. The central column is INTERVAL_TYPE_ID, which is the table's primary key and a unique identifier for each interval type definition. Other typical columns in such a reference table would include fields for the interval type name (e.g., 'MONTH', 'QUARTER'), a description, a system flag indicating if it is user-defined or seeded, start and end dates for validity, and columns for creation and last update metadata. The table's design ensures referential integrity for all interval type references throughout the Incentive Compensation module.

Common Use Cases and Queries

This table is primarily referenced during the setup and administration of compensation plans. A common operational query involves listing all available interval types for assignment during plan element configuration. For example: SELECT interval_type_id, name FROM cn_interval_types_all_b WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate) ORDER BY name;. Reporting use cases often involve joining this table to quota or payment schedules to analyze performance periods. Troubleshooting queries may check for interval types assigned to specific quotas or calendar periods to validate plan setup. The table is critical for backend processes that generate accumulation rollups and calculate earned compensation within the correct time intervals.

Related Objects

The CN_INTERVAL_TYPES_ALL_B table has defined foreign key relationships with several other key Incentive Compensation tables, as documented in the metadata:

  • CN_CAL_PER_INT_TYPES_ALL: This table links calendar periods to interval types. It joins via CN_CAL_PER_INT_TYPES_ALL.INTERVAL_TYPE_ID to define which periods belong to which interval type within an accumulation calendar.
  • CN_QUOTAS_ALL: This core table stores quota definitions. It joins via CN_QUOTAS_ALL.INTERVAL_TYPE_ID to specify the accumulation period (e.g., monthly, quarterly) for which a sales quota is measured.
These relationships confirm that CN_INTERVAL_TYPES_ALL_B is a master reference table, and its INTERVAL_TYPE_ID column is propagated to define temporal boundaries in both calendar structures (CN_CAL_PER_INT_TYPES_ALL) and performance goals (CN_QUOTAS_ALL).