My Oracle Support Banner

FAQ: Poor Performance for Inventory Transactions : Worker, Interface Transactions, Serial Numbers (Doc ID 146961.1)

Last updated on MAY 01, 2023

Applies to:

Oracle Inventory Management - Version and later
Information in this document applies to any platform.
EXECUTABLE:INCTCW - Inventory transaction worker


Run into performance issues with the Inventory Transaction Worker (INCTCW) Performance issue.
This could relate to loading transaction data into the Inventory Transaction Open Interface from an external system. It could also relate to running the transaction manager for any large volumes of data, for example, sales order issue transactions.

1. Load data into the transaction interface (and possibly serial interface) table:


2. Navigate to Inventory > Setup > Transactions > Interface Managers

3. Put the cursor on the Inventory Transaction Manager

4. Choose Tools > Launch

5. The system takes over an hour (or many hours) to process the records

Diagnosing Performance

Powerpoint : link / Recording: Link. (Powerpoint used in April 16, 2014 Webcast. See <Note 1290983.1> for details.)

Troubleshooting Steps

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
Troubleshooting Steps
 1. Latest Patches?
 2. Application Setups?
 3. Database Issues?
 4. Tracing Techniques
 a. Trace Creation Tools
 b. Trace Report Tools

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