Search Results iem_email_proc_pvt




Overview
Explore in AI Chat

Overview

IEM_OUTBOX_PROC_PUB is a public PL/SQL package in the APPS schema that serves as the core processing engine for the Interaction / Email Center (IEM) outbound message subsystem in Oracle E-Business Suite. Its business function is to manage the lifecycle of outbound messages generated within the Email Center: creating outbox messages, submitting them for delivery, cancelling them when no longer required, recording processing errors, and supporting automated behaviors such as autoresponses, redirects, and auto-forwarding. In addition, the package supports the creation of Service Request (SR) auto-notifications, tying outbound messaging directly to service request processing workflows.

The "PUB" suffix and its dependency on FND_API identify it as a published, API-classified package, confirming it is intended as a supported programmatic interface by which other IEM components and custom code interact with the outbox subsystem. It is documented as being referenced by only one other package, IEM_EMAIL_PROC_PVT, which is the internal email processing private package; the user's search term "iem_email_proc_pvt" aligns directly with this documented dependency, indicating that the private processing layer invokes IEM_OUTBOX_PROC_PUB to perform outbox operations.

Key Procedures and Functions

The package exposes twelve documented procedures and functions, which fall into several functional groups:

  • CREATEOUTBOXMESSAGE — Creates a new outbound message record in the outbox for subsequent processing and delivery.
  • SUBMITOUTBOXMESSAGE — Submits an existing outbox message into the delivery/processing pipeline.
  • CANCELOUTBOXMESSAGE — Cancels an outbox message, preventing further processing or dispatch.
  • WRITEOUTBOXERROR — Records an error condition encountered while processing an outbox message, supporting diagnostic and retry logic.
  • CREATEAUTOREPLY — Generates an automated reply in response to an inbound interaction or message.
  • INSERTBODYTEXT — Inserts the body text content associated with a message part.
  • INSERTDOCUMENT — Inserts document content into the message structure.
  • ATTACHDOCUMENT — Attaches a document to an outbound message.
  • GETACCOUNTLIST — Retrieves a list of accounts, likely used to determine message routing or recipients.
  • REDIRECTMESSAGE — Redirects a message to an alternate destination.
  • AUTOFORWARD — Automatically forwards a message according to configured rules.
  • CREATESRAUTONOTIFICATION — Creates an automatic notification tied to a service request.

These procedures collectively cover message creation, content assembly, routing behaviors, error handling, and service-request integration.

Tables Accessed

Through APPS synonyms, the package reads and writes several core Interaction Center tables. IEM_ROUTE_RULES and IEM_ROUTE_CLASSIFICATIONS drive routing and classification decisions, supporting the redirect and forwarding logic. IEM_MSG_PARTS, along with INSERTBODYTEXT, INSERTDOCUMENT, and ATTACHDOCUMENT, stores the component parts of a message, including body text and attachments.

Outbox error handling relies on IEM_OUTBOX_ERRORS and its sequence IEM_OUTBOX_ERRORS_S1. Interaction and media tracking use IEM_RT_INTERACTIONS, IEM_RT_INTERACTIONS_S1, IEM_RT_MEDIA_ITEMS, IEM_RT_MEDIA_ITEMS_S1, and IEM_RT_PROC_EMAILS, while JTF_IH_INTERACTIONS links outbound messages to the broader Interaction History framework. DUAL and PLITBLM are used for standard PL/SQL structural and utility operations.

Usage Notes

IEM_OUTBOX_PROC_PUB is typically invoked indirectly rather than called directly by end users. The documented reference from IEM_EMAIL_PROC_PVT indicates that the Email Center's internal processing package drives outbox operations through this public interface, particularly during email ingestion and outbound dispatch cycles. It may also be invoked by concurrent programs or workflows that generate outbound notifications, such as service request auto-notification processing. Custom extensions integrating with Email Center messaging should use this published package rather than manipulating the underlying IEM tables directly, since it encapsulates routing rules, error logging, and sequence management consistently across Oracle EBS 12.1.1 and 12.2.2.