LPN with Available Onhand Cannot be Issued After Account Alias Issue FRM-40212

(Doc ID 1517931.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


There are problem LPN's that can be viewed in MTL_ONHAND_QUANTITIES_DETAIL table, but not on the front end. Issue identified when trying to transact an Account Alias issue against these and it not showing up. LPN state is wrong when Account alias issue by LPN in Miscellaneous Transactions Form.

For Example:  There are four LPNs in parent LPN. Account alias issue two LPNs in Miscellaneous Transactions Form.The LPN state of the others LPN and parent LPN is issued out of stores.

The following error occurs:

FRM-40212: Invalid value for field LPN_NAME.

The issue can be reproduced at will with the following steps:
1. Go to: Inventory
2. Navigate to: Transactions > Miscellaneous Transactions
3. Choose Transaction Type: Account Alias Issue
5. Press Transaction Lines
6. Input LPN, get error.


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