Unable To Do Move Transactions For Lot Based Job. Errors: "Invalid Job" and "ORA-01422: exact fetch returns more than one requested number of rows" (Doc ID 2016593.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Shop Floor Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On WSM/OSFM  - Oracle Shop Floor Manufacturing, 11.5.10.2 version, WIP Lot Transactions

Unable to perform move transaction for a specific Lot based Job the following error occurs.

ERROR
-----------------------
ORA-01422: exact fetch returns more than one requested number of rows
Invalid Job.

STEPS
-----------------------
The issue cannot be reproduced at will:

1. Shop Floor Manager

2. Lot Transactions > Move Transactions

3. Enter the problematic job.

Cause

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