Performance Issue with IEX: Bulk XML Delivery Manager When Processing Dunning for Strategies
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,
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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms