Dunning Letter Program Using Incorrect Template (Doc ID 1236233.1)

Last updated on APRIL 18, 2017

Applies to:

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

Symptoms

IEX: Send Dunning to Delinquent Customers is using the wrong template after the application of Patch 9411029 - IEX:PATCH FOR MAY 2009 POST IEX 12.0.6 FIXES &
Patch 9458450 - PATCH FOR NOVEMBER 2009 POST IEX 12.0.6 FIXES

Your custom templates/queries were assigned ID's. When patch was applied, new seeded templates/queries took the same ID's. When the Dunning Letter is generated it is taking the wrong letter because the ID's are used twice.

The new patches recently applied have added duplicate records in the
IEX_QUERY_TEMP_XREF table.

 


Changes

 

Cause

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