WIP — Work in Process
96 documented tables · 206 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
WIP_PARAMETERS |
WIP specific organization level parameters | hub-leaning |
WIP_ENTITIES |
Information common to jobs and schedules | hub |
WIP_ACCOUNTING_CLASSES |
Accounting classes | hub-leaning |
WIP_LINES |
Production lines | hub |
WIP_DISCRETE_JOBS |
Discrete jobs | hub |
WIP_REPETITIVE_SCHEDULES |
Repetitive schedules | hub |
WIP_REPETITIVE_ITEMS |
Line/assembly associations | satellite-leaning |
WIP_OPERATIONS |
Operations necessary for jobs and schedules | hub |
WIP_MOVE_TRANSACTIONS |
Shop floor move transactions | satellite-leaning |
WIP_FLOW_SCHEDULES |
Work order-less flow schedules | satellite-leaning |
WIP_TRANSACTIONS |
WIP resource transactions | satellite-leaning |
WIP_OPERATION_RESOURCES |
Resources necessary for operations | satellite-leaning |
WIP_EAM_WORK_REQUESTS |
Table for work request information | satellite-leaning |
WIP_SCHEDULE_GROUPS |
Discrete job schedule groups | hub-leaning |
WIP_MOVE_TXN_INTERFACE |
Requests to process shop floor move transactions | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
WIP_PICKING_PUB |
PUB | 15 | 22 packages |
WIP_WORK_ORDER_PUB |
PUB | 1 | 11 packages |
WIP_TRANSACTION_PUB |
PUB | 1 | 9 packages |
WIP_MTLTEMPPROC_GRP |
GRP | 3 | 6 packages |
WIP_MASSLOAD_PUB |
PUB | 2 | 5 packages |
WIP_MOVPROC_GRP |
GRP | 5 | 3 packages |
WIP_INFRESSCHED_GRP |
GRP | 2 | 3 packages |
WIP_EAM_WORKREQUEST_PUB |
PUB | 1 | 2 packages |
WIP_MTI_PUB |
PUB | 5 | 2 packages |
WIP_RESERVATIONS_GRP |
GRP | 2 | 2 packages |