IEX: Send Dunnings for Delinquent Customers ends with Unexpected Exception while setup at Customer Level (Doc ID 1385653.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Advanced Collections - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Executable:IEX_SEND_DUNNING - IEX: Send Dunnings for delinquent customers

***Checked for relevance on 13-AUG-2013***

Symptoms

Running IEX: Send Dunning for Delinquent Customers ends with Unexpected Exception when run at the Customer/Party level. 

In the debug log you see:

=============
IEX_DUNNING_PVT Send_Level_Dunning - Other Exception 
unexpect exception 
IEX_DUNNING_PVT Send_Level_Dunning - error=ORA-00904: "HCA"."PARTY_ID":
invalid identifier
=============

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