Inventory Transaction Worker Peroformance Issue
We are facing performance issue with Inventory Transaction Worker (ORG) for organizations enabled with India Localization.
We are having a multi-org structure (India, Uk, China, US). There is a common custom program which is responsible for pulling the Job Completion data from our assembly system and insert it into Material Transaction Interface.
This program then invokes WIP Move Processor to move the assembly and then invokes Inventory Transaction Worker to process records in material transaction interface.
ITW takes more time to process records belonging to India organization (with India Localization patch) whereas for other orgs it completes within seconds. Now since ITW is common to all orgs poor performance for one org is impacting all the other orgs and often we have scenario where there are multiple ITW waiting in queue. This poor performance has impacted our customer deliveries in past as transactions did not got completed on time and there were lot of pending requests in queue.