Production batch Transact move Order - error : ORA-01427 Single-row Subquery Returns More Than One Row

(Doc ID 1684195.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.


On :  12.1.3 version, Batches

Can't transact move order issue from multiple lot or locators because of the following error:

Ora-01427 single-row subquery returns more than one row

The issue can be reproduced at will with the following steps:
1. Created a formula, recipe, then create a batch            
2. Perform batch picking and make sure that hand should be in such a way that multiple allocations is created, this creates a Move order with multiple allocation for ingredient                 
3. Go to Transact move order form and query the move order   
4. Try to transact, getting above error

The issue has the following business impact:
Due to this issue, users cannot transact move order with multiple allocations.       


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