EGL9.2: Cross Reciprocal Rate Calculation SQR EO9030 Runs To Error 'single-row subquery returns more than one row'
(Doc ID 2682648.1)
Last updated on MAY 12, 2021
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Cross Reciprocal Rate Calculation SQR EO9030 Runs To Error 'single-row subquery returns more than one row'
SQL Status = 512, SQL Error = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Issue can be reproduced at will with the following steps:
1. Run Reciprocal rate SQR
2. From Currency USD , To Currency =%
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