MRP — Master Scheduling/MRP
128 documented tables · 410 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
MRP_SYSTEM_ITEMS |
MRP item master | hub-leaning |
MRP_PARAMETERS |
Planning parameters | hub-leaning |
MRP_FORECAST_DESIGNATORS |
Forecast names and sets | hub-leaning |
MRP_SNAPSHOT_TASKS |
Tasks to be performed by Snapshot Workers | satellite-leaning |
MRP_RECOMMENDATIONS |
MRP plan recommendations | hub-leaning |
MRP_SCHEDULE_DESIGNATORS |
Schedule names | hub-leaning |
MRP_PLANNING_EXCEPTION_SETS |
Controls for a set of exception messages | hub-leaning |
MRP_PLANS |
Settings for a specific plan name | satellite-leaning |
MRP_DESIGNATORS |
Plan names | hub-leaning |
MRP_ITEM_WIP_ENTITIES |
Discrete jobs | satellite-leaning |
MRP_ASSIGNMENT_SETS |
Sourcing assignment set | hub-leaning |
MRP_ITEM_PURCHASE_ORDERS |
Purchase orders and purchase requisitions | satellite-leaning |
MRP_FORECAST_DATES |
Forecast entries | satellite-leaning |
MRP_SOURCING_RULES |
Sourcing Rules or Bills of Distribution | hub-leaning |
MRP_FORECAST_ITEMS |
Items in a forecast | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
MRP_ATP_PUB |
PUB | 2 | 53 packages |
MRP_SOURCING_RULE_PUB |
PUB | 3 | 14 packages |
MRP_SRC_ASSIGNMENT_PUB |
PUB | 3 | 12 packages |
MRP_FLOW_SCHEDULE_PUB |
PUB | 7 | 6 packages |
MRP_REL_PLAN_PUB |
PUB | 2 | 2 packages |
MRP_VENDORMERGE_GRP |
GRP | 1 | 1 packages |
MRP_FIELDRANGE_PUB |
PUB | 1 | 0 packages |
MRP_REPPERIODS_PUB |
PUB | 1 | 0 packages |
MRP_SCATP_PUB |
PUB | 7 | 0 packages |
MRP_SELECT_ALL_FOR_RELEASE_PUB |
PUB | 20 | 0 packages |