Search Results cm_alys_mst




Overview
Explore in AI Chat

Overview

The CM_ALYS_MST table is a core master data table within the Oracle E-Business Suite Process Manufacturing Financials (GMF) module. It serves as the central repository for defining and storing Cost Analysis Codes. These codes are critical for granular cost accounting and analysis in process manufacturing environments. They enable the classification and tracking of costs across various dimensions, such as by product line, cost center, project, or any other analytical segment defined by the business. The table's primary role is to provide a validated list of analysis codes that can be referenced by numerous transactional and setup tables throughout the GMF, General Ledger (GL), and Process Manufacturing (GMD/PM) modules to ensure cost data integrity and enable detailed reporting.

Key Information Stored

The table's structure is centered on the unique Cost Analysis Code. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships define its essential elements. The primary key is the COST_ANALYSIS_CODE column, which holds the unique identifier for each analysis code. Another significant column is TEXT_CODE, which forms a foreign key relationship to the CM_TEXT_HDR table. This relationship indicates that descriptive, translatable text for the analysis code is stored in a separate descriptive flexfield or text repository, a common pattern in Oracle EBS for supporting multiple languages. The table's design facilitates the enforcement of referential integrity for the analysis code across the cost management suite.

Common Use Cases and Queries

This table is primarily used in setups and inquiries related to cost accounting configuration. A common operational use case is validating a cost analysis code entered on a transaction, such as a cost component or burden detail. For reporting, it is frequently joined to transactional tables to retrieve the code description for readable output. A fundamental query involves listing all active analysis codes with their descriptions:

  • SELECT cam.cost_analysis_code, cth.description FROM gmf.cm_alys_mst cam, gmf.cm_text_hdr cth WHERE cam.text_code = cth.text_code;

Another critical use case is tracing where a specific analysis code is applied within the system, which can be performed by querying the foreign key relationships documented, such as to CM_CMPT_DTL or GL_ITEM_DTL.

Related Objects

As evidenced by the extensive foreign key list, CM_ALYS_MST is a pivotal table referenced by a wide array of objects across financial and manufacturing modules. Key dependent tables include:

This network of relationships underscores the table's integral function in linking cost analysis dimensions to financial transactions, manufacturing operations, and allocation policies.

  • 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_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: GMF_BURDEN_ASSOCIATION 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GMF_BURDEN_ASSOCIATION,  object_name:GMF_BURDEN_ASSOCIATION,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: In OPM Costing, this table is where the Percentage Burden Associations are stored. ,  implementation_dba_data: GMF.GMF_BURDEN_ASSOCIATION , 

  • Table: GMF_BURDEN_ASSOCIATION 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GMF_BURDEN_ASSOCIATION,  object_name:GMF_BURDEN_ASSOCIATION,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: In OPM Costing, this table is where the Percentage Burden Associations are stored. ,  implementation_dba_data: GMF.GMF_BURDEN_ASSOCIATION , 

  • Table: GL_ITEM_DTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ITEM_DTL,  object_name:GL_ITEM_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost component detail information for the item. Component details for the Accounting cost available in GL_ITEM_CST table. ,  implementation_dba_data: GMF.GL_ITEM_DTL , 

  • Table: GL_ITEM_DTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ITEM_DTL,  object_name:GL_ITEM_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost component detail information for the item. Component details for the Accounting cost available in GL_ITEM_CST table. ,  implementation_dba_data: GMF.GL_ITEM_DTL , 

  • 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_MTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CMPT_MTL,  object_name:CM_CMPT_MTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the item or item cost class specific material cost component and material analysis code. Used by the Actual Cost Process. ,  implementation_dba_data: GMF.CM_CMPT_MTL , 

  • Table: CM_ADJS_DTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_ADJS_DTL,  object_name:CM_ADJS_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: The Actual Cost Adjustments Details table - contains the adjustments details required and entered for cost adjustments. ,  implementation_dba_data: GMF.CM_ADJS_DTL , 

  • 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_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_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_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_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 , 

  • Table: CM_ADJS_DTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_ADJS_DTL,  object_name:CM_ADJS_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: The Actual Cost Adjustments Details table - contains the adjustments details required and entered for cost adjustments. ,  implementation_dba_data: GMF.CM_ADJS_DTL , 

  • Table: CM_CMPT_MTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CMPT_MTL,  object_name:CM_CMPT_MTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the item or item cost class specific material cost component and material analysis code. Used by the Actual Cost Process. ,  implementation_dba_data: GMF.CM_CMPT_MTL , 

  • Table: GL_PLCY_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_PLCY_MST,  object_name:GL_PLCY_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. ,  implementation_dba_data: GMF.GL_PLCY_MST , 

  • Table: GL_ALOC_BAS 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ALOC_BAS,  object_name:GL_ALOC_BAS,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the basis information for an allocation code about the items to which expenses will be allocated, the allocation criteria based upon the basis account or fixed percent, and the cost component class bucket to which the al ,  implementation_dba_data: GMF.GL_ALOC_BAS , 

  • Table: GL_ALOC_BAS 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ALOC_BAS,  object_name:GL_ALOC_BAS,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the basis information for an allocation code about the items to which expenses will be allocated, the allocation criteria based upon the basis account or fixed percent, and the cost component class bucket to which the al ,  implementation_dba_data: GMF.GL_ALOC_BAS , 

  • 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_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: GL_ACCT_MAP 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MAP,  object_name:GL_ACCT_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU ,  implementation_dba_data: GMF.GL_ACCT_MAP , 

  • Table: GL_PLCY_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_PLCY_MST,  object_name:GL_PLCY_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. ,  implementation_dba_data: GMF.GL_PLCY_MST , 

  • Table: GL_ACCT_MAP 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MAP,  object_name:GL_ACCT_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU ,  implementation_dba_data: GMF.GL_ACCT_MAP ,