Search Results activate_item

Overview

GMI_WF_ITEM_ACTIVATION is an Oracle EBS package owned by the APPS schema and classified as OTHER in the ETRM metadata (12.2.2). It belongs to the Oracle Process Manufacturing (OPM) product family, as indicated by the "GMI" prefix, and provides a bridge between OPM item master data and the Oracle Workflow engine. The package header is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the package owner. Its observed version header dates to 2003, indicating that the interface has been stable across the 12.1.1 and 12.2.2 releases.

The package exists to initialize and drive workflow processes that are triggered during item-related lifecycle events — most commonly item creation, activation, and approval routing. It allows OPM items to participate in a workflow-based approval and activation model using Oracle Workflow's standard item type / item key paradigm.

Key Procedures and Functions

• INIT_WF — Initializes a workflow instance for an OPM item. It receives the item's internal identifier, item number, unit of measure, primary description, and the identity of the creating user, then seeds the workflow with this context so downstream activities can reference the item attributes.
• SELECT_APPROVER — A Workflow function that determines the appropriate approver for a given workflow activity. It accepts the workflow item type, item key, activity identifier, and function mode, and returns a result value to the Workflow engine, which uses that result to route the process.
• ACTIVATE_ITEM — The procedure associated with the "activate_item" search term. It performs the activation step of the workflow, again receiving item type, item key, activity ID, and function mode, and returning a result to Workflow. It is the callback executed when the workflow reaches the item-activation activity node.

All three procedures use the standard Oracle Workflow callback signature for result-returning activities, allowing the Workflow Engine to invoke them directly from process definitions.

Tables Accessed

• IC_ITEM_MST — The OPM item master, which stores the core item definition and status. The package reads it to validate the item and persist activation-relevant updates.
• IC_ITEM_HIERARCHY — The item hierarchy table, used to resolve parent/child relationships and category context that may influence approval routing.
• FND_USER — The EBS application user table, used to identify the creating user and to resolve approvers for the SELECT_APPROVER activity.

These are referenced through APPS synonyms, so the package relies on the standard OPM and FND data model rather than private tables.

Usage Notes

GMI_WF_ITEM_ACTIVATION is not intended for direct invocation by end users. It is invoked by the Oracle Workflow Engine as a result of activity function calls defined in an item-type process definition, or by OPM item-conversion logic that programmatically starts a workflow for a newly created item. In 12.1.1 and 12.2.2 it is most relevant to OPM item approval and activation flows; the ETRM metadata notes it is referenced by zero other packages, confirming it is called exclusively through the Workflow subsystem rather than from other PL/SQL units. Customizations that require alternate approver resolution or an additional activation step should extend the Workflow process definition rather than modify this package, to preserve supportability.