Search Results create_workitem_complete

Overview

IEX_STRY_UTL_PUB is a public utility package in the Oracle E-Business Suite (EBS) Advanced Collections (IEX) module. It provides the underlying programmatic infrastructure for managing the lifecycle of collection strategies and their associated work items. In the Advanced Collections data model, a strategy is a defined sequence of collection actions — calls, letters, tasks — that a collector must perform against a delinquent customer account. Each discrete unit of work generated from a strategy is a work item, and this package supplies the APIs that Advance Collections internal code and external callers use to create, advance, reassign, close, and summarize those work items.

The package is classified as a public (PUB) API, indicating that its documented procedures constitute a supported interface rather than a package-private implementation detail. It is referenced by seven other packages, confirming its role as a shared utility layer rather than a single-purpose routine. The body header (iexpsutb.pls, version 120.9.12020000.3) dates to 2012 and is delivered in both the 12.1.1 and 12.2.2 release families. The script opens with several shared diagnostic helpers — AddInvalidArgMsg, AddMissingArgMsg, and AddNullArgMsg — that standardize the FND_MESSAGE error messages raised when callers pass bad, missing, or null arguments, which is the expected defensive pattern for a well-formed public API.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions that fall into four functional groups.

• Work item retrieval and advancement: GET_NEXT_WORK_ITEMS returns the next set of work items a collector should action, and UPDATE_NEXT_WORK_ITEM advances the strategy to the following item. UPDATE_WORK_ITEM is the core routine the user searched for; it updates the attributes of an existing strategy work item, such as its status, outcome, or scheduling fields, after a collector has completed an action.
• Status and closure: CHECK_WORK_ITEM_STATUS validates the current state of a work item and is typically used as a precondition before an update or close. CLOSE_STRY_AND_WITEMS and CLOSE_STRATEGY terminate the strategy and cascade closure to its child work items.
• Creation and signaling: CREATE_WORKITEM_CHECK and CREATE_WORKITEM_COMPLETE create work items in the check and complete states respectively. UPDATE_AND_SENDSIGNAL updates a work item and raises the associated workflow event in one call, and UPDATE_WF_ATTRIBUTES synchronizes Oracle Workflow item attributes.
• Utility and refresh: GET_DATE returns the effective date used for scheduling. CLEAR_UWQ_STR_SUMM and REFRESH_UWQ_STR_SUMM clear and rebuild the Universal Work Queue strategy summary. REASSIGN_STRATEGY moves a strategy, and its open work items, to a different collector or resource.

Tables Accessed

The package reads and writes the core Advanced Collections strategy tables: IEX_STRATEGIES, IEX_STRATEGY_WORK_ITEMS, IEX_STRATEGY_USER_ITEMS, IEX_STRY_TEMP_WORK_ITEMS_B, and IEX_STRATEGY_WORK_TEMP_XREF. It maintains the Universal Work Queue summary through IEX_DLN_UWQ_SUMMARY, and resolves collector identity via JTF_RS_RESOURCE_EXTNS. WF_EVENT_T is used for workflow signaling, MTL_UOM_CONVERSIONS for unit-of-measure handling on amounts, and DUAL for scalar lookups.

Usage Notes

IEX_STRY_UTL_PUB is normally invoked indirectly. Advanced Collections forms, the strategy management concurrent programs, and the work item generation and work queue refresh processes call these APIs rather than issuing direct DML against the underlying tables, which keeps strategy state consistent and fires the necessary workflow events. Custom integrations — for example, an external dialer or CRM front end — should call UPDATE_WORK_ITEM or UPDATE_AND_SENDSIGNAL to complete a work item, and CHECK_WORK_ITEM_STATUS beforehand, so that UWQ summaries and strategy sequencing remain synchronized.