Search Results wf_clone




Overview
Explore in AI Chat

Overview

The APPS.WF_CLONE package is an Oracle Workflow utility API shipped with Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to retarget Oracle Workflow configuration data whenever an EBS instance is cloned from a source environment to a target environment, or when the underlying host, domain, port, SID, or URL protocol changes. During a standard clone operation, the copied database retains references that still point to the source system — host names embedded in notification mailers, the Workflow system GUID, and attribute values that reference source URLs. WF_CLONE programmatically rewrites those references so that the target instance issues notifications and constructs links using its own connection details rather than those of the source. It is therefore an instance-configuration and post-clone remediation package rather than a business-process API. The package is owned by APPS and ETRM classifies it under API classification OTHER, reflecting its administrative, non-transactional role.

Key Procedures and Functions

  • UPDATEATTRVALUES — Updates Workflow attribute values that reference the source system, rewriting them to point at target references.
  • UPDATESYSGUID — Updates the Workflow system GUID and the related tables that carry it.
  • UPDATEMAILER — Updates the Oracle Workflow mailer parameters so that the target instance sends notifications correctly.
  • UPDATERESOURCE — Updates the WF_SYSTEM_GUID token in WF_RESOURCES with the new system GUID.
  • DETERMINECLONE — A boolean function that determines whether the current run is a clone operation or an install/upgrade/rerun; it returns FALSE for install/upgrade/rerun so that the clone APIs are skipped.
  • WFCLONE — The master procedure that calls all cloning-related APIs; it is intended to be invoked by a concurrent program.
  • CLONE — A clone procedure complementary to WFCLONE.
  • PURGEDATA and PURGE — Procedures that purge Workflow clone/runtime data.
  • TRUNCATETABLE — Truncates a specified table, with a raise_error flag defaulted to FALSE because AutoConfig cannot raise errors; failures may still be recorded.
  • QTABLETRUNCATE — Truncates an Advanced Queue queue table.
  • QDEQUEUE — Dequeues messages from a named queue.

Tables Accessed

The package reads and writes Workflow configuration and metadata tables through APPS synonyms. Attribute retargeting touches WF_ACTIVITY_ATTRIBUTES, WF_ACTIVITY_ATTR_VALUES, WF_ITEM_ATTRIBUTES, WF_ITEM_ATTRIBUTE_VALUES, WF_MESSAGE_ATTRIBUTES, and WF_NOTIFICATION_ATTRIBUTES, since these store URLs and system references. System identity is held in WF_SYSTEMS, WF_RESOURCES, WF_AGENTS, and WF_EVENT_SUBSCRIPTIONS, and event data in WF_EVENT_T. Mailer configuration resides in WF_MAILER_PARAMETERS, and process definitions in WF_PROCESS_ACTIVITIES. Queue maintenance uses DBA_QUEUES and DBA_QUEUE_TABLES.

Usage Notes

WF_CLONE is normally invoked by a concurrent program during post-clone configuration, and is also a candidate for AutoConfig-driven execution; the DETERMINECLONE guard prevents unintended execution during install, upgrade, or rerun. It is not referenced by any other package (referenced by 0 packages per ETRM), so it belongs to the top level of the Workflow administration stack rather than to application logic. The Hindi search phrase seen by the user concerns "how to make a clone on a laptop" and does not describe this object; the package instead automates the database-side retargeting that a clone requires.