Search Results oe_value_to_id




Overview
Explore in AI Chat

Overview

APPS.OE_VALUE_TO_ID is a utility package body in the Oracle Order Management (OM) module of Oracle E-Business Suite, present and valid in both release 12.1.1 and 12.2.2. Its central purpose is to resolve a human-readable "value" — a descriptive name, code, or flexfield segment value — into the corresponding internal numeric identifier (ID) used as a foreign key throughout the Order Management and Oracle Receivables data model. In effect, it acts as a centralized lookup and validation engine that shields calling code from having to know the specific join path, view, or lookup table required to translate a meaningful business attribute into the surrogate key expected by the transactional tables.

Because so many OM attributes (order type, salesrep, price list, payment term, ship-to and bill-to organizations, contacts, and so on) are stored internally as IDs but presented to users as names, this package is a foundational dependency for Order Management forms, APIs, and concurrent programs. The ETRM metadata classifies it as an OTHER API classification, indicating it is a supporting internal utility rather than a published public interface.

Key Procedures and Functions

The package exposes a large set of narrowly scoped resolution routines (104 documented procedures/functions in the 12.2.2 metadata). Representative documented members include:

Each routine accepts a descriptive input and returns the matching internal ID (or raises an error via FND_MESSAGE/OE_MSG_PUB when no match is found). The exact parameter lists are not enumerated in the metadata and must not be assumed.

Tables Accessed

The package reads from a broad set of Order Management, Receivables, and Trading Community (HZ) tables through APPS synonyms. Documented references include:

In addition, the package depends on numerous OE_* views (OE_AGREEMENTS_V, OE_CONTACTS_V, OE_DELIVER_TO_ORGS_V, OE_INVOICE_TO_ORGS_V, OE_SHIP_FROM_ORGS_V, OE_SHIP_TO_ORGS_V, OE_SOLD_TO_ORGS_V, and others) plus Oracle HR operating units, IBY credit card issuers, QP list headers, RA_SALESREPS, and the MO_GLOBAL multi-org context. Reads dominate; the package is primarily a lookup utility.

Usage Notes

OE_VALUE_TO_ID is an internal, widely reused utility rather than a user-facing interface. In Oracle EBS 12.1.1 and 12.2.2 it is typically invoked indirectly by Order Management forms and by other OM PL/SQL packages — the metadata notes it is referenced by 24 other packages (itself included via recursive reference). Customizations and extensions that need to convert a business value (such as an order type name or a ship-to organization) into the numeric ID expected by Order Management APIs commonly call these routines. Because it depends on MO_GLOBAL, the correct operating unit context must be initialized before invocation. Callers should handle the exceptions the package raises when a value cannot be resolved. It is not referenced by any database object other than dependent packages, confirming its role as a leaf utility in the dependency chain. Parameter specifics should be confirmed against the actual package specification in the target instance, since the ETRM metadata documents procedure names and dependencies rather than signatures.