My Oracle Support Banner

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.


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;


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.