Search Results iex_strategy_cnt_pub




Overview
Explore in AI Chat

Overview

IEX_STRATEGY_CNT_PUB is a public PL/SQL package in the Oracle E-Business Suite Advanced Collections (IEX) module, owned by the APPS schema and defined with AUTHID CURRENT_USER. Its business purpose is to serve as the strategy control driver for the Collections strategy engine. It coordinates the lifecycle of collection strategies — opening, closing, and processing them on hold — by evaluating delinquency, scoring, promise, bankruptcy, and party data against the rules configured for each strategy.

The package header lineage reflects its evolution across releases. The earliest commented-out signature (open_strategies with only ERRBUF and RETCODE) was superseded by an enhanced version, and header comments reference performance improvements (Bug 4924879), removal of a trace-mode parameter (Bug 5022607), addition of strategy-mode and output-display parameters (Bug 8630852), and an additional dummy parameter added for Bug 13377466. These are consistent with an actively maintained Collections engine component spanning the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

  • OPEN_STRATEGIES — Opens collection strategies for processing, accepting an ignore-switch flag, a strategy mode (defaulting to FINAL), and a show-output switch.
  • CLOSE_STRATEGIES — Closes strategies that have completed processing, with strategy-mode and show-output parameters.
  • PROCESS_ONHOLD_STRATEGIES — Handles strategies placed in an on-hold state, taking strategy-mode and show-output parameters (Bug 7248296).
  • CLOSE_ALL_STRY — Closes all strategies in bulk, using only the standard ERRBUF and RETCODE concurrent-program output parameters.
  • MAIN — The primary orchestration entry point, accepting an organization ID, ignore-switch, strategy mode, show-output flag, and an additional dummy parameter, and driving the overall strategy generation cycle.
  • GETSTRATEGYTEMPID — Returns a temporary identifier used during strategy processing.
  • WRITE_LOG — Writes diagnostic and processing information to the log for troubleshooting and audit purposes.

Tables Accessed

The package reads and writes across the core Collections, Receivables, and Trading Community data model. Strategy engine tables include IEX_STRATEGIES, IEX_DELINQUENCIES_ALL, IEX_SCORE_HISTORIES, IEX_PROMISE_DETAILS, IEX_QUESTIONNAIRE_ITEMS, IEX_OBJECT_FILTERS, IEX_APP_PREFERENCES_B, and IEX_BANKRUPTCIES, which supply the rules, scores, promises, questionnaire responses, filtering criteria, preferences, and bankruptcy status used to evaluate each customer. Receivables data is drawn from AR_PAYMENT_SCHEDULES_ALL to assess outstanding balances and due dates, and from AR_SYSTEM_PARAMETERS_ALL for system-level Collections configuration. Customer and party context comes from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, and HR_ALL_ORGANIZATION_UNITS_TL for organization and operating-unit resolution.

Usage Notes

IEX_STRATEGY_CNT_PUB is a control-layer package rather than an interactive API. It is typically invoked by the Collections concurrent programs and by the Advanced Collections workbench forms that generate and refresh strategies. The standard ERRBUF and RETCODE parameters follow the Oracle concurrent-program convention, indicating that procedures such as OPEN_STRATEGIES, CLOSE_STRATEGIES, CLOSE_ALL_STRY, and MAIN are registered as concurrent program executables. The show-output and strategy-mode parameters support running the engine in draft versus final mode and controlling log verbosity. Because no other packages reference it, custom integrations should call the documented public procedures directly and avoid reliance on internal GETSTRATEGYTEMPID or WRITE_LOG behavior beyond logging purposes.