Getting Error while Creating Receipt Batch: "ORA-01422: exact fetch returns more than requested number of rows"
(Doc ID 2992000.1)
Last updated on MAY 20, 2024
Applies to:
Oracle Receivables - Version 12.2.1 and laterInformation in this document applies to any platform.
Symptoms
Getting below Error while creating the Receipt Batch "Manual-Quick":
ERROR
---------
ORA-01422: exact fetch returns more than requested number of rows
FRM-40735: WHEN-LIST-CHANGED trigger raised unhandled exception ORA-01422.
Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Receivables Manager
2. Receipts > Batches
3. Batch Type = Manual-Quick
Changes
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 |
Changes |
Cause |
Solution |