Search Results wf_repopulate_aq




Overview
Explore in AI Chat

Overview

The APPS.WF_REPOPULATE_AQ package is a Workflow-specific PL/SQL utility in Oracle E-Business Suite used to re-populate the Advanced Queue (AQ) tables that back the Oracle Workflow notification mailer and related notification delivery infrastructure. In the Workflow architecture, notification messages are not delivered directly from the WF_NOTIFICATIONS base table. Instead, they are enqueued into an AQ queue that the notification mailer process reads and converts into outbound e-mail messages. When the correlation between the Workflow notification records and the contents of the AQ staging area becomes inconsistent — for example, after a mailer outage, a queue purge, a failed enqueue, or a manual data fix — the notification rows remain in WF_NOTIFICATIONS but the corresponding AQ payloads are missing. WF_REPOPULATE_AQ addresses this condition by rebuilding the AQ payload records from the authoritative Workflow tables so that the mailer can again locate and dispatch pending notifications. The package is classified as OTHER within the ETRM API classification scheme, indicating it is an internal maintenance utility rather than a supported public API. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it is documented in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents a single entry point for this package:

  • POPULATEAQFORITEM — The documented procedure that performs the re-population work for a given Workflow item. It is the sole procedure or function catalogued for the package, and its purpose is to reconstruct the AQ notification payloads associated with the specified item so that the notification mailer can process them. The procedure is intended to be invoked in a targeted manner against a specific workflow item rather than as a blanket, instance-wide rebuild, which limits the blast radius of the correction and allows DBAs to remediate affected items individually.

No parameter lists are documented in the ETRM record, so the signature should be verified directly against the package specification in the target environment before invocation. No other procedures or functions are catalogued for this package.

Tables Accessed

WF_REPOPULATE_AQ is documented as referencing the following tables through APPS synonyms:

  • WF_ITEMS — The master Workflow item table. It supplies the item type, item key, and root activity context needed to identify the workflow instance being corrected.
  • WF_ITEM_ACTIVITY_STATUSES — Provides the activity-level status history for the item, allowing the procedure to determine which notification activities are still active or pending.
  • WF_NOTIFICATIONS — The authoritative source of notification records, including recipient, subject, and status. This table drives which notifications require a rebuilt AQ payload.
  • WF_PROCESS_ACTIVITIES — Supplies the process/activity definition metadata used to construct the correct payload content for the AQ message.

These tables are read to reconstruct the AQ message content; the package's dependency list also shows references to SYS.STANDARD, consistent with standard PL/SQL compilation dependencies.

Usage Notes

WF_REPOPULATE_AQ is an internal Workflow maintenance utility rather than a documented public API. It is typically invoked by a DBA or Workflow administrator from SQL*Plus or another PL/SQL client when pending or previously failed notifications are not being picked up by the notification mailer, and the underlying AQ payloads must be regenerated. ETRM reports that the package is referenced by zero other packages, confirming that it is not called programmatically by the standard Workflow runtime; it is a deliberate, manual remediation tool. No Oracle EBS form or concurrent program is documented as invoking it, so custom remediation scripts or direct SQL*Plus calls are the normal channels. Because the package manipulates notification delivery state, it should be run during a controlled maintenance window, with a backup of the affected WF_NOTIFICATIONS and queue data, and with the notification mailer quiesced until the re-population completes. Environments upgraded from 12.1.1 to 12.2.2 should confirm the package remains VALID and that the AQ queue names referenced match the online patched configuration before use.