Search Results value_to_id

Overview

MRP_VALUE_TO_ID is an internal utility package owned by APPS in the Oracle E-Business Suite, classified under the ETRM "OTHER" API category. Its business function is to provide identifier resolution: it converts character-based descriptive values used in the Material Requirements Planning (MRP) and supply chain planning data model into their corresponding internal numeric identifiers. MRP planning tables store foreign key references as numbers, while interface, staging, and load programs frequently present those same references as descriptive strings such as an organization code, a primary item name, a WIP entity name, or a completion locator. This package bridges that gap.

The package is a generator-maintained artifact. The source header ($Header: MRPSVIDS.pls 115.1) and the embedded comments—"Used by generator to avoid overriding or duplicating existing conversion functions" and "DO NOT MODIFY"—indicate that the value-to-ID function prototypes are automatically appended between the START GEN and END GEN value_to_id marker comments. Customers and implementers must not hand-edit these sections, because regeneration would overwrite manual additions.

Key Procedures and Functions

The package exposes ten documented callables. One is a control procedure and nine are value conversion functions:

• GET_ATTR_TBL — a procedure used by the generator mechanism to enumerate the attribute/source table binding for each conversion function, ensuring conversions are neither duplicated nor overridden.
• KEY_FLEX — resolves a key flexfield combination to its numeric combination identifier, given the flexfield code, structure number, application short name, and segment array.
• COMPLETION_LOCATOR — resolves a completion locator reference to its internal numeric identifier. This is the function associated with the user search term "completion_locator", and it supports completion/inventory locator handling in planning transactions.
• LINE — resolves a line value to its numeric identifier.
• ORGANIZATION — resolves an organization code or name to the numeric organization identifier.
• PRIMARY_ITEM — resolves a primary item reference to its numeric inventory item identifier.
• PROJECT — resolves a project number or name to its numeric project identifier.
• SCHEDULE_GROUP — resolves a schedule group reference to its numeric identifier.
• TASK — resolves a project task reference to its numeric task identifier.
• WIP_ENTITY — resolves a WIP entity name to its numeric WIP entity identifier.

Each function returns a NUMBER identifier suitable for direct use as a foreign key in MRP planning tables.

Tables Accessed

ETRM documents a single referenced table accessed through APPS synonyms: PLITBLM. This is the generated attribute/identifier-list table that backs the value-to-ID mapping mechanism. PLITBLM stores the legal string-to-ID pairs consulted by the conversion functions enumerated through GET_ATTR_TBL. The package reads from this table to perform lookups; the metadata does not indicate any write activity.

Usage Notes

MRP_VALUE_TO_ID is a supporting library rather than a user-facing API. It is referenced by two other packages in the documented metadata, meaning it is typically invoked indirectly—either from MRP loading and interface programs that must translate descriptive planning input into numeric keys, or from other APPS packages performing the same normalization. Direct custom invocation is possible where a developer needs to convert an organization, item, project, task, WIP entity, line, schedule group, key flexfield combination, or completion locator string into its internal ID within MRP-related logic.

Because the function list is generator-controlled, developers should treat the package as read-only and avoid extending it. Custom code should call the documented functions as published and should not assume additional overloads or parameters beyond those listed, as the ETRM metadata documents no explicit parameter signatures other than those shown in the source excerpt.