Results for “add_to_rtg”
18 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.
- TIME_ENTRY_ID — The surrogate primary key. It is also the sole business-key candidate, enforced by the unique index WIP_RESOURCE_ACTUAL_TIMES_U1.
- ORGANIZATION_ID — Identifies the manufacturing organization (inventory organization) in which the resource activity occurred.
- WIP_ENTITY_ID — The work order or job to which the time entry belongs; the core linkage to the WIP_ENTITIES table.
- OPERATION_SEQ_NUM — The routing operation sequence number against which the resource was applied.
- RESOURCE_ID — The resource whose time is being recorded (for example, a department, machine, or crew).
- RESOURCE_SEQ_NUM — The resource sequence within the operation, distinguishing multiple resources or instances.
- INSTANCE_ID and SERIAL_NUMBER — Link the entry to a specific resource instance or serialized unit, supporting unit-level traceability.
- START_DATE and END_DATE — The actual start and stop timestamps of the resource, providing the basis for elapsed duration calculations.
- DURATION and UOM_CODE — The computed resource time and its unit of measure.
- PROJECTED_COMPLETION_DATE — The expected completion of the resource activity.
- EMPLOYEE_ID — The employee who entered or performed the time (foreign key to PSB_EMPLOYEES).
- TIME_ENTRY_MODE, COST_FLAG, ADD_TO_RTG, and STATUS_TYPE — Control attributes governing how the entry was created, whether it is costed, whether it adds to the routing, and its processing status.
- PROCESS_STATUS, ACTION_FLAG, and REQUEST_ID / PROGRAM_ID — Concurrency and concurrent-program audit fields. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and OBJECT_VERSION_NUMBER provide audit and optimistic locking support.
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.
-
Stores the start and stop time of a resource
-
Stores the start and stop time of a resource
-
eTRM - WIP Tables and Views 12.2.2
-
eTRM - WIP Tables and Views 12.1.1