Search Results wf_itemkey




Overview
Explore in AI Chat

Overview

APPS.PO_REQ_WF_BUILD_ACCOUNT_INIT is a PL/SQL package body that supports the Oracle Workflow-driven account generator process for Purchasing requisition distribution accounting. In Oracle EBS 12.1.1 and 12.2.2, the account generator constructs charge account combinations for requisition distributions using the Workflow Engine. This package provides the initialization layer of that process: it generates the workflow itemkey, populates the Workflow item attributes required by subsequent account generation activities, and launches the workflow process that ultimately derives the code combination identifier. It also cooperates with budget, accrual, and variance sub-processes, exposing success flags for each so that the caller can determine which accounting branches completed.

The package header comment identifies the source file as POXWRQSB.pls and records an original creation date in 1997 and a modification for bug 669011 in 1998, confirming that it is a long-standing, shipped component of the Purchasing module rather than a customization artifact. The version string (120.1) indicates the release lineage carried forward into both 12.1.1 and 12.2.2.

Key Procedures and Functions

Three procedures/functions are documented for this package:

  • START_WORKFLOW — The principal entry point. It generates the itemkey, sets up Workflow item attributes through the Workflow API calls declared in the package (string, numeric, and date attribute setters), and starts the workflow process. Its signature exposes in-out success flags for charge, budget, accrual, and variance processing, together with an in-out code_combination_id that receives the resulting account. This function is what external callers invoke when they need the account generator to build a requisition distribution account.
  • DEBUG_ON — Enables diagnostic logging for the account generator workflow. The package body declares a PL/SQL boolean flag (debug_acc_generator_wf) and reads the profile option PO_SET_DEBUG_WORKFLOW_ON at initialization to establish the session default debug state.
  • DEBUG_OFF — Disables diagnostic logging, returning the package to normal (non-traced) operation.

Tables Accessed

The documented table references are almost entirely Oracle Projects lookup and hierarchy tables, which supply the validation and derivation metadata used by the account generator:

These reads are consistent with the account generator's need to validate project, task, expenditure type, and expenditure category segments before assembling the final code combination.

Usage Notes

This package is invoked indirectly rather than through a standard form or concurrent program. It executes inside the Purchasing account generator workflow, which is triggered when a requisition distribution requires an account and the account generator is enabled for the operating unit. The package is referenced by two other packages in the ETRM repository, indicating that it is called programmatically by higher-level requisition and workflow orchestration code.

The presence of itemkey handling explains why a search for wf_itemkey surfaces this object: the workflow item key is generated here and then used as the correlation identifier for every subsequent Workflow API call that sets item attributes and advances the process. Debugging is controlled at run time through DEBUG_ON and DEBUG_OFF, with the profile option PO_SET_DEBUG_WORKFLOW_ON governing the default. Because the package is an internal (non-API) component with header version 120.1, modifications should be avoided; diagnostics should instead be performed through the debug procedures and the workflow status monitor. In 12.2.2 the same logical behavior applies, though the account generator should be validated against the multi-org and subledger accounting configurations in effect.