Cannot Reprint A Staged Dunning Letter
(Doc ID 1306855.1)
Last updated on JUNE 05, 2024
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!
