ALMBI SCD Issue ORA-01427: Single-row Subquery Returns More Than One Row Error For DIM_PRODUCT_V
Last updated on MAY 03, 2018
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.
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