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.
WIPTXMAT.fmb

Symptoms

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.

STEPS
-----------------------
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
   Quantity:100
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

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