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 JUNE 13, 2016

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)
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

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