My Oracle Support Banner

Dunning Letter Fail "Sending Process Failed: Missing Email Address." (Doc ID 943724.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Advanced Collections - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Within Advanced Collections, when fulfilling the Dunning Letter work item with type = "Send Email", workflow errors with the message:

           "Sending process failed: missing email address." IEX_SEND_FAILED_NO_EMAIL

Within the FND Debug Message Log you will see additional errors:

The workflow will fail within IEX_DUNNING_PVT.GET_CUST_DUNNING_DATA_OW when calling the cursor get_site_loc, receiving the error "IEX_DUNNING_PVT GET_CUST_DUNNING_DATA_OW - Other Exception error=ORA-01427: single-row subquery returns more than one row".

This happens when a contact is attached to multiple accounts or multiple sites.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.