Results for “fm_actv_mst”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FM_ACTV_MST is the Activity Master table within the Oracle EBS Process Manufacturing Product Development (GMD) module. It defines the discrete activities that are performed within manufacturing operations, serving as the master repository from which operation-level activity assignments are derived. In the Process Manufacturing model, an operation represents a unit of production work, and each operation is composed of one or more activities. FM_ACTV_MST provides the standardized catalog of those activities, ensuring consistent reuse of activity definitions across operations and recipes.

From a Data Vault modeling perspective, the heuristic classification assigned to this object is satellite-leaning. This suggests the table behaves primarily as a descriptive attribute store attached to a business key, rather than as a pure hub or a link resolving many-to-many relationships. The single natural business key, ACTIVITY, reinforces this reading: the table's identity is anchored to one business concept, with descriptive columns hanging off it. Note that the metadata records this table as "Not implemented in this database," meaning the object may exist only in certain installations or may have been superseded in the specific environment examined.

Key Information Stored

The table is keyed by the FM_ACTV_MST_PK primary key, defined on the ACTIVITY column. ACTIVITY is simultaneously the surrogate primary key and the business-key candidate, since it uniquely identifies each activity definition and is referenced by downstream operation detail tables. Other significant columns documented in the metadata include:

• ACTIVITY — Primary key; the unique identifier/name of the activity.
• COST_ANALYSIS_CODE — Foreign key to CM_ALYS_MST, linking the activity to its cost analysis definition. This column is central to the query the user searched ("cm_alys_mst"), as it forms the join path between activities and cost analysis masters.
• TEXT_CODE — Foreign key to FM_TEXT_HDR, associating the activity with a text header record for descriptive or instructional content.

Additional descriptive attributes typically present in activity master tables include activity descriptions, status flags, and usage indicators, though only the columns appearing in the documented FK/PK metadata are named here to avoid speculation.

Common Use Cases and Queries

The most frequent use case is resolving activity definitions to their associated cost analysis records. A representative join follows:

• SELECT a.ACTIVITY, c.COST_ANALYSIS_CODE FROM FM_ACTV_MST a, CM_ALYS_MST c WHERE a.COST_ANALYSIS_CODE = c.COST_ANALYSIS_CODE;

Another common pattern discovers which operations use a given activity by joining upward through the referencing tables:

• SELECT o.ACTIVITY, o.OPERATION FROM FM_OPRN_DTL o WHERE o.ACTIVITY = :activity;

Reporting scenarios include activity usage audits (identifying orphaned or unused activities), cost rollup analysis by tracing ACTIVITY to CM_ALYS_MST, and text content retrieval by joining TEXT_CODE to FM_TEXT_HDR. The table also supports data-conversion validation, confirming that every activity referenced by FM_OPRN_DTL and PM_OPRN_DTL exists in the master.

Related Objects

FM_ACTV_MST sits at the intersection of several Process Manufacturing objects. The most significant are:

• CM_ALYS_MST — Cost analysis master; joined via FM_ACTV_MST.COST_ANALYSIS_CODE. This is the object the user searched for, and it is the primary outbound FK relationship.
• FM_TEXT_HDR — Text header; joined via FM_ACTV_MST.TEXT_CODE to retrieve descriptive text.
• FM_OPRN_DTL — Formula/operation detail; references FM_ACTV_MST.ACTIVITY, defining activities performed in an operation.
• PM_OPRN_DTL — Process operation detail; also references FM_ACTV_MST.ACTIVITY, providing a parallel usage path in the production model.

Together these relationships establish FM_ACTV_MST as the authoritative source for activity definitions consumed by both formula and production operation detail records, with cost analysis and text headers supplying supplementary descriptive context.