Search Results export_items

Overview

APPS.WF_HA_MIGRATION is an Oracle Workflow maintenance utility that supports the migration of workflow items between a production E-Business Suite system and a cloned maintenance system during high availability (HA) operations. The package header, identified by the revision marker WFHAMIGS.pls 120.2, is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking schema rather than the definer. The package has no owner-level dependency callers in the ETRM repository, indicating it is intended for direct administrative invocation rather than being consumed by other workflow APIs. Its documented API classification is OTHER, reflecting a standalone operational role rather than a public application-programming interface.

Key Procedures and Functions

• RESET_HA_FLAGS — Clears the migration flags previously set on WF_ITEMS and performs a commit, returning standard concurrent-program OUT parameters (errbuf, retcode). It is used to return the item table to a neutral state after migration processing completes or is abandoned.
• SET_HA_FLAG — Sets the migration flag on WF_ITEMS for one specific item, identified by the caller-supplied item type and item key. It provides targeted flagging where a bulk reset is inappropriate.
• GET_HA_MAINT_MODE — Returns the current High Availability maintenance mode as a string. This value indicates the migration state the system is presently operating in.
• GET_CACHED_HA_MAINT_MODE — Returns the cached maintenance mode when one is available, otherwise falls back to the current mode. Caching avoids repeated lookups during high-volume item processing.
• EXPORT_ITEMS — Ships updated items from WF_ITEMS and its associated tables to the maintenance system, continuing until no further transactions are processed on the old system and no backlog remains. It returns the standard errbuf and retcode OUT parameters, confirming its role as a runnable migration step. This is the procedure associated with the search term "export_items".
• FIXSUBSCRIPTIONS — Repairs workflow event subscriptions following the migration. It accepts a WF schema name, defaulting to APPLSYS, and a database link for the cloned database, allowing subscription records to be reconciled across the two environments.

Tables Accessed

• WF_ITEMS — The central workflow runtime item table. The package reads it to determine which items require export and writes the HA migration flag used by RESET_HA_FLAGS and SET_HA_FLAG.
• WF_ITEM_ATTRIBUTE_VALUES — Holds item attribute data associated with each workflow item; it travels with WF_ITEMS during the export to the maintenance system.
• WF_PARAMETER_LIST_T — The workflow parameter list table, consulted as part of the item export and subscription reconciliation.
• DBMS_AQADM — Referenced via synonym for Advanced Queuing administration, consistent with the workflow event and subscription handling performed by FIXSUBSCRIPTIONS.
• PLITBLM — The PL/SQL integer table type used within the package for bulk collections.

Usage Notes

The package is administrative in nature and is not referenced by any other EBS package, so it is not invoked implicitly by the workflow engine. Typical invocation is direct, either from SQL*Plus or a thin wrapper under the APPS schema, with the caller executing SET_HA_FLAG, EXPORT_ITEMS, and FIXSUBSCRIPTIONS in sequence and using RESET_HA_FLAGS for cleanup. Because RESET_HA_FLAGS and EXPORT_ITEMS expose errbuf and retcode, they are suited to being registered as concurrent programs, which allows DBAs to schedule and monitor migration runs through the standard concurrent manager with log and output files. GET_HA_MAINT_MODE and GET_CACHED_HA_MAINT_MODE are query helpers that custom code or diagnostics can call to confirm the current maintenance state before or after a migration step. The package originates from the 2005 workflow code line and the metadata is identical across 12.1.1 and 12.2.2, so no release-specific behavioral differences are documented in ETRM.