Cannot Reprint A Staged Dunning Letter

(Doc ID 1306855.1)

Last updated on APRIL 18, 2017

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.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms