Results for “wip_schedule_groups_pk”

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

Overview

WIP_SCHEDULE_GROUPS is a Work in Process (WIP) base table that stores discrete job schedule groups. In Oracle EBS 12.1.1 and 12.2.2, schedule groups provide a means of logically partitioning and organizing discrete jobs and flow schedules within an inventory organization, supporting sequencing, scheduling, and reporting of production activities. The table is owned by the WIP schema and is documented as VALID in the ETRM repository.

The primary key is WIP_SCHEDULE_GROUPS_PK, defined on SCHEDULE_GROUP_ID. From a Data Vault modeling perspective, the FK relationship data suggests a hub-leaning classification: the table holds a stable business entity keyed by a surrogate identifier, with numerous downstream tables referencing it as a dimension-like hub rather than acting as a transactional or attribute-history satellite. This classification is a heuristic suggestion derived from the FK topology, not a mandated physical design.

Key Information Stored

The table contains 30 documented columns. The most significant are summarized below.

• SCHEDULE_GROUP_ID — the surrogate primary key and the column referenced by all downstream foreign keys. Unique index WIP_SCHEDULE_GROUPS_U1 enforces its uniqueness.
• SCHEDULE_GROUP_NAME — the user-facing name of the schedule group. Together with ORGANIZATION_ID, it forms the alternate unique key WIP_SCHEDULE_GROUPS_U2, making it the primary business-key candidate.
• ORGANIZATION_ID — the inventory organization to which the schedule group belongs, ensuring names are unique only within an organization.
• DESCRIPTION — free-form text describing the purpose of the schedule group.
• INACTIVE_ON — the date on which the schedule group becomes inactive, enabling lifecycle management without deletion.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns recording who created and last modified the record.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — concurrent program and request context identifying the process that last touched the row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS flexfield-extension columns, available for customer-defined descriptive data.

Common Use Cases and Queries

Schedule groups are commonly used to group discrete jobs for production scheduling, sequencing, and capacity reporting. Typical queries resolve the schedule group assigned to a job, or list all active groups within an organization.

Assigned groups for discrete jobs:

• SELECT dj.wip_entity_id, dj.schedule_group_id, sg.schedule_group_name FROM wip_discrete_jobs dj, wip_schedule_groups sg WHERE dj.schedule_group_id = sg.schedule_group_id AND sg.organization_id = :org_id;

Active groups in an organization:

• SELECT schedule_group_id, schedule_group_name, description FROM wip_schedule_groups WHERE organization_id = :org_id AND (inactive_on IS NULL OR inactive_on > SYSDATE) ORDER BY schedule_group_name;

Because MSC_SUPPLIES, MSC_ST_SUPPLIES, and MRP_ITEM_WIP_ENTITIES also reference this table, planning and supply-chain reports join through the same SCHEDULE_GROUP_ID to aggregate scheduled supplies by group.

Related Objects

Numerous WIP, flow manufacturing, enterprise asset management, and advanced supply chain tables reference WIP_SCHEDULE_GROUPS through SCHEDULE_GROUP_ID.

• WIP_DISCRETE_JOBS — assigns a schedule group to each discrete job (WIP_DISCRETE_JOBS.SCHEDULE_GROUP_ID).
• WIP_FLOW_SCHEDULES — links flow schedules to schedule groups.
• FLM_SEQ_TASKS — flow sequencing tasks referencing the schedule group.
• WIP_JOB_SCHEDULE_INTERFACE and WSM_LOT_JOB_INTERFACE — open interfaces that import schedule group assignments.
• MSC_SUPPLIES, MSC_ST_SUPPLIES, MSC_WIP_JOB_SCHEDULE_INTERFACE, and MRP_ITEM_WIP_ENTITIES — planning and supply tables consuming the schedule group key.
• MTL_DEMAND_INTERFACE — demand interface rows carrying schedule group references.
• EAM_WORK_ORDER_IMPORT and EAM_FORECAST_WDJ — asset management interfaces referencing schedule groups.

The Oracle Proprietary, Confidential Information designation and Legal Notices apply to this object's documentation.