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 NOVEMBER 18, 2022
Applies to:
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 6.0 and laterOracle 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)
PFT BI
ALM BI
Symptoms
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:
ERROR
ORA-01427: single-row subquery returns more than one row
01427. 00000 - "single-row subquery returns more than one row"
*Cause:
*Action:
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.
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 |