Search Results wf_web_agent

Overview

APPS.WF_CLONE is a utility package body belonging to the Oracle Workflow (WF) schema, classified under ETRM as API classification OTHER. Its purpose is to support the cloning of an Oracle E-Business Suite environment by locating and rewriting environment-specific references embedded in Workflow metadata. When an EBS instance is copied from a source system to a target system, hard-coded references such as the workflow web agent URL, the system GUID, the mailer configuration, and Workflow resource definitions still point at the original environment. WF_CLONE provides the programmatic remediation for this condition, updating those references so that notification links, item attribute URLs, and event routing function correctly against the new host, domain, port, and SID.

The header comment references $Header: wfcloneb.pls 120.1 2005/07/02 03:42:45 appldev noship $, indicating the file is not shipped as a customer-installable script ("noship") and has remained stable since the 11i-era source line. It is present in both EBS 12.1.1 and 12.2.2, where the file system layout under $APPL_TOP differs but the package specification and body remain functionally equivalent.

Key Procedures and Functions

ETRM documents twelve procedures and functions in the package. Their documented names and purposes are as follows.

• UPDATEATTRVALUES — Rewrites URL item attribute values and defaults so that they reference the target web agent. The excerpt shows it derives the source value from WF_RESOURCES where name = 'WF_WEB_AGENT', normalizes the trailing slash, constructs the target agent from the protocol, host, domain, port, and SID, and performs REPLACE operations across item attribute values, item attribute defaults, activity attribute defaults, and activity attribute values.
• UPDATESYSGUID — Refreshes the Workflow system GUID (and related system identifiers) held in WF_SYSTEMS so cloned instances no longer advertise the source system's identity.
• UPDATEMAILER — Adjusts mailer parameters, including the inbound and outbound account settings recorded in WF_MAILER_PARAMETERS.
• UPDATERESOURCE — Rewrites entries in WF_RESOURCES, the table that stores the WF_WEB_AGENT and related URL resources consumed by UPDATEATTRVALUES.
• DETERMINECLONE — Evaluates the current environment against the recorded clone state to decide whether cloning work is required.
• WFCLONE — Orchestrates the Workflow-side clone steps, coordinating the individual update routines.
• CLONE — The principal entry point that drives the overall clone operation.
• PURGEDATA — Removes residual Workflow data, including event and queue content, that should not persist into the cloned environment.
• TRUNCATETABLE — Performs a truncation of a designated table as part of the purge sequence.
• QTABLETRUNCATE — Truncation routine associated with the queue tables rather than ordinary Workflow tables.
• QDEQUEUE — Dequeues pending messages from the Advanced Queueing structures so they can then be purged.
• PURGE — The top-level purge driver that sequences the queue dequeue and table truncation operations.

Tables Accessed

The package reads and writes a broad set of Workflow dictionary and runtime tables through APPS synonyms.

• WF_RESOURCES — Read to obtain the source WF_WEB_AGENT value for US language; also maintained by UPDATERESOURCE.
• WF_ITEM_ATTRIBUTES and WF_ITEM_ATTRIBUTE_VALUES — Item attributes of type URL and their per-item values are rewritten so notification and process URLs resolve to the new host.
• WF_ACTIVITY_ATTRIBUTES and WF_ACTIVITY_ATTR_VALUES — Activity-level URL defaults and values receive the same substitution treatment.
• WF_MESSAGE_ATTRIBUTES and WF_NOTIFICATION_ATTRIBUTES — Message and notification attribute metadata are scanned for stale references.
• WF_AGENTS, WF_SYSTEMS, and WF_MAILER_PARAMETERS — Agent definitions, system GUIDs, and mailer configuration are refreshed during cloning.
• WF_PROCESS_ACTIVITIES and WF_EVENT_SUBSCRIPTIONS / WF_EVENT_T — Process definitions and event subscription/runtime records are touched by the clone and purge logic.
• DBA_QUEUES and DBA_QUEUE_TABLES — Inspected to identify the Workflow Advanced Queueing structures handled by QDEQUEUE, QTABLETRUNCATE, and PURGE.

ETRM records zero dependent packages referencing WF_CLONE, confirming it is a terminal utility rather than a shared library.

Usage Notes

WF_CLONE is invoked as part of the post-clone configuration of an EBS environment, typically in conjunction with the broader AutoConfig and cloning tooling that runs after the database and application tier have been copied. The UPDATEATTRVALUES logic is the component most directly relevant to searches for wf_web_agent: it reads the WF_WEB_AGENT resource, normalizes the trailing slash, assembles the replacement URL in the form proto://host.domain:port/pls/SID/, and applies it to every URL-typed attribute and default containing the old agent string. Because these updates are mass UPDATE statements against Workflow metadata, the package should be run only against a cloned instance, not a production source system, and only when the source and target host details are known. The purge routines dequeue and truncate Workflow queue content and should be scheduled so that no functional Workflow activity is in flight. Custom code or DBA scripts that repair Workflow URLs after a clone can call UPDATEATTRVALUES directly, but the standard supported path is to execute the package through the documented clone orchestration rather than ad hoc PL/SQL.