Search Results map_region_to_site

Overview

MRP_MAP_REG_SITE is an Oracle Applications (APPS) PL/SQL package that resides in the MRP (Material Requirements Planning) module of Oracle E-Business Suite. Its documented purpose is to establish the association between planning regions and inventory sites—a mapping that the planning engine relies upon to determine which organizations participate in a given plan. In Oracle EBS, a "region" is a logical grouping of inventory organizations (sites), and the mapping of regions to sites governs which organizations are swept into a plan during a planning run.

The package is classified under the ETRM API classification of OTHER, indicating that it is not part of a published, externally supported open interface. Its source header (MRPMTRSS.pls 120.1, dated 2005) confirms it as an internal, legacy code unit shipped with the applications schema rather than a customer-facing API. It is implemented as a package specification with no documented body procedures beyond the single public function.

Key Procedures and Functions

The package exposes a single documented function:

• MAP_REGION_TO_SITE — Accepts a last update date parameter and returns a numeric result. Its role is to map planning regions to the corresponding inventory sites based on records whose last update date matches or exceeds the supplied date. The function supports incremental processing by using the date argument to restrict the set of region-to-site associations that are evaluated, which is consistent with the batched, change-driven nature of planning data maintenance.

No other procedures or functions are documented in the specification. The parameter list is intentionally not reproduced here because the metadata does not fully define argument semantics; only the single date input and numeric return are documented.

Tables Accessed

Per the ETRM metadata, the package references the following tables through APPS synonyms:

• MRP_REGION_SITES — The primary table holding the relationship between planning regions and inventory sites. This is the table the function reads and maintains to establish region-to-site mappings.
• WSH_REGIONS — The regions master table in the Shipping (WSH) schema, providing the region definitions that are associated with sites.
• DUAL — The standard Oracle single-row dummy table, typically used for SELECT expressions, sequencing, or validation logic within the function.
• PLITBLM — A PL/SQL index-by table type (or related collection construct) used internally for array-style processing, indicating the function likely performs set-based or bulk operations over the mapping records.

Usage Notes

MRP_MAP_REG_SITE is an internal utility rather than a supported open interface. It is referenced by zero other packages according to the documented dependency data, which suggests it is invoked directly from concurrent programs, region/site maintenance forms, or planning setup logic rather than being called from other PL/SQL units. Administrators and developers typically encounter it indirectly when configuring planning regions or running planning data collection in Oracle MRP.

Because the package is classified as OTHER and carries a legacy source header, customizations that call it directly should be treated with caution. Any custom code should avoid hard-coding assumptions about its return values and should rely on Oracle's supported planning setup and region-definition functionality wherever possible. In EBS 12.1.1 and 12.2.2, the package remains part of the shipped MRP schema, and its behavior is governed by the standard region-to-site configuration maintained through the planning application.