Search Results cm_cmpt_dtl

The CM_CMPT_DTL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Compensation Management module. This table stores detailed compensation-related data, serving as a transactional repository for compensation plan components, calculations, and adjustments. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.

Table Overview

The CM_CMPT_DTL table is part of the Compensation Management schema, which facilitates the administration of incentive compensation plans for employees, sales representatives, or partners. It captures granular details of compensation components, such as commissions, bonuses, or performance-based payouts, ensuring accurate and auditable calculations.

Key Columns and Data Structure

The table includes columns such as:

CMPT_DTL_ID: Primary key, uniquely identifying each compensation detail record.
CMPT_ID: Foreign key linking to the parent compensation record in the CM_CMPT table.
PLAN_ID: References the compensation plan from CM_PLANS.
COMPONENT_ID: Identifies the compensation component (e.g., commission rate, bonus tier).
AMOUNT: Stores the calculated or adjusted monetary value.
CALCULATION_DATE: Timestamp of when the compensation was computed.
STATUS: Indicates the record's status (e.g., "Pending," "Approved," "Paid").
LAST_UPDATE_DATE and LAST_UPDATED_BY: Audit columns for tracking changes.

Functional Role

The CM_CMPT_DTL table supports:

Compensation Calculations: Stores intermediate and final results of compensation computations, including splits, overrides, or prorations.
Adjustments: Captures manual adjustments to compensation, such as disputes or corrections.
Audit and Compliance: Provides a trail for regulatory audits and internal reviews.
Integration: Interfaces with payroll (e.g., Oracle Payroll) and general ledger (e.g., Oracle GL) modules for disbursements and accounting.

Integration with Other Modules

The table interacts with:

CM_PLANS: Defines compensation plan rules referenced by CMPT_DTL.
HR_EMPLOYEES: Links compensation details to employee records.
AP_INVOICES or AR_TRANSACTIONS: For sales-driven compensation tied to invoices or revenue.

Technical Considerations

In EBS 12.2.2, the table may leverage Oracle's Online Patching (ADOP) for maintenance. Indexes on CMPT_ID and PLAN_ID optimize query performance, especially for large datasets. Customizations often extend the table via descriptive flexfields (DFFs).

Conclusion

The CM_CMPT_DTL table is a foundational element in Oracle EBS Compensation Management, ensuring accurate, traceable, and flexible compensation processing. Its design reflects Oracle's emphasis on scalability and compliance, making it indispensable for organizations with complex incentive structures.

Table: CM_CMPT_DTL 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CMPT_DTL, object_name:CM_CMPT_DTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Component Details , implementation_dba_data: GMF.CM_CMPT_DTL ,
Table: CM_CMPT_DTL 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CMPT_DTL, object_name:CM_CMPT_DTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Component Details , implementation_dba_data: GMF.CM_CMPT_DTL ,
Table: CM_CMPT_DTL_EFC 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CMPT_DTL_EFC, object_name:CM_CMPT_DTL_EFC, status:VALID, product: GMF - Process Manufacturing Financials , description: Shadow table of CM_CMPT_DTL for EFC migration. Stores the original values of columns of CM_CMPT_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_CMPT_DTL and , implementation_dba_data: GMF.CM_CMPT_DTL_EFC ,
Table: CM_CMPT_DTL_EFC 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CMPT_DTL_EFC, object_name:CM_CMPT_DTL_EFC, status:VALID, product: GMF - Process Manufacturing Financials , description: Shadow table of CM_CMPT_DTL for EFC migration. Stores the original values of columns of CM_CMPT_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_CMPT_DTL and , implementation_dba_data: GMF.CM_CMPT_DTL_EFC ,
View: CM_CMPT_DTL_VW1 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:GMF.CM_CMPT_DTL_VW1, object_name:CM_CMPT_DTL_VW1, status:VALID, product: GMF - Process Manufacturing Financials , description: View on cm_cmpt_dtl , implementation_dba_data: APPS.CM_CMPT_DTL_VW1 ,
View: CM_CMPT_DTL_VW1 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:GMF.CM_CMPT_DTL_VW1, object_name:CM_CMPT_DTL_VW1, status:VALID, product: GMF - Process Manufacturing Financials , description: View on cm_cmpt_dtl , implementation_dba_data: APPS.CM_CMPT_DTL_VW1 ,
View: CM_CMPT_DTL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:GMF.CM_CMPT_DTL_V, object_name:CM_CMPT_DTL_V, status:VALID, product: GMF - Process Manufacturing Financials , description: View to enable master-detail relationship on Cost Details form , implementation_dba_data: APPS.CM_CMPT_DTL_V ,
View: CM_CMPT_DTL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:GMF.CM_CMPT_DTL_V, object_name:CM_CMPT_DTL_V, status:VALID, product: GMF - Process Manufacturing Financials , description: View to enable master-detail relationship on Cost Details form , implementation_dba_data: APPS.CM_CMPT_DTL_V ,
Table: CM_CMPT_MST 12.1.1
product: GMF - Process Manufacturing Financials , description: Cost Component Master , implementation_dba_data: Not implemented in this database ,
Table: CM_ACST_LED 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_ACST_LED, object_name:CM_ACST_LED, status:VALID, product: GMF - Process Manufacturing Financials , description: Actual Costing Ledger Table. The purpose of this table is to serve as a depository of all actual costing transactions. These transactions may originate from Production Batch details (pm_matl_dtl) or POC resource details (pm_oprn_dtl) or Pu , implementation_dba_data: GMF.CM_ACST_LED ,
Table: CM_CMPT_MST_B 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CMPT_MST_B, object_name:CM_CMPT_MST_B, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Component Master , implementation_dba_data: GMF.CM_CMPT_MST_B ,
Table: CM_CMPT_MST_B 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CMPT_MST_B, object_name:CM_CMPT_MST_B, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Component Master , implementation_dba_data: GMF.CM_CMPT_MST_B ,
Table: CM_SCST_LED 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_SCST_LED, object_name:CM_SCST_LED, status:VALID, product: GMF - Process Manufacturing Financials , description: Standard Costs Ledger. Rows are created during the cost rollup process. It serves the purpose of a ledger on the performed cost calculations of each product. Formula and routing information is maintained within this table. Has a detailed , implementation_dba_data: GMF.CM_SCST_LED ,
Table: CM_ACPR_CTL 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_ACPR_CTL, object_name:CM_ACPR_CTL, status:VALID, product: GMF - Process Manufacturing Financials , description: The Actual Cost Process Control Table will allow the OPM user to communicate with the Actual Cost Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to a , implementation_dba_data: GMF.CM_ACPR_CTL ,
Table: CM_CMPT_MST 12.2.2
product: GMF - Process Manufacturing Financials , description: Cost Component Master , implementation_dba_data: Not implemented in this database ,
Table: CM_ALYS_MST 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_ALYS_MST, object_name:CM_ALYS_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Analysis Code Master Table. , implementation_dba_data: GMF.CM_ALYS_MST ,
Table: CM_ALYS_MST 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_ALYS_MST, object_name:CM_ALYS_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Analysis Code Master Table. , implementation_dba_data: GMF.CM_ALYS_MST ,
Table: CM_CLDR_DTL 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CLDR_DTL, object_name:CM_CLDR_DTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Costing Calendar Details , implementation_dba_data: GMF.CM_CLDR_DTL ,
Table: CM_ACST_LED 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_ACST_LED, object_name:CM_ACST_LED, status:VALID, product: GMF - Process Manufacturing Financials , description: Actual Costing Ledger Table. The purpose of this table is to serve as a depository of all actual costing transactions. These transactions may originate from Production Batch details (pm_matl_dtl) or POC resource details (pm_oprn_dtl) or Pu , implementation_dba_data: GMF.CM_ACST_LED ,
Table: CM_SCST_LED 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_SCST_LED, object_name:CM_SCST_LED, status:VALID, product: GMF - Process Manufacturing Financials , description: Standard Costs Ledger. Rows are created during the cost rollup process. It serves the purpose of a ledger on the performed cost calculations of each product. Formula and routing information is maintained within this table. Has a detailed , implementation_dba_data: GMF.CM_SCST_LED ,
Table: CM_RLUP_CTL 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_RLUP_CTL, object_name:CM_RLUP_CTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Rollup Process Control Table - allows the OPM user to communicate with the Cost Rollup Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort. , implementation_dba_data: GMF.CM_RLUP_CTL ,
View: CM_CMPT_DTL_VW 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:GMF.CM_CMPT_DTL_VW, object_name:CM_CMPT_DTL_VW, status:VALID, product: GMF - Process Manufacturing Financials , description: View of TOTAL_COST , implementation_dba_data: APPS.CM_CMPT_DTL_VW ,
Table: CM_ACPR_CTL 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_ACPR_CTL, object_name:CM_ACPR_CTL, status:VALID, product: GMF - Process Manufacturing Financials , description: The Actual Cost Process Control Table will allow the OPM user to communicate with the Actual Cost Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to a , implementation_dba_data: GMF.CM_ACPR_CTL ,
Table: CM_TEXT_HDR 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_TEXT_HDR, object_name:CM_TEXT_HDR, status:VALID, product: GMF - Process Manufacturing Financials , description: Header information for Text entered through Edit Text option , implementation_dba_data: GMF.CM_TEXT_HDR ,
Table: CM_CLDR_DTL 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_CLDR_DTL, object_name:CM_CLDR_DTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Costing Calendar Details , implementation_dba_data: GMF.CM_CLDR_DTL ,
Table: CM_BRDN_DTL 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_BRDN_DTL, object_name:CM_BRDN_DTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Burden Details - contains the Burden (Overhead) costs applied to an item , implementation_dba_data: GMF.CM_BRDN_DTL ,
Table: CM_MTHD_MST 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_MTHD_MST, object_name:CM_MTHD_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: Item Cost Methods - Cost methods are defined by the user. Cost calculation types for raw material and product costs are also specified for Actual Costing Methods. , implementation_dba_data: GMF.CM_MTHD_MST ,
Table: CM_MTHD_MST 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_MTHD_MST, object_name:CM_MTHD_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: Item Cost Methods - Cost methods are defined by the user. Cost calculation types for raw material and product costs are also specified for Actual Costing Methods. , implementation_dba_data: GMF.CM_MTHD_MST ,
Table: CM_TEXT_HDR 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_TEXT_HDR, object_name:CM_TEXT_HDR, status:VALID, product: GMF - Process Manufacturing Financials , description: Header information for Text entered through Edit Text option , implementation_dba_data: GMF.CM_TEXT_HDR ,
Table: CM_RLUP_CTL 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_RLUP_CTL, object_name:CM_RLUP_CTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Rollup Process Control Table - allows the OPM user to communicate with the Cost Rollup Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort. , implementation_dba_data: GMF.CM_RLUP_CTL ,
Table: CM_BRDN_DTL 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.CM_BRDN_DTL, object_name:CM_BRDN_DTL, status:VALID, product: GMF - Process Manufacturing Financials , description: Cost Burden Details - contains the Burden (Overhead) costs applied to an item , implementation_dba_data: GMF.CM_BRDN_DTL ,
View: CM_CMPT_DTL_VW 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:GMF.CM_CMPT_DTL_VW, object_name:CM_CMPT_DTL_VW, status:VALID, product: GMF - Process Manufacturing Financials , description: View of TOTAL_COST , implementation_dba_data: APPS.CM_CMPT_DTL_VW ,