Search Results cn_credit_types_all_b




Overview
Explore in AI Chat

Overview

The CN_CREDIT_TYPES_ALL_B table is a core master data table within the Oracle E-Business Suite Incentive Compensation (CN) module. It serves as the central repository for defining and managing all credit types used in the compensation planning and calculation processes. A credit type is a fundamental classification for the credits (e.g., revenue, units, margin) that sales representatives earn, which are then aggregated and converted according to compensation plans to determine payments. The table's multi-org structure, indicated by the '_ALL_B' suffix and the ORG_ID column, supports the definition of both global and operating unit-specific credit types, enabling flexible deployment across complex enterprise structures.

Key Information Stored

The table's primary identifier is the system-generated CREDIT_TYPE_ID, which is used throughout the CN schema to reference a specific credit type definition. The ORG_ID column stores the operating unit identifier, enforcing data security and partitioning. While the provided ETRM excerpt does not list descriptive columns, standard practice for such master tables includes columns for the credit type name (e.g., NAME), a description, status flags (like ACTIVE), and standard Oracle EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The existence of a unique key on (CREDIT_TYPE_ID, ORG_ID) ensures uniqueness within the multi-org framework.

Common Use Cases and Queries

This table is primarily referenced for setup validation, data integrity checks, and reporting on compensation structures. Common operational queries include listing all active credit types for a specific operating unit, validating credit type IDs during data imports, and analyzing which credit types are associated with active payment plans. A typical query pattern involves joining to the transactional tables that reference CREDIT_TYPE_ID. For example, to report on all payment plans using a specific credit type, one would join CN_PMT_PLANS_ALL to CN_CREDIT_TYPES_ALL_B. Administrators frequently query this table to ensure credit types are correctly configured before running critical processes like payrun calculations, which depend on valid credit type conversions defined in related tables.

Related Objects

The CN_CREDIT_TYPES_ALL_B table has extensive relationships with key transactional and setup tables in the Incentive Compensation module, as documented by its foreign key constraints. The primary relationships are as follows:

  • CN_CREDIT_CONV_FCTS_ALL: References this table twice, for FROM_CREDIT_TYPE_ID and TO_CREDIT_TYPE_ID, defining conversion rules between different credit types.
  • CN_PAYRUNS_ALL: References this table for FROM_CREDIT_TYPE_ID and TO_CREDIT_TYPE_ID, specifying the conversion for a specific compensation calculation run.
  • CN_PMT_PLANS_ALL: Links via CREDIT_TYPE_ID, defining the default credit type for a payment plan.
  • CN_QUOTAS_ALL: Links via CREDIT_TYPE_ID, associating a sales target or quota with a specific type of credit.
  • CN_POSTING_DETAILS_ALL: Links via CREDIT_TYPE_ID, storing the detailed credit transactions posted for representatives.
  • CN_PAYMENT_WORKSHEETS_ALL: References CONVERT_TO_TYPE_ID, indicating the target credit type for worksheet conversions.
  • CN_SRP_PERIODS_ALL: Links via CREDIT_TYPE_ID, likely defining the primary credit type for a salesperson's compensation period.