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.