WIP Material Transaction Form (WIPTXMAT) Shows Incorrect On-hand and Available Quantities for lot controlled items

(Doc ID 1392258.1)

Last updated on MARCH 21, 2012

Applies to:

Oracle Inventory Management - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.


On form WIPTXMAT "Material Transactions", if entering subinventory in transaction field, on FORM "Lot Entry", system will show incorrect quantity available; If without entering the value in subinventory under transaction field, this problem will work within normal function.

The issue can be reproduced at will with the following steps:
1. Switch to WIP Responsibility
2. Navigate to Material Transactions>WIP Material Transactions
3. Query job 1110200121402ED
    Transaction type: WIP issue
    Subinventory Code: BC1B02A
4.Enter following information, and then Click on Lot/Serial
   Item CDS5114*FOG**F
   Revision: null
   Subinventory: BC1B02A
5.FORM"Lot Entry"
   Lot numbers information:
   - Lot number:11102001214038D
   - Expiration date:07-OCT-2012
   - Quantity:100
   The system shows incorrect quantity available as following:
    Available quantity: -28575
    On-hand quantity: 150


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