Results for “batch_window”

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

Overview

GMP.CR_RSRC_DTL is a table within the Oracle E-Business Suite Process Manufacturing Process Planning (GMP) module. It stores plant-specific resource information, extending the master resource definitions held in the CR_RSRC_MST and CR_RSRC_MST_B tables with data that varies by manufacturing plant or organization. In Oracle EBS 12.1.1 and 12.2.2, this table forms part of the capacity and resource planning infrastructure that supports constraint-based scheduling, resource availability calculations, and production planning across discrete plant locations.

Based on the heuristic Data Vault classification mined from its foreign key structure, this table is satellite-leaning. This suggests a modeling approach in which CR_RSRC_DTL functions primarily as a descriptive satellite attached to the resource master hub (CR_RSRC_MST / CR_RSRC_MST_B), carrying plant-contextual attributes and effectively keyed by the combination of organization and resource. Its dual unique index structure — CR_RSRC_DTL_PK on RESOURCE_ID and CR_RSRC_DTL_I1 on (ORGN_CODE, RESOURCES) — reflects this satellite-style relationship, anchoring each row to a specific plant-resource pairing.

Key Information Stored

The table contains 36 documented columns. The most functionally significant include:

• RESOURCE_ID — The surrogate primary key value identifying each row; referenced by downstream dependent tables.
• ORGN_CODE and RESOURCES — Together these form the business-key candidate (unique index CR_RSRC_DTL_I1), linking a resource to its owning plant/organization.
• GROUP_RESOURCE — Associates the detail record with a parent or grouped resource definition.
• ASSIGNED_QTY and DAILY_AVAIL_USE — Express the quantity assigned to the resource and its daily available usage.
• USAGE_UM and USAGE_UOM — The unit of measure governing usage quantities.
• NOMINAL_COST — The standard or nominal cost attributed to the resource at this plant.
• IDEAL_CAPACITY, MIN_CAPACITY, MAX_CAPACITY — Capacity thresholds driving scheduling decisions.
• CAPACITY_UOM / CAPACITY_UM — The unit of measure for capacity figures.
• CAPACITY_CONSTRAINT and CAPACITY_TOLERANCE — Flags and tolerances controlling how capacity limits are enforced.
• UTILIZATION, EFFICIENCY, SCHEDULE_IND — Planning factors influencing effective throughput.
• CALENDAR_CODE — References the work calendar governing resource availability windows.
• BATCHABLE_FLAG, BATCH_WINDOW, BATCH_WINDOW_UOM — Indicate whether the resource supports batching and define its batch window.
• INACTIVE_IND and DELETE_MARK — Standard Oracle soft-delete and active-status indicators.

Standard EBS WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, TRANS_CNT) are also present.

Common Use Cases and Queries

Typical usage centers on capacity planning, resource availability reporting, and cost analysis by plant. A representative query joining to the resource master and organization master follows:

SELECT d.ORGN_CODE, d.RESOURCES, d.IDEAL_CAPACITY,
       d.MAX_CAPACITY, d.UTILIZATION, d.EFFICIENCY,
       d.NOMINAL_COST
FROM   GMP.CR_RSRC_DTL d
WHERE  d.ORGN_CODE = :plant
AND    NVL(d.INACTIVE_IND,'N') = 'N';

Reporting scenarios include identifying resources exceeding capacity tolerance, listing inactive resources by plant, and reconciling nominal costs against planned utilization. Exception and unavailability analysis commonly joins this table to GMP_RSRC_EXCP_ASNMT and GMP_RSRC_UNAVAIL_MAN on RESOURCE_ID.

Related Objects

The following objects are most significant to CR_RSRC_DTL through documented foreign key relationships:

• CR_RSRC_MST and CR_RSRC_MST_B — Master resource definitions, joined on RESOURCES and GROUP_RESOURCE.
• SY_ORGN_MST and SY_ORGN_MST_B — Organization master, joined on ORGN_CODE.
• SY_UOMS_MST — Unit-of-measure master, joined on USAGE_UM.
• CR_TEXT_HDR — Text header reference, joined on TEXT_CODE.
• GMP_PLANT_RSRC_PARAMETERS — Plant resource parameters, referencing RESOURCE_ID.
• GMP_RSRC_EXCP_ASNMT — Resource exception assignments, referencing RESOURCE_ID.
• GMP_RSRC_UNAVAIL_MAN — Resource unavailability records, referencing RESOURCE_ID.