Search Results first_work_date

Overview

MSC_HUB_CALENDAR is an Oracle Applications (APPS) PL/SQL package belonging to the Advanced Supply Chain Planning (ASCP) schema, part of the MSC (Supply Chain Planning) module. Its business function is to encapsulate the calendar and bucketing logic required by the planning engine. Planning buckets—daily, weekly, and periodic—must be aligned to a valid manufacturing or hub calendar so that supply, demand, and safety stock are placed on working days rather than on non-working days such as weekends and holidays. The package provides reusable functions that resolve the first and last working dates within a planning bucket, determine the start date of the bucket that contains a given working day, and resolve item-organization context for a planning plan. Because the "October monthly calendar" query targets this object, the package is the correct point of reference for calculating which dates in October are working days and which bucket boundaries apply to a monthly plan. The specification is a header-only package (MSCHBCAS.pls, version 120.6, dated 2008/03/19), meaning the public API is stable across the EBS 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

• FIRST_WORK_DATE — Returns the first working date for a planning bucket, given a calendar code, source instance, bucket type, and bucket start date. Used to snap a bucket's beginning to the first valid working day.
• LAST_WORK_DATE — Overloaded. One form returns the last working date for a calendar/bucket combination; a second form returns the last working date for a plan over a bucket range; a third form returns the last working date for a plan on a single date. This supports month-end and period-end determinations such as the final working day of October.
• SS_DATE — Returns the appropriate date for safety stock placement within a bucket range for a given plan, ensuring safety stock is applied on a valid working day.
• WORKING_DAY_BKT_START_DATE — Returns the bucket start date that corresponds to a working day for a plan, bucket type, and date range. Used when a demand or supply date must be mapped onto the correct planning bucket.
• GET_ITEM_ORG — Returns the organization identifier for an item within a plan and source instance, resolving item-organization relationships used by the calendar and bucketing calculations.

Tables Accessed

The package reads the following tables through APPS synonyms:

• MSC_CALENDARS and MSC_CALENDAR_DATES — define calendar definitions and working versus non-working dates, including holidays, and drive all work-date computations.
• MSC_CAL_WEEK_START_DATES and MSC_PERIOD_START_DATES — supply weekly and periodic bucket boundaries.
• MSC_PLANS and MSC_PLAN_BUCKETS — provide plan-level bucket configuration.
• MSC_SAFETY_STOCKS — used by SS_DATE to align safety stock to buckets.
• MSC_SYSTEM_ITEMS and MSC_TRADING_PARTNERS — support item and organization resolution within GET_ITEM_ORG and related logic.

Usage Notes

MSC_HUB_CALENDAR is an internal planning-engine package and is not exposed through standard EBS forms. It is invoked by the ASCP planning engine, by concurrent programs that build and refresh plan buckets, and by other MSC packages; the ETRM metadata records that it is referenced by six other packages, confirming its role as a shared utility. Custom code that needs to determine the first or last working day of a period (for example, the October monthly calendar), to locate the bucket containing a specific date, or to associate an item with its organization within a plan should call these functions rather than querying the calendar tables directly, ensuring consistency with planning-engine bucketing rules.