Search Results ir_dates




Overview
Explore in AI Chat

Overview

MSC_DRP_UTIL is a utility package in the APPS schema of Oracle E-Business Suite that supports the Distribution Requirements Planning (DRP) and Advanced Supply Chain Planning (ASCP) modules. Its classification as a UTIL package indicates that it does not expose a public application programming interface in the conventional sense; rather, it provides a shared library of helper routines consumed internally by other planning packages and by the reporting views that surface DRP exception, order, and shipment data. The package operates within the MSC (Supply Chain Planning) schema family and carries a VALID status in both 12.1.1 and 12.2.2, indicating that no invalidated or recompilation-dependent objects are associated with it.

Key Procedures and Functions

The documented metadata for 12.2.2 lists twenty-seven procedures and functions. Representative members include the following.

  • ORDER_TYPE_TEXT — returns a display label for an order type code, used when rendering order rows in DRP views.
  • COST_UNDER_UTIL — supports cost computation for utilization or under-utilization scenarios within the planning engine.
  • MATERIAL_AVAIL_DATE — determines the date on which material becomes available for a supply or demand record.
  • OFFSET_DATE and OFFSET_DATES — apply calendar-based date offsets, individually and in bulk, when projecting planning dates.
  • IR_DATES — derives interested-party or internal requisition related dates used in replenishment logic.
  • WT_CONVERT_RATIO and VL_CONVERT_RATIO — return weight and volume conversion ratios for unit-of-measure normalization.
  • SOURCING_RULE_NAME and ALLOC_RULE_NAME — resolve internal identifiers into user-facing sourcing rule and allocation rule names.
  • GET_PREF_KEY — retrieves a profile or preference key value used by the planning views.
  • GET_CAL_VIOLATION — reports calendar violations detected against a planning date or shift.
  • UPDATE_SUPPLY_ROW and MARK_SUPPLY_UNDO — modify and revert supply records, supporting the DRP supply-maintenance workflow.
  • NOTEQUAL, GET_MSG, GET_ISO_TRIP, FORECAST_NAME, GET_ISO_NAME, GET_WORK_DAY — miscellaneous helpers covering comparison, message retrieval, in-transit/ISO naming, forecast naming, and working-day derivation.

Parameter lists are not enumerated here; callers should inspect the package specification for exact signatures.

Tables Accessed

The package reads and writes a focused group of planning tables through APPS synonyms. MSC_PLANS, MSC_SYSTEM_ITEMS, and MSC_CALENDAR_SHIFTS / MSC_SHIFT_TIMES underpin date and calendar calculations such as OFFSET_DATES and GET_WORK_DAY. MSC_ITEM_SOURCING and MSC_SOURCING_RULES supply sourcing-rule resolution, while MSC_DRP_ALLOC_RULES supports allocation rule naming. Supply-side maintenance touches MSC_SUPPLIES, MSC_INTERORG_SHIP_METHODS, and MSC_DEMANDS. Exception and peg reporting relies on MSC_EXCEPTION_DETAILS, MSC_SRP_ITEM_EXCEPTIONS, and MSC_SINGLE_LVL_PEG. MSC_FORM_QUERY and MSC_FORM_QUERY_S provide saved query metadata used by the DRP forms and views. These accesses confirm the package's role as a read-heavy support layer with limited, targeted writes to supply rows.

Usage Notes

MSC_DRP_UTIL is not intended for direct invocation by end users. It is referenced by fifteen other packages and by a set of reporting views, including MSC_DRP_EXC_DETAILS_V, MSC_ORDERS_DRP_V, MSC_ORDERS_DRP_COL_V, MSC_SHIPMENTS_V, MSC_SHIPMENT_DETAILS_V, and MSC_SHIPMENT_LINES_V. Notable dependent packages include MSC_ALLOCATION_PLAN, MSC_GET_BIS_VALUES, and MSC_REL_WF. Because the package is embedded in view definitions that back Oracle's delivered DRP and shipment inquiry forms, it is exercised implicitly during form navigation, concurrent plan runs, and any custom code or BI Publisher report that queries those views. Customizations should avoid modifying the package body; instead, extensions should wrap the documented program units or replicate their logic in a customer-owned package to preserve upgrade safety across 12.1.1 and 12.2.2.