Unable To Enter A Serial Number In Receipt APP-INV-05577 / DataFix For Current Status = 6
Last updated on DECEMBER 02, 2016
Applies to:Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12 and later
When attempting to enter a receipt for a serialized item, the following error occurs after entering the serial number. The item in question has not been received and the serial number in question cannot be found in inventory.
1. Goto Inventory > Transactions > Receiving > Receipts
2. Find the related receipt.
3. Check the box to receive items
4. Enter the quantity / subinventory to receive.
5. Enter the serial numbe.r
6. Receive the error.
Due to this issue, users cannot receive the item into stock.
The onhand quantity / available quantity is incomplete within the application.
The following script can be used to verify your issue is similar to the one in this note. The script result shows that the status is pending (current_status = 6) for the serial number. Here is the script:
from mtl_serial_numbers msn
where msn.current_status = 6
and msn.serial_number = '&EnterYourSerialNumber';
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