My Oracle Support Banner

Severe Performance Issue when Running Party Synchronization to Process Thousands of Contacts for ITM/GTM (Doc ID 2325472.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Shipping Execution - Version 12.2.6 and later
Information in this document applies to any platform.


On :  12.2.6 version, Intl Trade Mgmt Integration with GTM

Party sites with huge number of contacts taking time to process during ITM/GTM Party Synchronization

Expect the ITM Adapter to complete in less than 5 minutes to process party synchronization records

The issue can be reproduced at will with the following steps:
1.  Ran the 'Party Sync' for 3 customers (created in last and last updated in, parameters blank).
2. The party sync completed in less than 1 min.
3.  Adapter startup program running in the background picks up the records for processing.
4.  Adapter changes the process_flag for the 3 records in the ITM control table from 0 to -2. It starts processing them.
5.  Depending on the size of the customer i.e. no. of bill/ship/end customer sites, adapter processed 2 records in 60 mins, and even longer to process the 3rd record

The issue has the following business impact:
Due to this issue, users cannot complete Party Synchronization within a reasonable time frame.   This fails to update the Restricted Party List on a timely  basis which may result in certain orders passing export screening and being shipped to parties that should have been on the restricted party list.


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.