Search Results rsrc_extract

Overview

GMP_CALENDAR_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Process Manufacturing (OPM/GMP) application family. Its principal business function is the maintenance and calculation of manufacturing resource availability calendars. The package translates plant calendar definitions, shift patterns, resource-specific exception assignments, and manually entered unavailability into a normalized availability model that downstream planning and scheduling engines can consume.

The package is a foundational utility rather than a user-facing API. It is referenced by four other packages in the ETRM dependency graph — GMP_APS_DS_PULL, GMP_BOM_ROUTING_PKG, MSC_CL_GMP_UTILITY, and MSC_CL_PULL — which indicates that both OPM scheduling and Advanced Supply Chain Planning (ASCP/MSC) collection rely upon it. Its own dependencies are minimal, referencing only SYS.STANDARD, which confirms that all database interaction is performed through APPS synonyms rather than direct schema-qualified references.

Key Procedures and Functions

• RSRC_EXTRACT — Extracts resource-level calendar data for downstream consumption, typically by the planning data pull routines that stage OPM resources into the MSC collection tables.
• RETRIEVE_CALENDAR_DETAIL — Returns the detailed calendar definition for a given context, forming the core read path of the package.
• POPULATE_RSRC_CAL — Populates the resource calendar working structures from the base shift, week-start, and exception data.
• NET_RSRC_INSERT — Inserts net resource availability records after unavailability and exception processing have been applied.
• NET_RSRC_AVAIL_CALCULATE — Performs the netting calculation that reduces gross shift capacity by downtime, exceptions, and manual unavailability.
• NET_RSRC_AVAIL_INSERT — Persists the calculated net availability into GMP_RESOURCE_AVAIL.
• INSERT_GMP_RESOURCE_AVAIL — Writes gross or intermediate availability rows into the resource availability table.
• UPDATE_TRADING_PARTNERS — Maintains trading partner context used when calendar data is extracted for supply chain planning.
• TIME_STAMP — Utility routine for recording the calculation or extraction timestamp.
• LOG_MESSAGE — Diagnostic logging utility used throughout the package to record processing messages and errors.
• ORG_STRING — Resolves or formats the organization identifier string used to scope calendar operations to a specific inventory organization.

Tables Accessed

The package reads and writes a broad set of OPM and shared tables through APPS synonyms. Calendar definition data is sourced from BOM_CAL_WEEK_START_DATES and BOM_SHIFT_DATES, while resource-specific exception assignments and manual unavailability come from GMP_RSRC_EXCP_ASNMT and GMP_RSRC_UNAVAIL_MAN. Shift-level detail is read from MR_SHCL_DTL. Resource master and detail information is drawn from CR_RSRC_DTL and GMP_RESOURCE_INSTANCES.

Output and staging tables include GMP_CALENDAR_DETAIL_GTMP (a global temporary staging table used during population), GMP_RESOURCE_AVAIL (the primary persisted availability table), and MSC_ST_RESOURCE_GROUPS and MSC_ST_TRADING_PARTNERS, which support the planning collection interface. MTL_PARAMETERS supplies organization context; DUAL and PLITBLM support PL/SQL utility operations; and V$DATABASE is referenced for database identification, typically in logging or environment checks.

Usage Notes

GMP_CALENDAR_PKG is not exposed as a form-level API. It is invoked indirectly: first by the OPM planning data pull, where GMP_APS_DS_PULL and MSC_CL_GMP_UTILITY call into it to stage resource calendars for ASCP; and second by GMP_BOM_ROUTING_PKG during routing and resource validation. In release 12.1.1 and 12.2.2 the package remains VALID and is compiled in the APPS schema.

Customizations should avoid modifying the package directly, since the MSC collection packages depend on its netting semantics. Where calendar logic must be extended, callers should invoke the documented procedures from custom PL/SQL rather than reimplementing the netting calculation. Because the package writes into GMP_RESOURCE_AVAIL, any concurrent program or interface that triggers calendar recalculation should be scheduled during low planning activity to avoid contention with the collection cycle.