Search Results wip_eam_work_requests




Overview
Explore in AI Chat

Overview

WIP_EAM_WORK_REQUESTS is an Oracle Work in Process (WIP) table that stores work request header information within the Enterprise Asset Management (EAM) work request flow. A work request represents a maintenance need, repair notification, or service request raised against an asset or maintenance object before it is approved and converted into an actual EAM work order or discrete job. The table resides in the WIP schema and is valid across Oracle EBS 12.1.1 and 12.2.2.

The heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. In Data Vault modeling terms, this suggests treating WIP_EAM_WORK_REQUESTS primarily as a descriptive satellite attached to a maintenance-object or work-entity hub, rather than as a pure transactional hub or a many-to-many link. The classification reflects its relatively low dependency depth and its role in holding descriptive and status attributes about a work request.

Key Information Stored

The table contains 45 documented columns. The most important are:

Common Use Cases and Queries

Typical reports include open work requests by asset, aged work requests past the expected resolution date, and requests awaiting conversion to work orders.

  • Join to WIP_DISCRETE_JOBS on WIP_ENTITY_ID to report which requests have been converted into discrete jobs.
  • Join to MTL_SERIAL_NUMBERS via ASSET_NUMBER, ASSET_GROUP, and ORGANIZATION_ID to report asset details.
  • Join to WIP_EAM_WORK_REQ_NOTES on WORK_REQUEST_ID to retrieve notes and multi-row descriptive details attached to a request.
  • Filter by WORK_REQUEST_STATUS_ID to segregate open versus closed requests.

Sample pattern:

SELECT wr.WORK_REQUEST_NUMBER, wr.ASSET_NUMBER, wr.EXPECTED_RESOLUTION_DATE
FROM WIP.WIP_EAM_WORK_REQUESTS wr
WHERE wr.WORK_REQUEST_STATUS_ID = :status_id
AND wr.EXPECTED_RESOLUTION_DATE < SYSDATE;

Related Objects

  • MTL_SERIAL_NUMBERS — Referenced by ASSET_NUMBER, ASSET_GROUP, and ORGANIZATION_ID.
  • WIP_DISCRETE_JOBS — Referenced by WIP_ENTITY_ID; holds the resulting discrete job.
  • WIP_EAM_WORK_REQ_NOTES — Child table referencing WIP_EAM_WORK_REQUESTS.WORK_REQUEST_ID.
  • EAM_WORK_ORDER_BILLS — References WIP_EAM_WORK_REQUESTS.WORK_REQUEST_ID for material requirements.
  • Oracle Workflow (WF_ITEM_TYPE, WF_ITEM_KEY) supports approval routing of work requests.