Performance Issue with IEX: Bulk XML Delivery Manager When Processing Dunning for Strategies (Doc ID 2257677.1)

Last updated on APRIL 21, 2017

Applies to:

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

Symptoms

IEX: Bulk XML Delivery Manager takes 10 hours to process when processing Dunning for Strategies

Running the following select shows that there are thousands of "In Process" records on Closed Strategies:

1. select a.xml_request_id, a.status, a.object_type, b.dunning_id, b.status, b.correspondence_date
from iex_xml_request_histories a,
iex_dunnings b
where a.status = 'IN PROCESS'
and a.xml_request_id = b.xml_request_id;

2. select object_type,status,max(LAST_UPDATE_DATE) last_processed_time,count(xml_request_id) cnt from iex_xml_request_histories group by object_type,status;

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