Search Results cn_cal_per_int_types_pk

Overview

The table CN_CAL_PER_INT_TYPES_ALL is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module. It functions as a master reference table that defines the relationship between accumulation calendars and the specific interval types used for performance measurement periods. In essence, it governs how compensation plans calculate earnings by linking a calendar structure to the time intervals—such as quarters, months, or custom periods—over which sales performance and commissions are accumulated. This table is central to the configuration of complex, time-based incentive calculations, ensuring that payouts are aligned with the correct fiscal or operational timelines defined by the organization. As a table with the '_ALL' suffix, it is designed to support multi-organization access (Multi-Org) within the EBS architecture.

Key Information Stored

The table's primary purpose is to maintain the mapping between a calendar period interval type and its associated interval definition. The most critical column is the primary key, CAL_PER_INT_TYPE_ID, which uniquely identifies each mapping record. A second crucial column is the foreign key, INTERVAL_TYPE_ID. This column references the CN_INTERVAL_TYPES_ALL_B table to specify the exact type of interval (e.g., 'Fiscal Month', 'Calendar Quarter') being applied within a given accumulation calendar context. While the provided metadata does not list all columns, typical supporting columns would include standard EBS audit fields (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and an ORG_ID column to segregate data by operating unit as part of the Multi-Org model.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of compensation plans and during the commission calculation engine's runtime. Administrators query this table to verify or audit the interval configurations attached to their accumulation calendars. A common reporting use case involves joining this table to the interval types and calendar tables to generate a summary of all configured period mappings for a specific operating unit. A typical SQL pattern for such validation would be:

• SELECT ccpt.cal_per_int_type_id, citb.name interval_type_name
• FROM cn_cal_per_int_types_all ccpt,
• cn_interval_types_all_b citb
• WHERE ccpt.interval_type_id = citb.interval_type_id
• AND ccpt.org_id = :p_org_id;

This data is critical for troubleshooting calculation errors related to period boundaries, ensuring that transactions are accumulated into the correct commission period.

Related Objects

The table CN_CAL_PER_INT_TYPES_ALL has documented relationships with several key objects in the Incentive Compensation schema, as indicated by its primary and foreign key constraints.

• Primary Key: The table is uniquely identified by the constraint CN_CAL_PER_INT_TYPES_PK on the column CAL_PER_INT_TYPE_ID. This key is likely referenced by other child tables in the CN schema that require a specific calendar-period-interval mapping.
• Foreign Key (References): The table contains a foreign key where CN_CAL_PER_INT_TYPES_ALL.INTERVAL_TYPE_ID references CN_INTERVAL_TYPES_ALL_B. This relationship is essential for retrieving the descriptive name and definitional attributes of the interval type being used.

While not explicitly listed in the provided excerpt, this table is logically a child of an accumulation calendar master table and is a parent to tables that store the actual period definitions (CN_CAL_PERIODS_ALL), forming a hierarchy from Calendar -> Calendar Interval Type -> Period.