Search Results mrp_id_to_value




Overview
Explore in AI Chat

Overview

MRP_ID_TO_VALUE is an Oracle EBS PL/SQL package body owned by the APPS schema, classified under the OTHER API category. Its name and documented interface indicate a conversion utility whose purpose is to translate numeric internal identifiers into their corresponding descriptive values in support of discrete manufacturing and material requirements planning (MRP) processing. It exposes a set of helper functions that resolve primary keys held on transactional records — work orders, schedule groups, projects, tasks, and inventory organizations — into the human-readable or joined values needed for validation and display. The package is fully valid in both the 12.1.1 and 12.2.2 releases and is documented in ETRM.

Because EBS stores work in process (WIP) entities and planning records with surrogate numeric keys, downstream logic frequently needs the associated name, item, or locator. MRP_ID_TO_VALUE centralizes that lookup so that workflow, forms personalizations, and planning utilities avoid duplicating the join logic.

Key Procedures and Functions

ETRM documents nine callable units. Their purposes are:

  • GET_ATTR_TBL — returns an attribute/descriptor table used to carry the resolved identifier-to-value mappings, serving as the internal data structure through which the other functions communicate results.
  • COMPLETION_LOCATOR — resolves the completion locator associated with a WIP entity, returning the inventory locator value rather than its numeric ID.
  • LINE — converts a WIP line identifier into its line designation.
  • ORGANIZATION — translates an organization identifier into the organization code or name defined in Oracle Inventory.
  • PRIMARY_ITEM — returns the primary item associated with a WIP or planning record.
  • PROJECT — resolves a project identifier to its project value, drawing on the project view.
  • SCHEDULE_GROUP — returns the schedule group description for a given schedule group identifier.
  • TASK — converts a task identifier into its task value.
  • WIP_ENTITY — returns the work in process entity name for a supplied WIP entity identifier.

Exact parameter lists are not published in the ETRM extract and should be inspected via ALL_ARGUMENTS on the target instance. Each function follows a consistent single-identifier-in, value-out pattern.

Tables Accessed

The package reads the following objects, accessed through APPS synonyms:

  • WIP_LINES — the source of discrete job line definitions used by the LINE function.
  • WIP_SCHEDULE_GROUPS — supplies schedule group records for the SCHEDULE_GROUP function.
  • PLITBLM — the PL/SQL index-by table used to exchange attribute arrays within the package.

Dependency metadata additionally cites FND_API, FND_MESSAGE, and FND_MSG_PUB, indicating use of the Oracle Application Object Library messaging and API error-handling stack, plus MTL_PROJECT_V, ORG_ORGANIZATION_DEFINITIONS, and WIP_LINES. These support the PROJECT and ORGANIZATION functions and consistent error messaging. The package performs read-only lookups; no DML is documented.

Usage Notes

MRP_ID_TO_VALUE is not referenced by any database object and is therefore not on a standard concurrent program path. It is invoked directly from custom code, form personalizations, workflow functions, or Oracle Reports that require the descriptive value behind an internal ID. A practical example is a custom concurrent program that prints discrete job details: the report passes a WIP_ENTITY ID to WIP_ENTITY and receives the job name for output.

Because the dependent FND_MESSAGE and FND_MSG_PUB packages participate in error handling, callers should initialize the FND message stack before invocation and check FND_MSG_PUB.count_msg afterward. ETRM lists one referencing package, and future patches may alter signatures; validate argument lists against ALL_ARGUMENTS after each upgrade to 12.2.2 and beyond.