Results for “primary_resource”

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

Overview

FM_ARES_MST is a Process Manufacturing Product Development (GMD) table that stores operation-specific alternate resource factors. In Oracle EBS 12.1.1 and 12.2.2, it defines the conversion factors applied when an alternate resource is substituted for a primary resource at a specific routing operation. Because a single operation may permit several resource substitutions, each with distinct consumption, run-time, and post-operation behavior, this table acts as the junction between operations and the resource master, carrying the quantitative factors that drive costing, scheduling, and capacity planning.

Under the heuristic Data Vault classification mined from its foreign key structure, FM_ARES_MST is best modeled as a link. Its composite primary key draws together three distinct business keys — the operation, the primary resource, and the alternate resource — and the surrounding factor columns behave as link-level descriptive attributes rather than a standalone hub or satellite.

Key Information Stored

• OPRN_ID — Identifies the routing operation to which the alternate resource substitution applies. Part of the composite primary key and the primary driver for most operational queries.
• PRIMARY_RESOURCE — The resource normally consumed by the operation; references the resource master.
• ALTERNATE_RESOURCE — The substitute resource permitted in place of the primary resource; also references the resource master.
• SETUP_FACTOR — Multiplier applied to setup time or quantity when the alternate resource is used.
• RUNTIME_FACTOR — Multiplier applied to run time or run quantity for the alternate resource.
• POSTOP_FACTOR — Multiplier applied to post-operation activity for the alternate resource.
• TEXT_CODE — Foreign key to FM_TEXT_HDR, linking the substitution to supplementary descriptive text.
• TRANS_CNT — Transaction counter used for concurrency and propagation control.
• DELETE_MARK — Logical delete flag; rows are marked inactive rather than physically removed.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified the substitution record.

The surrogate-level unique index FM_ARES_MST_PK is defined on (OPRN_ID, PRIMARY_RESOURCE, ALTERNATE_RESOURCE). This composite index is the business-key candidate: it guarantees that only one factor set exists per operation and resource pairing. No separate single-column surrogate key is documented; the primary key is itself the natural business key.

Common Use Cases and Queries

The most frequent use case is retrieving the factor set for a resource substitution on a given operation during cost rollup or capacity scheduling. A typical pattern joins the table to resource master for descriptive names:

• List all alternate resources defined for a specific operation: SELECT alternate_resource, setup_factor, runtime_factor FROM fm_ares_mst WHERE oprn_id = :oprn_id AND delete_mark = 0;
• Reverse lookup — identify every operation where a given resource is used as an alternate: filter on ALTERNATE_RESOURCE.
• Validate factor completeness before a cost rollup by counting rows per OPRN_ID.
• Audit trailing changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Reconcile active versus logically deleted substitutions with DELETE_MARK.

Related Objects

• CR_RSRC_MST_B — joined on PRIMARY_RESOURCE and ALTERNATE_RESOURCE for base resource records.
• CR_RSRC_MST — joined on PRIMARY_RESOURCE and ALTERNATE_RESOURCE for translated resource definitions; provides language-specific resource attributes.
• FM_TEXT_HDR — joined on TEXT_CODE for supplementary narrative text.
• Operations/routing tables — OPRN_ID resolves to the operation definition that owns the substitution.
• Costing and resource-usage objects — consume SETUP_FACTOR, RUNTIME_FACTOR, and POSTOP_FACTOR during rollup.