Cannot Reprint A Staged Dunning Letter
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