Search Results iem_msg_stat_pub




Overview
Explore in AI Chat

Overview

IEM_MSG_STAT_PUB is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, delivered as part of the ETRM (Enterprise Transaction and Reporting Management / iSupport messaging) infrastructure. Its central business function is to manage the lifecycle and statistics of outbound messages generated by the EBS messaging framework, and to capture document usage statistics that support telemetry-style tracking of messaging activity. The package is classified as a PUB API, meaning it is intended for direct invocation by other application modules and customizations rather than being an internal helper.

Status is documented as VALID, and the object is not referenced by any other database object, which confirms its role as a top-level API entry point rather than a subordinate utility. It depends on FND_API, FND_MSG_PUB, and FND_PROFILE, indicating integration with the standard Oracle Application Object Library error-handling, message stack, and profile-option mechanisms rather than a custom error framework.

Key Procedures and Functions

The ETRM documentation for release 12.2.2 lists six documented program units within this package body. Parameter lists are not published in the metadata and are therefore not reproduced here.

  • CREATEMSGSTAT — Creates a new outbound message statistics record, establishing the baseline entry that subsequent send, save, and cancel operations act against.
  • SENDMSGSTAT — Records the send event for a message statistics record, updating the outbound message statistics to reflect that the message has been dispatched.
  • DELETEMSGSTAT — Removes a message statistics record, used for purging or rolling back statistical entries that are no longer required.
  • CANCELMSGSTAT — Marks a message statistics record as cancelled, preserving the record for audit purposes while reflecting that the message was not successfully delivered.
  • SAVEMSGSTAT — Persists changes to an existing message statistics record, providing the update path for statistics maintained during the message lifecycle.
  • INSERTDOCUSAGESTAT — Inserts a document usage statistics row, capturing how a document or media item was accessed or consumed within the messaging framework.

Tables Accessed

The documented table references are consistent with the package's statistics-oriented purpose. IEM_OUTBOUND_MSG_STATS is the primary transactional store for outbound message statistics, and IEM_OUTBOUND_MSG_STATS_S1 is its sequence-backed key source; these two objects support the CREATEMSGSTAT, SENDMSGSTAT, CANCELMSGSTAT, and SAVEMSGSTAT operations. IEM_DOC_USAGE_STATS, together with the IEM_DOC_USAGE_STATS_S1 sequence, holds document usage tracking data written by INSERTDOCUSAGESTAT. IEM_RT_MEDIA_ITEMS is referenced to resolve the media or item definitions against which usage statistics are recorded. DUAL is used for standard Oracle single-row expression evaluation, typically for sequence retrieval or simple constant handling.

Usage Notes

IEM_MSG_STAT_PUB is normally invoked indirectly by EBS messaging and iSupport components rather than by end users. Typical callers include messaging forms and concurrent programs that dispatch outbound messages, and any custom code that participates in the EBS messaging framework and needs to register, update, or close out message statistics. Because the package uses FND_MSG_PUB and FND_API, callers should initialize the FND message stack and check the returned API status before committing, allowing standard EBS error propagation. Profile options read through FND_PROFILE govern runtime behaviour, so installations relying on non-default messaging profile settings should validate those values before customizing around this API. Release 12.1.1 and 12.2.2 exhibit the same documented structure, and the package remains VALID in the APPS schema with no downstream dependents, allowing it to be referenced safely from custom extensions without affecting compiled objects elsewhere in the database.