Results for “stg_dunning_mig_concur”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.IEX_DUNNING_PUB is the public API package within the Oracle E-Business Suite Advanced Collections (IEX) module responsible for driving the dunning process. Dunning is the systematic process of contacting delinquent customers to collect overdue receivables. This package orchestrates the identification of delinquent customers, the generation of dunning letters and correspondence through Oracle Receivables letter sets, the delivery of dunning communications, and the recording of dunning activities against customer accounts. It also maintains the relationship between collection agents and dunning plans through its XREF management procedures.

Classified as a PUB (public) API, IEX_DUNNING_PUB is the supported entry point for external callers, while the underlying implementation resides in the companion package IEX_DUNNING_PVT. The package owner is APPS, and its status is VALID. It sits within a layered architecture: IEX_DUNNING_PUB is referenced by IEX_DELINQUENCY_PUB, IEX_STRATEGY_WORK_PUB, the wrapper packages IEX_DUNNING_PUB_W, and by its private counterpart IEX_DUNNING_PVT. This dependency chain confirms that dunning execution is typically driven by delinquency scoring and collection strategy processing rather than invoked in isolation.

Key Procedures and Functions

The package exposes nine documented procedures that fall into three functional groups.

• Agent-to-Dunning-Plan Cross-Reference Maintenance: CREATE_AG_DN_XREF, UPDATE_AG_DN_XREF, and DELETE_AG_DN_XREF manage the association between collection agents and dunning plans stored in IEX_AG_DN_XREF. These procedures keep the agent/dunning configuration aligned as collection organizations are reorganized or plans are reassigned.
• Core Dunning Execution: SEND_DUNNING initiates the delivery of dunning correspondence for qualifying delinquencies. CLOSE_DUNNING terminates an active dunning cycle, typically once payment is received or the delinquency is resolved. DAILY_DUNNING supports the recurring batch evaluation of delinquencies and generation of dunning output. SEND_DUNNING_CONCUR provides the concurrent-program wrapper that invokes the send logic under a concurrent request.
• Concurrent and Migration Support: CALLBACK_CONCUR is the standard concurrent manager callback used to coordinate request completion. STG_DUNNING_MIG_CONCUR supports staging and migration of dunning data, reflecting the tools Oracle provides for onboarding or converting dunning configuration and history.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms.

• Dunning configuration: IEX_DUNNING_PLANS_B, IEX_DUNNING_PLANS_S, and IEX_DUNNING_PLANS_TL hold the base, sequence, and translated (MLS) definitions of dunning plans, including the letter sets and schedules that govern outreach.
• Dunning transactions and history: IEX_DUNNINGS, IEX_DUNNING_TRANSACTIONS, IEX_DELINQUENCIES, and IEX_DELINQUENCIES_ALL record the delinquent items and the dunning actions taken against them.
• Agent/plan mapping: IEX_AG_DN_XREF and IEX_AG_DN_XREF_S back the cross-reference procedures.
• Receivables integration: AR_DUNNING_LETTER_SETS, AR_DUNNING_LETTER_SET_LINES, and AR_PAYMENT_SCHEDULES_ALL supply the letter set definitions, their constituent letters, and the receivable instalments that determine delinquency.
• Supporting reference data: HZ_CUST_SITE_USES_ALL supplies customer site information, IEX_APP_PREFERENCES_B provides application-level preferences, and FND_LANGUAGES supports multilingual letter generation.

Usage Notes

IEX_DUNNING_PUB is most commonly invoked indirectly through the Advanced Collections concurrent programs that run daily dunning and send dunning correspondence. Collection agents trigger dunning activity from the Collections workbench forms, which call through IEX_DELINQUENCY_PUB and IEX_STRATEGY_WORK_PUB. Direct calls should be restricted to the documented public procedures; custom code must not invoke IEX_DUNNING_PVT, as the private package interface is not guaranteed across patches. Because the package is referenced by IEX_DUNNING_PUB_W, customers extending dunning behavior should treat the public signatures as the stable contract. Any migration routines (STG_DUNNING_MIG_CONCUR) should be scheduled during low-activity windows, as they can process large volumes of delinquency and dunning history.