EAM — Enterprise Asset Management
75 documented tables · 58 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
EAM_WO_STATUSES_B |
Table for storing user defined statuses | hub-leaning |
EAM_PM_SCHEDULINGS |
PM Scheduling Definition | hub-leaning |
EAM_CONSTRUCTION_UNITS |
This table contains all the construction units defined in the system. The construction unit information includ | hub-leaning |
EAM_CONSTRUCTION_ESTIMATES |
This table contains all the estimates header information. The header information include- Estimate name- Group | hub-leaning |
EAM_FAILURE_SETS |
All the failure set definitions are stored in this table. | hub-leaning |
EAM_PM_SET_NAMES |
PM Set Names | hub-leaning |
EAM_METERS |
Table for asset meter definition | hub-leaning |
EAM_DIFFICULTY_CODES |
This table contains difficulty code mapping with resource multipliers. It also includes the effectivity period | hub-leaning |
EAM_CAUSE_CODES |
Table to store the Cause Codes defined in the system | hub-leaning |
EAM_RESOLUTION_CODES |
Table to store the Resolution Codes defined in the system | hub-leaning |
EAM_FAILURE_CODES |
Table to store the Failure Codes defined in the system | hub-leaning |
EAM_OP_COMPLETION_TXNS |
Work Order Operation Completion Transaction History | link |
EAM_WO_RELATIONSHIPS |
Eam Work Order Relationships | standalone |
EAM_PM_LAST_SERVICE |
PM Last Service Information | link |
EAM_WORK_ORDER_DETAILS |
eAM Work Order Details | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
EAM_PROCESS_WO_PUB |
PUB | 12 | 79 packages |
EAM_PROCESS_SAFETY_PUB |
PUB | 9 | 22 packages |
EAM_OBJECTINSTANTIATION_PUB |
PUB | 2 | 7 packages |
EAM_PROCESS_PERMIT_PUB |
PUB | 2 | 6 packages |
EAM_PROCESS_FAILURE_ENTRY_PUB |
PUB | 1 | 6 packages |
EAM_WORKORDERTRANSACTIONS_PUB |
PUB | 6 | 5 packages |
EAM_METERREADING_PUB |
PUB | 3 | 5 packages |
EAM_EST_DATASTRUCTURES_PUB |
PUB | 0 | 4 packages |
EAM_PMDEF_PUB |
PUB | 21 | 4 packages |
EAM_PM_LAST_SERVICE_PUB |
PUB | 1 | 3 packages |