My Oracle Support Banner

Details Button On Movement Statistics Transactions Throws ORA-01422: exact fetch returns more than requested number of rows (Doc ID 1357832.1)

Last updated on SEPTEMBER 23, 2019

Applies to:

Oracle Supply Chain Globalization - Version 12.1.1 and later
Information in this document applies to any platform.
INVTTMVT


Symptoms

When attempting to query certain return to vendor records in the Movement Statistics transactions form (INVTTMVT), the following error occurs.

ERROR

The behavior persists after applying Patch 12548575:R12.INV.B

STEPS
1. Inventory => Transactions => Movement Statistics
2. Search the records in Find Movement Statistics window
3. Press Details button and observe the error

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


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