Writeback Export Failing With Error-ORA-01427: Single-row Subquery Returns More Than One Row (Doc ID 2288457.1)

Last updated on AUGUST 03, 2017

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.100 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.4.100 version, Integration

When attempting to WriteBack (HP to EBS), Import & Validate are working fine but the issue with only Export.

Error :

 DEBUG [AIF]:
  UPDATE TDATASEG
  SET ATTR1 = (
  SELECT mem.ACCOUNT_TYPE
  FROM AIF_DIM_MEMBERS_STG mem
  ,AIF_SOURCE_SYSTEMS ss
  WHERE ss.SOURCE_SYSTEM_ID = x
  AND mem.SOURCE_SYSTEM_ID = ss.SOURCE_SYSTEM_ID
  AND mem.VALUE_SET_ID = 111111
  AND mem.VALUE_NAME = TDATASEG.UD3X
  AND mem.LANGUAGE = ss.BASE_LANGUAGE
  )
  WHERE LOADID = yyyy
  AND PARTITIONKEY = 'y'
  AND CATKEY = z
  AND RULE_ID = n
  AND UD3X IS NOT NULL
  AND (ATTR1 IS NULL OR ATTR1 = '')
  
 FATAL [AIF]: Error in CommData.updateWBAttrColumns
Traceback (most recent call last):
  File "", line 6263, in updateWBAttrColumns
SQLException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row



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