My Oracle Support Banner

Cannot Reprint A Staged Dunning Letter (Doc ID 1306855.1)

Last updated on JULY 17, 2018

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Unable to reprint the Staged Dunning Letter

Changes

Due to code issue in IEX_SEND_XML_PVT package. The Send_Copy function at line 516 attempts to retrieve the query_temp_id for a given query_id. However, on reprint, the query_temp_id of the original dunning query is passed to Send_Copy via p_query_id (not the query_id) and subsequently the l_query_temp_id variable is NULL. The IEX_XML_PKG.insert_row is subsequently called but fails to insert as referential integrity on the IEX_XML_REQUEST_HISTORIES insists on l_query_temp_id being NOT NULL.

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
References


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