My Oracle Support Banner

Production Batch Transact Move Order Gives Error: "ORA-01427 Single-row Subquery Returns More Than One Row" (Doc ID 1684195.1)

Last updated on JANUARY 23, 2023

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.       


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.