ITM Transactions Stuck In WSH_ITM_REQUEST_CONTROL Table With Process Flag -2 (Doc ID 2277375.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

On : 12.1 version, Integrations & Conc. Program

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


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


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