My Oracle Support Banner

Cannot Reprint A Staged Dunning Letter (Doc ID 1306855.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

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


Unable to reprint the Staged Dunning Letter


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.


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
 1. Bug Summary
 2. Fixed Files

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