Results for “eam_common_utilities_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EAM_COMMON_UTILITIES_PVT is an internal (private) PL/SQL package body owned by the APPS schema that provides shared validation, lookup, and value-hydration utilities for the Oracle Enterprise Asset Management (EAM) product family. Its classification as a PVT package indicates it is not a public API: it exists to serve other EAM packages rather than to be called directly by customer extensions. In both EBS 12.1.1 and 12.2.2 the object is shipped with a status of VALID, and it is referenced by 25 other packages, confirming its role as a foundational helper layer beneath the EAM work-order, asset-numbering, and meter-processing APIs.

The package consolidates low-level checks that would otherwise be duplicated across EAM maintenance logic: resolving organization and item identifiers, validating department, location, meter, accounting-class, and descriptive-flexfield values, formatting item and lookup display names, and supplying session context such as the current accounting period and currency. By centralizing these routines, EAM achieves consistent error handling (typically through FND_MESSAGE and FND_MSG_PUB) and consistent use of FND_API conventions across work-order creation, asset definition, and meter reading flows.

Key Procedures and Functions

The ETRM metadata documents 44 procedures and functions. Representative members include:

• GET_ORG_CODE, GET_CURRENT_PERIOD, GET_CURRENCY — retrieve organization, GL period, and currency context, generally derived from profile options and set-of-books data.
• GET_ITEM_ID, GET_ITEM_NAME, INVALID_ITEM_NAME, VALIDATE_INVENTORY_ITEM_ID — resolve and confirm inventory item identity for the current organization.
• GET_NEXT_ASSET_NUMBER — obtains the next asset number in sequence, delegating to EAM_ASSET_NUMBER_PVT.
• GET_MFG_MEANING — retrieves the meaning of a manufacturing lookup code from MFG_LOOKUPS.
• VALIDATE_SERIAL_NUMBER, VALIDATE_METER_ID, VALIDATE_MAINTAINED_OBJECT_ID — confirm that serial numbers, meters, and maintained (network) assets exist and are valid for the operation.
• VALIDATE_DEPARTMENT_ID, VALIDATE_EAM_LOCATION_ID, VALIDATE_EAM_LOCATION_ID_ASSET — validate maintenance department and EAM location references, including asset-specific location checks.
• VALIDATE_WIP_ACCT_CLASS_CODE, VALIDATE_MFG_LOOKUP_CODE, VALIDATE_BOOLEAN_FLAG, VALIDATE_DESC_FLEX_FIELD — generic validation helpers for WIP accounting classes, lookup codes, Yes/No flags, and descriptive flexfield segments.
• VERIFY_ORG — confirms that the operating organization is accessible within the maintenance context.

Parameter signatures are intentionally omitted here; callers should treat this body as private and reference the public EAM APIs instead.

Tables Accessed

Table access spans several EBS schemas through APPS synonyms:

• BOM_DEPARTMENTS, BOM_DEPT_RES_INSTANCES, BOM_RESOURCES, BOM_RESOURCE_EMPLOYEES — department and resource validation, including resource-instance and employee-resource associations.
• CSI_ITEM_INSTANCES, CSI_COUNTERS_B, CSI_COUNTER_TEMPLATE_B — instance, counter, and counter-template resolution for meter and asset logic.
• MTL_EAM_LOCATIONS, EAM_LINEAR_LOCATIONS, MTL_EAM_NETWORK_ASSETS, MTL_SYSTEM_ITEMS(_B/_KFV), MTL_SERIAL_NUMBERS, MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES — location, item, serial, and organization-parameter lookups.
• EAM_ORG_MAINT_DEFAULTS, EAM_WO_RELATIONSHIPS, WIP_EAM_PARAMETERS — EAM defaults and work-order relationship configuration.
• GL_PERIODS, GL_SETS_OF_BOOKS, FND_USER, HR_ORGANIZATION_INFORMATION — period, ledger, user, and organization context.

Cross-package dependencies include EAM_ASSET_NUMBER_PVT, EAM_PROCESS_WO_PUB/PVT, EAM_WORKORDER_UTIL_PKG, FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, FND_LOG, FND_FLEX_DESCVAL, and INV_QUANTITY_TREE_PVT.

Usage Notes

EAM_COMMON_UTILITIES_PVT is not referenced by any database object and is not exposed as a customer-facing API. It is invoked indirectly whenever an EAM form, concurrent program, or public API performs work-order processing, meter entry, asset numbering, or maintenance-location assignment. Typical callers are the EAM work-order and asset-management screens and the maintenance-related concurrent programs that submit work orders and meter transactions. Because the package is private, customizations should call the supported public APIs (for example EAM_PROCESS_WO_PUB) rather than referencing this body directly; direct calls risk incompatibility across 12.1.1 and 12.2.2 patch levels.