Search Results iex_strategy_pub




Overview
Explore in AI Chat

Overview

APPS.IEX_STRATEGY_PUB is a public PL/SQL package within the Oracle E-Business Suite Advanced Collections (IEX) module. It serves as a core strategy execution and lifecycle management API for the Collections strategy engine. Strategies in Advanced Collections define automated rules, scoring models, and task-generation logic used to prioritize delinquent customers and drive collection activities. This package encapsulates the logic required to instantiate a strategy from a template, populate its working data, assign work items, and ultimately close the strategy once processing is complete. Because the package is classified as PUB (public), it is intended for supported invocation by other EBS APIs, concurrent programs, and controlled custom extensions rather than as an internal-only helper. It depends on APPS.IEX_STRATEGY_TYPE_PUB and the SYS STANDARD package, and it is referenced by four other packages: IEX_PROMISES_PUB, IEX_STRATEGY_CNT_PUB, IEX_STRY_API_PUB, and IEX_WF_BAN_STATUS_PUB. This reference pattern confirms its role as a foundational service consumed across the Collections and workflow integration layers.

Key Procedures and Functions

The package body documents five callable programs:

  • CREATE_STRATEGY — Creates a strategy instance, typically derived from a configured strategy template, establishing the record used throughout the strategy lifecycle.
  • SET_STRATEGY — Applies or updates the defining attributes of an existing strategy, allowing its configuration or state to be persisted.
  • GETSTRATEGYCURRENTWORKITEM — Returns the current work item associated with a strategy, used by callers that need to act on the active unit of collection work.
  • GETSTRATEGYTEMPID — Retrieves the temporary identifier assigned to a strategy during in-flight processing, supporting reference before permanent identifiers are finalized.
  • CLOSE_STRATEGY — Finalizes a strategy, marking it complete and releasing it from active processing.

Parameter signatures are not enumerated in the ETRM metadata and should be verified against the installed package specification for the specific release.

Tables Accessed

The package operates against the following documented tables through APPS synonyms:

Usage Notes

IEX_STRATEGY_PUB is typically invoked by the Collections strategy engine, concurrent programs that run strategy scoring and task generation, and dependent packages such as IEX_STRATEGY_CNT_PUB and IEX_STRY_API_PUB. Custom code should call only the documented public programs, commit work in accordance with the surrounding transaction, and avoid direct DML against the underlying strategy tables to preserve data integrity. Because behavior varies between 12.1.1 and 12.2.2, developers should always validate the package specification in the target instance before integrating.