Search Results get_req_status_phase_schdesc

Overview

FND_OAM is a PL/SQL package owned by APPS that provides utility functions for Oracle Applications Manager (OAM), the central administrative console within Oracle E-Business Suite. Its header dates to the 11i era and it remains in use in 12.1.1 and 12.2.2. The package exposes a set of monitoring primitives that return counts, statuses, and validation results used by OAM dashboards, alert definitions, and administrative forms. It is classified under the ETRM metadata as an OTHER API rather than a formal business API, reflecting its internal role. Because it encapsulates queries against FND concurrent processing, user security, and session views, it allows the OAM front end to obtain operational metrics without embedding SQL directly in each page or concurrent program. The documented package exposes 10 procedures and functions and is referenced by three other packages.

Key Procedures and Functions

• APPS_SESSIONS — Returns the current number of Apps logins and the number of open forms. It requires Login Auditing to be enabled at the FORM level for accurate results.
• COMPLETED_REQS — Returns counts of concurrent requests that completed with Normal, Warning, Error, and Terminated statuses.
• PENDING_REQS — Returns counts of concurrent requests pending with Normal, Scheduled, and Standby statuses.
• CONC_MGR_PROCS — Returns the number of running requests and the total number of running concurrent manager processes.
• VALIDATE_USER — Validates a user account, typically for authentication or administration checks performed by OAM.
• SET_DEBUG — Controls debug/trace behavior for the package, used during diagnostics.
• GET_SVC_STATUS — Returns the status of an application service. This is the related service-level counterpart to the function the user searched for.
• GET_SVC_INST_STATUS — Returns the status of a specific service instance. This is the function the user searched for; it exposes per-instance service health information consumed by OAM service monitoring pages.
• GET_NODE_STATUS — Returns the status of a node hosting EBS services, supporting topology and availability displays.
• GET_REQ_STATUS_PHASE_SCHDESC — Returns request status, phase, and schedule description information, used to populate request detail views.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• FND_CONCURRENT_REQUESTS and FND_CONCURRENT_QUEUES — source data for COMPLETED_REQS, PENDING_REQS, CONC_MGR_PROCS, and GET_REQ_STATUS_PHASE_SCHDESC.
• FND_LOGIN_RESPONSIBILITIES and FND_LOGIN_RESP_FORMS — login and open-form auditing data underlying APPS_SESSIONS.
• FND_RESPONSIBILITY and FND_USER — responsibility and user records used by VALIDATE_USER and session counts.
• V$SESSION — live database session data for session and process monitoring.

Usage Notes

FND_OAM is invoked primarily by OAM administration pages, system alerts, and concurrent programs that display application health metrics. Custom code can call it to obtain current request, session, or service status counts without replicating underlying SQL. Because it is not a public business API and may change between releases, direct calls from customizations should be treated as unsupported and validated separately for 12.1.1 and 12.2.2. GET_SVC_INST_STATUS and its related functions are most relevant when monitoring service instance availability after startup or during troubleshooting.