Results for “shortage_text”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MRP_PLANNING_EXCEPTION_SETS_V is an APPS-owned database view in Oracle E-Business Suite Release 12.1.1 and 12.2.2, belonging to the Master Scheduling/MRP product family. It presents Planning Exception Set details — the configurable thresholds and time-period tolerances used during MRP, MPS, and DRP planning runs to determine when a plan should generate an exception message. This view is read-only by design and serves as the reporting and integration layer over the MRP_PLANNING_EXCEPTION_SETS base table.
Its functional significance lies in the fact that planning exception sets control the sensitivity of exception messages such as "Excess Quantity," "Overpromised," "Repetitive Variance," "Shortage," "Resource Shortage," and "Resource Excess." Each of these exception types is associated with a numeric code that, through this view, is resolved into a user-readable meaning by joining to the MFG_LOOKUPS lookup view against the lookup type MRP_EXCEPTION_TIME_PERIOD. The presence of this lookup type is the direct reason the view surfaces in searches for mrp_exception_time_period, and it is the mechanism that converts stored exception time-period codes into descriptive text.
Underlying Base Objects
The ETRM 12.2.2 metadata documents the following referenced base objects for this view:
- MRP_PLANNING_EXCEPTION_SETS (SYNONYM) — the primary base object, aliased as
Min the view definition. It holds the exception set header information, including the exception codes and the corresponding time-period values. - MFG_LOOKUPS (VIEW) — referenced six times (aliases
L1throughL6) to resolve the stored exception codes into display meanings. Each join is constrained onLOOKUP_TYPE = 'MRP_EXCEPTION_TIME_PERIOD'.
The view is a straight inner-join construct. Because all six lookup joins are mandatory equality joins on LOOKUP_CODE, any exception set row whose exception code lacks a corresponding MRP_EXCEPTION_TIME_PERIOD lookup entry will be excluded from the result set. This makes lookup completeness a practical prerequisite for the view returning complete data.
Key Columns
ROW_ID— the base table ROWID, exposed for unique row identification.EXCEPTION_SET_NAME— the user-defined name of the planning exception set.ORGANIZATION_ID— the inventory organization to which the exception set belongs.EXCESS_QUANTITY,REPETITIVE_VARIANCE,OVER_UTILIZED_PERCENT,UNDER_UTILIZED_PERCENT— quantitative thresholds that trigger the respective exception conditions.USER_TIME_FENCE— the time fence used to scope exception evaluation.EXCESS_TYPE,OVERPROMISED_TYPE,REP_VARIANCE_TYPE,SHORTAGE_TYPE,RESOURCE_SHORTAGE_TYPE,RESOURCE_EXCESS_TYPE— the stored lookup codes for each exception category.EXCESS_TEXT,OVERPROMISED_TEXT,REP_VARIANCE_TEXT,SHORTAGE_TEXT, and the additional resolved meaning columns — the descriptive text derived fromMFG_LOOKUPS.ATTRIBUTE_CATEGORYandATTRIBUTE1throughATTRIBUTE15— the standard EBS descriptive flexfield columns.- Audit columns —
CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Typical reporting scenarios include reviewing the exception thresholds configured for each organization, auditing the descriptive text resolved from lookups, and feeding exception-set definitions into external planning or analytics systems.
- Listing exception sets for a specific organization:
SELECT EXCEPTION_SET_NAME, ORGANIZATION_ID, EXCESS_QUANTITY, USER_TIME_FENCE FROM APPS.MRP_PLANNING_EXCEPTION_SETS_V WHERE ORGANIZATION_ID = :org_id; - Resolving exception type descriptions:
SELECT EXCEPTION_SET_NAME, EXCESS_TEXT, SHORTAGE_TEXT, OVERPROMISED_TEXT FROM APPS.MRP_PLANNING_EXCEPTION_SETS_V; - Auditing recently modified definitions:
SELECT EXCEPTION_SET_NAME, LAST_UPDATE_DATE, LAST_UPDATED_BY FROM APPS.MRP_PLANNING_EXCEPTION_SETS_V WHERE LAST_UPDATE_DATE > SYSDATE - 30;
Because the view resolves the MRP_EXCEPTION_TIME_PERIOD lookups at query time, it is the preferred access path for any report or interface requiring human-readable exception-set information rather than raw lookup codes from the base table.
-
Planning Exception Set details
APPS.MRP_PLANNING_EXCEPTION_SETS_V·↳ MFG_LOOKUPS·↳ MRP_PLANNING_EXCEPTION_SETS·Explore MRP module →
-
Planning Exception Set details
APPS.MRP_PLANNING_EXCEPTION_SETS_V·↳ MFG_LOOKUPS·↳ MRP_PLANNING_EXCEPTION_SETS·Explore MRP module →
-
eTRM - MRP Tables and Views 12.2.2
Recommendations based on user criteria selected in MRP Planner WorkBench
-
eTRM - MRP Tables and Views 12.1.1
Recommendations based on user criteria selected in MRP Planner WorkBench