Search Results credit_conv_fct_id

Overview

The table CN_CREDIT_CONV_FCTS_ALL is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation module (CN). It serves as the master repository for defining conversion factors between different credit types. In the context of calculating commissions and incentives, sales transactions or performance metrics are often tracked using various credit types (e.g., units sold, revenue amount, points). This table enables the system to translate credits from one type to another using a defined conversion ratio, which is essential for consolidating disparate performance measures into a standardized unit for accurate compensation calculations and performance reporting.

Key Information Stored

The table's primary purpose is to store the relationship and conversion factor between a source and a target credit type. Its key columns, as indicated by its primary and foreign key structure, include the unique identifier CREDIT_CONV_FCT_ID. Crucially, it stores FROM_CREDIT_TYPE_ID and TO_CREDIT_TYPE_ID, which are foreign keys referencing the CN_CREDIT_TYPES_ALL_B table. These columns define the specific credit types involved in the conversion. While the explicit metadata does not list the conversion factor column, standard implementation dictates the presence of a column (often named CONVERSION_FACTOR or similar) that holds the numerical multiplier used to convert a quantity from the "from" credit type to the "to" credit type (e.g., 1 Revenue Dollar = 10 Points). The table also standardly includes Oracle EBS audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY.

Common Use Cases and Queries

A primary use case is during the payment worksheet generation process, where transaction credits of various types must be converted to a common credit type for payout calculation. For instance, if a plan pays based on "Standard Points," but transactions are recorded as "Revenue," the system queries this table to find the applicable conversion factor. Common reporting queries involve joining this table to credit type descriptions to create readable conversion lists. A sample query pattern is:

• SELECT from_ct.name FROM_CREDIT_TYPE, to_ct.name TO_CREDIT_TYPE, ccf.conversion_factor
• FROM cn_credit_conv_fcts_all ccf,
• cn_credit_types_all_b from_ct,
• cn_credit_types_all_b to_ct
• WHERE ccf.from_credit_type_id = from_ct.credit_type_id
• AND ccf.to_credit_type_id = to_ct.credit_type_id;

Administrators also frequently query this table to validate or audit conversion rules applied in finalized payment worksheets.

Related Objects

The table maintains defined relationships with several other key Incentive Compensation tables, as documented in the provided metadata:

• Primary Key: The table is uniquely identified by CN_CREDIT_CONV_FCTS_PK on the CREDIT_CONV_FCT_ID column.
• Foreign Key References (Parent Tables): It has two foreign key relationships to the CN_CREDIT_TYPES_ALL_B table, which defines valid credit types.
  • Column FROM_CREDIT_TYPE_ID references CN_CREDIT_TYPES_ALL_B.
  • Column TO_CREDIT_TYPE_ID references CN_CREDIT_TYPES_ALL_B.
• Foreign Key Reference (Child Table): The CN_PAYMENT_WORKSHEETS_ALL table references this table via a foreign key.
  • Column CN_PAYMENT_WORKSHEETS_ALL.CREDIT_CONV_FCT_ID references CN_CREDIT_CONV_FCTS_ALL. This links specific payment worksheet lines to the conversion factor that was applied.