Results for “bom_shift_times”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BOM.BOM_SHIFT_TIMES is a Bills of Material (BOM) module table that stores the shift-time definitions belonging to workday calendars in Oracle E-Business Suite 12.1.1 and 12.2.2. Within EBS manufacturing, a calendar defines the working and non-working days of a facility or resource, and each calendar is further subdivided into shifts. BOM_SHIFT_TIMES captures the concrete start and end times of each shift, and therefore provides the finest level of granularity in the shop-floor calendar model. Capacity planning, resource scheduling, and workday calculation logic rely on this table to determine exactly when production time is available.
From a Data Vault modeling perspective, the ETRM metadata classifies this object heuristically as satellite-leaning. This is consistent with its role as a descriptive detail table attached to a parent business key: the calendar shift combination behaves as the parent entity, while BOM_SHIFT_TIMES holds the time-bound descriptive attributes for that entity.
Key Information Stored
The table is organized around a composite primary key, BOM_SHIFT_TIMES_PK, defined over CALENDAR_CODE, SHIFT_NUM, FROM_TIME, and TO_TIME. These same four columns also constitute the unique index BOM_SHIFT_TIMES_U1, making them the business-key candidate for the row. The practical implication is that a given calendar and shift number may span multiple rows, since the time boundaries participate in the key.
- CALENDAR_CODE — Identifies the workday calendar to which the shift belongs. This is the foreign key linking to BOM_CALENDAR_SHIFTS and the primary business identifier for reporting.
- SHIFT_NUM — The ordinal number of the shift within the calendar (for example, first, second, or third shift).
- FROM_TIME and TO_TIME — The start and end times of the shift interval. Together with the preceding columns these form the unique business key, allowing shifts to be defined across time segments.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified the row and when.
- REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program tracking columns identifying the request and program that last populated or updated the record.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) columns, providing fifteen free-form segments for customer-specific extensions.
Common Use Cases and Queries
Typical uses include shop-floor calendar reporting, shift pattern validation, and integration of manufacturing calendars into capacity and scheduling solutions. A simple listing of shifts for a calendar can be produced as follows:
SELECT shift_num, from_time, to_time FROM bom.bom_shift_times WHERE calendar_code = :calendar_code ORDER BY shift_num, from_time;
To reconcile shift times with their parent shift definitions, join to BOM_CALENDAR_SHIFTS on both CALENDAR_CODE and SHIFT_NUM. Analysts frequently combine this table with the broader BOM calendar tables to calculate total available production hours per shift or per calendar, supporting rough-cut capacity planning and detailed scheduling. Because the DFF columns are present, customer-specific reporting may also filter on ATTRIBUTE_CATEGORY and individual ATTRIBUTE segments.
Related Objects
- BOM_CALENDAR_SHIFTS — The parent table. Joined on BOM_SHIFT_TIMES.CALENDAR_CODE = BOM_CALENDAR_SHIFTS.CALENDAR_CODE and BOM_SHIFT_TIMES.SHIFT_NUM = BOM_CALENDAR_SHIFTS.SHIFT_NUM. This is the documented foreign key relationship.
- BOM_CALENDARS / BOM_CALENDAR_DATES — Define the workday calendar header and its working/non-working dates, providing the calendar context above the shift level.
- BOM_RESOURCES and BOM_RESOURCE_SHIFTS — Resource definitions and their shift assignments, which reference calendar shifts when computing available resource capacity.
- BOM_DEPARTMENTS and BOM_DEPARTMENT_RESOURCES — Departmental and resource associations that consume calendar shift data for scheduling.
- BOM_ROUTINGS / BOM_OPERATION_SEQUENCES — Routing operations scheduled against calendar shifts to determine production start and completion times.
Together these objects form the manufacturing calendar and scheduling hierarchy in which BOM_SHIFT_TIMES supplies the precise time-of-day detail.
-
Workday calendar shift times
-
Workday calendar shift times
-
TABLE: BOM.BOM_SHIFT_TIMES 12.2.2
-
TABLE: BOM.BOM_SHIFT_TIMES 12.1.1