Search Results msd_sr_util




Overview
Explore in AI Chat

Overview

MSD_SR_UTIL is a utility package body owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM metadata under the UTIL (utility) API category. It forms part of the Oracle Service / Depot Repair (MSD) utility layer, providing shared helper routines consumed by a broad range of service, order management, shipping, and inventory modules. In EBS 12.1.1 and 12.2.2 it is a foundational, non-transactional utility rather than a business-flow API: it does not drive a single process but centralizes frequently repeated lookups, conversions, and derivations so that callers avoid duplicating SQL against core EBS tables.

The documented object metadata confirms the package is VALID in the APPS schema and that it is referenced by 70 other packages, which underscores its role as a shared dependency. The excerpt also states that MSD_SR_UTIL is not referenced by any database object, confirming it is a top-level utility invoked directly by application code rather than being a callback target.

Key Procedures and Functions

The ETRM documentation lists 60 documented program units. The following are representative of the utility's responsibilities:

  • ITEM, ITEM_ORGANIZATION, MASTER_ORGANIZATION — resolve item and organization context, including master organization identification, from inventory parameters and item definitions.
  • CUST — returns customer information derived from the HZ party and account model.
  • SCHN, SREP — resolve schedule-related data and sales representative references.
  • UOM_CONV — performs unit-of-measure conversion using inventory conversion definitions.
  • GET_ITEM_COST — retrieves item cost values for service and repair costing.
  • CONVERT_GLOBAL_AMT — converts amounts across currencies, typically delegating to GL currency APIs.
  • SHIPPED_DATE, BOOKED_DATE — derive shipping and order-booking dates from order and shipping tables.
  • LOCATION — resolves a location/address reference from the geography and party-site model.
  • GET_EOL_CATEGORY_SET_ID, GET_CONVERSION_TYPE — return configuration identifiers used by downstream logic.
  • GET_CUSTOMER_ATTR — retrieves a customer attribute from descriptive flexfield usages.
  • GET_NULL_PK, GET_NULL_DESC, GET_ALL_SCS_PK, GET_ALL_SCS_DESC, GET_ALL_GEO_PK — provide null-safe default keys, descriptions, and "all" sets for service/geo lookup lists.

Parameter lists are not reproduced here; callers should consult the live package specification in the target environment.

Tables Accessed

The dependency listing shows MSD_SR_UTIL reading, and occasionally writing, the following APPS-synonym objects:

Usage Notes

MSD_SR_UTIL is invoked programmatically by the 70 dependent MSD, CSD, and service-related packages rather than exposed through a single concurrent program or responsibility menu. Typical invocation paths include Depot Repair and service request forms, order and shipping flows that require item, customer, or currency resolution, and custom extensions that need consistent handling of null keys, UOM conversions, and global amount conversion. Because the package depends on FND_PROFILE and MSD_SETUP_PARAMETERS, callers should ensure the correct organization and application context are initialized before invocation. In 12.1.1 and 12.2.2 the package remains an internal utility; it should not be modified or patched directly, and any customer extension should call the public specification routines rather than replace the body.