Processing A Return Receiving Transaction After Populating The Receiving Open Interface Tables Results In Error "Tried to modify quantity onhand at level other than locator or subinventory level"
(Doc ID 2878520.1)
Last updated on JUNE 22, 2022
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
The following error message is seen the the PO_INTERFACE"_ERRORS table after a manually created Return Receiving Transaction is processed by the Receiving Transaction Processor (RTP).
Tried to modify quantity onhand at level other than locator or subinventory level.
Cause: The system has some type of error which tried to modify quantity onhand at a level other than locator or subinventory.
Cause: The system has some type of error which tried to modify quantity onhand at a level other than locator or subinventory.
The message name for this error message is: INV-WRONG_LEVEL.
Steps
- Populate table RCV_TRANSACTIONS_INTERFACE with the transaction.
- Populate table MTL_LOTS_INTERFACE table as this is a lot controlled item.
- Allow the Receiving Transaction Processor to process the transaction.
- See the error in the PO_INTERFACE_ERRORS table.
SQL> select error_message from PO_INTERFACE_ERRORS where error_message like '%Tried to modify quantity%';
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |