Results for “runtime_factor”

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

Overview

CR_ARES_MST is an Oracle EBS Process Manufacturing (GMP) reference table that defines alternate resource relationships in Process Planning. It resides in the GMP schema and stores the substitution mappings that allow one production resource to be swapped for another during capacity planning, scheduling, and resource assignment. Each row establishes a primary-to-alternate resource association, together with the conversion factors that govern how runtime, setup, and post-operation effort scales when the substitution is applied.

From a data modeling perspective, the FK structure suggests this object behaves as a link (associative) table rather than a hub or satellite. Its primary key is composed entirely of two foreign-key columns — PRIMARY_RESOURCE and ALTERNATE_RESOURCE — which is the classic signature of a many-to-many junction between resource entities. The remaining columns carry descriptive and transactional attributes that qualify the relationship itself (factors, preference, audit columns), which is characteristic of link-attribute modeling.

Key Information Stored

The table contains 14 documented columns. The most significant are:

• PRIMARY_RESOURCE — the originating resource in the substitution pair; part of the composite primary key and a foreign key to resource master tables.
• ALTERNATE_RESOURCE — the substitute resource; also part of the composite key and a foreign key to the same resource masters.
• SETUP_FACTOR — multiplier applied to setup time when the alternate resource is used in place of the primary.
• RUNTIME_FACTOR — multiplier applied to run time for the substitution.
• POSTOP_FACTOR — multiplier applied to post-operation time.
• PREFERENCE — priority ranking that determines which alternate is selected when several substitutions qualify.
• TEXT_CODE — foreign key to CR_TEXT_HDR, carrying descriptive text associated with the relationship.
• DELETE_MARK — soft-delete indicator; rows are deactivated rather than physically removed.
• TRANS_CNT — transaction counter used for concurrency and change tracking.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

The surrogate identity of a row is defined by the composite unique index CR_ARES_MST_PK (PRIMARY_RESOURCE, ALTERNATE_RESOURCE). Because the PK is built directly from business columns, there is no separate system-generated surrogate; the business-key candidate and the primary key coincide. Queries referencing cr_ares_mst_pk therefore key on the resource pair itself.

Common Use Cases and Queries

Typical scenarios include determining valid alternates for a resource, comparing factor impacts on capacity, and validating that substitution rules exist before executing a plan.

• Retrieve all alternates for a given primary resource, ordered by preference:

SELECT alternate_resource, setup_factor, runtime_factor, postop_factor
FROM   gmp.cr_ares_mst
WHERE  primary_resource = :primary_resource
AND    delete_mark = 0
ORDER BY preference;

• Compute adjusted capacity by applying the runtime factor to planned hours.
• Join to resource master tables to resolve resource descriptions for reporting.
• Extract substitution rules for migration, auditing, or load into planning simulations.

Related Objects

The FK metadata identifies the principal related objects:

• CR_RSRC_MST_B — resource base master; referenced by both PRIMARY_RESOURCE and ALTERNATE_RESOURCE.
• CR_RSRC_MST — resource master (translated view); also referenced by both resource columns.
• CR_TEXT_HDR — text header, referenced through TEXT_CODE.

These join relationships make CR_ARES_MST the bridge that ties resource definitions to their permissible substitutions within the Process Planning module.