Results for “time_entry_mode”

30 results




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

Overview

WIP_RESOURCE_ACTUAL_TIMES is a Work in Process (WIP) transactional table in the Oracle E-Business Suite 12.1.1 / 12.2.2 data model that stores the start and stop times of resources applied during discrete manufacturing execution. Each row captures an individual time entry recorded against a specific resource assigned to a WIP entity and operation, providing the underlying detail for resource labor, machine time, and duration reporting. The table supports both manual and automatic time entry modes and is populated when operators clock resources on and off work orders or when the system derives resource activity from shop floor transactions.

In terms of the heuristic Data Vault classification supplied in the metadata, WIP_RESOURCE_ACTUAL_TIMES is documented as standalone. From a modeling perspective, this suggests the table may be treated as a candidate satellite keyed by its own unique identifier, rather than as a central hub or link, since it is not modeled as a parent of dependent foreign-key relationships within the extracted structure.

Key Information Stored

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

Common Use Cases and Queries

Primary use cases include shop floor time-and-attendance reconciliation, resource utilization and OEE analysis, labor variance reporting against standards, and investigation of uncosted or erroneously entered time.

  • Retrieving open (unended) time entries: SELECT time_entry_id, wip_entity_id, resource_id, start_date FROM wip.wip_resource_actual_times WHERE end_date IS NULL;
  • Computing total recorded duration per work order: SELECT wip_entity_id, SUM(duration) FROM wip.wip_resource_actual_times WHERE cost_flag = 'Y' GROUP BY wip_entity_id;
  • Filtering by organization, operation, and resource to audit time entered against a specific routing step.
  • Joining EMPLOYEE_ID to PSB_EMPLOYEES to report time by operator.

Related Objects

  • PSB_EMPLOYEES — Referenced via EMPLOYEE_ID; the only documented foreign key.
  • WIP_ENTITIES — Joined on WIP_ENTITY_ID to resolve the work order or job.
  • WIP_OPERATIONS — Joined on WIP_ENTITY_ID and OPERATION_SEQ_NUM for operation context.
  • BOM_RESOURCES — Joined on RESOURCE_ID for resource definition and charge attributes.
  • WIP_RESOURCE_ASSIGNMENTS / WIP_REQUIREMENT_OPERATIONS — Provide the planned resource requirement for variance comparison against actual times.