My Oracle Support Banner

Some Transactions Get Stuck In WSH_ITM_REQUEST_CONTROL Table With Process Flag -2 When Submitting Large Volume Of Records In ITM to GTM (Doc ID 2277375.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms


ACTUAL BEHAVIOR
---------------
Some International Trade Management(ITM) Requests remain stuck in WSH_ITM_REQUEST_CONTROL table with process_flag as '-2'.  The transactions do not progress to Global Trade Management (GTM).
A workaround to progress and clear stuck requests is to shutdown and restart the ITM Adapter.


EXPECTED BEHAVIOR
-----------------------
ITM Transactions do not get stuck in -2 status and all transactions are processed.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Order Management Super User Responsibility
2) Enter sales order
3) Run the Item Synchronization program
4) Book Sales order simultaneously while Item Synchronization is running
5) Once sales order books , lines are automatically sent to ITM
6) Check in WSH_ITM_REQUEST_CONTROL table if no record is stuck with status -2


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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