Search Results multi_currency

Overview

FND_OAM_EM is an Oracle E-Business Suite package body owned by the APPS schema that supplies the data-collection layer for the E-Business Suite Management (OAM) "Applications Dashboard" and system-monitoring infrastructure. Its role is to interrogate the runtime state of the EBS environment — concurrent managers, service handles, workflow agents, web components, ICM, and general system activity — and return that state to the OAM user interface and to the various alert and metrics engines. The package is classified as OTHER in the ETRM repository and is referenced by zero other packages, confirming that it is a terminal consumer of other APIs (notably FND_OAM) rather than a shared utility. Its most visible function, GET_NATIVE_SVCS, enumerates the concurrent managers and service components registered in the EBS instance and reports, for each, whether it is up, down, in a warning state, or not started.

Key Procedures and Functions

The package exposes 22 documented procedures and functions, grouped by monitoring domain:

• Service and infrastructure status: GET_NATIVE_SVCS, GET_APPS_SYS_STATUS, GET_APPS_SYS_METRICS, GET_EBIZ_STATUS, GET_EBIZ_INT_SYS_ALERTS, GET_APPS_LEVEL, GET_APPS_GENERAL_INFO, GET_CONF_CHANGED — these report the overall health of the application tier, configuration drift, and instance-level status values.
• Concurrent processing: GET_RQSTS_STATS, GET_PROCS_RQSTS_PER_CONC, GET_PEND_RQSTS — these quantify request throughput and backlog, including pending requests and per-manager request distribution.
• Workflow and worklist: GET_WF_AGENT_ACTIVITY, GET_WF_NOTIFICATION, GET_WORKITEM_METRICS — these surface workflow agent throughput, notification counts, and worklist item metrics.
• Web and integration tiers: GET_WEB_COMPONENTS_STATUS, GET_WEB_USER_LAST_HOUR, GET_ICM_STATUS, GET_BLOCK_ICM_CRM, GET_APPS_FRAMEWORK_AGENT, GET_EBIZ_ACTIVITY — these report web component availability, recent web user activity, and the status of the Integrated Change Management / CRM integration layer.

GET_NATIVE_SVCS returns a PL/SQL collection of type OAM_EM_SRVCS_TABLE_TYPE. Its cursor joins FND_CONCURRENT_QUEUES_VL, FND_APPLICATION_VL, and FND_CP_SERVICES, then calls FND_OAM.GET_SVC_INST_STATUS to obtain target and actual process counts. The numeric status code returned by that call is mapped to a display string: 0 = UP, 1 = WARNING, 2 = DOWN, 3 = NOT_STARTED.

Tables Accessed

The package reads through APPS synonyms: FND_CP_SERVICES (service handle and service ID lookup), FND_OAM_APP_SYS_STATUS (persisted application system status), FND_OAM_METVAL (metric values used by the dashboard), DUAL (scalar lookups), and PLITBLM (the PL/SQL integer table used internally by FND_OAM for bulk collection handling). The main service enumeration additionally depends on the FND_CONCURRENT_QUEUES_VL and FND_APPLICATION_VL views referenced within its cursor.

Usage Notes

FND_OAM_EM is invoked by the OAM "Applications Dashboard" and "Service Status" pages within the EBS HTML interface, and by the OAM metrics/alert collection jobs that populate FND_OAM_METVAL and FND_OAM_APP_SYS_STATUS. Because it is not referenced by any other package, custom code should call it directly only when replicating dashboard behaviour; in most cases administrators interact with it through the standard OAM pages. Regarding the multi_currency search term: FND_OAM_EM contains no currency-handling logic. Its status and metric functions are orthogonal to multi-currency configuration, and the string "multi_currency" does not appear in the package source. Users investigating multi-currency issues should look to FND_CURRENCY, GL_CURRENCY_API, or the Applications Dashboard's currency-related metrics instead.