Search Results fm_actv_mst




Overview
Explore in AI Chat

Overview

The FM_ACTV_MST table is a master data table within the Oracle E-Business Suite Process Manufacturing (GMD) product development module. It serves as the central repository for defining activities, which are discrete tasks or steps performed within manufacturing operations. In the context of Process Manufacturing, operations are often complex and can be broken down into constituent activities for detailed planning, costing, and execution tracking. This table provides the standardized list of these activities that can be consistently referenced across formulas, recipes, and routing instructions, ensuring operational consistency and data integrity.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the structure and foreign key relationships indicate the core data elements. The primary identifier is the ACTIVITY column, which is the unique code for the activity. Based on standard Oracle EBS patterns and the foreign keys, other critical columns likely include a description field, the COST_ANALYSIS_CODE for linking to cost accounting setups, and a TEXT_CODE for associating descriptive notes or instructions stored in the FM_TEXT_HDR table. The table's primary key constraint, FM_ACTV_MST_PK, is enforced on the ACTIVITY column.

Common Use Cases and Queries

The primary use case is the setup and maintenance of the activity library used in defining process operations. Common queries involve listing available activities for assignment or validating activity codes. For instance, a query to retrieve all activities with their associated cost analysis code would be fundamental for cost model configuration. When troubleshooting data issues, one might join FM_ACTV_MST to FM_OPRN_DTL to find all operations that use a specific activity. A typical reporting pattern is to aggregate resource usage or time standards by activity across multiple recipes. It is crucial to note the ETRM's "Implementation/DBA Data" states "Not implemented in this database," which may indicate the table is not present in a standard installation or requires a specific configuration; any direct query should first verify the table's existence.

Related Objects

  • FM_OPRN_DTL & PM_OPRN_DTL: These are the primary child tables. They reference FM_ACTV_MST.ACTIVITY to specify which activities are performed within an operation detail line for formulas (FM) and process plans (PM), respectively.
  • CM_ALYS_MST: The Cost Management analysis master table. The foreign key from FM_ACTV_MST.COST_ANALYSIS_CODE links an activity to a specific cost analysis code, integrating process steps with financial costing models.
  • FM_TEXT_HDR: Stores descriptive text blocks. The TEXT_CODE foreign key allows extensive instructions or notes to be attached to an activity definition.