ALMBI SCD Issue ORA-01427: Single-row Subquery Returns More Than One Row Error For DIM_PRODUCT_V
(Doc ID 1575443.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Financial Services Asset Liability Management Analytics - Version 6.0 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Asset Liability Management Analytics (ALMBI), when running the SCD for the Product dimension, the following error is returned for the DIM_PRODUCT_V:
ORA-01427: single-row subquery returns more than one row
01427. 00000 - "single-row subquery returns more than one row"
The issue can be reproduced at will with the following steps:
1. Check the SQL for dim_product_v used in the SCD for the product dimension.
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