Ledger Stat Load Error: ORA-06512: single-row subquery returns more than one row (Doc ID 359829.1)

Last updated on MARCH 13, 2006

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5
This problem can occur on any platform.
ofsa_util.ledger_stat_load

Symptoms

The following error occurs when executing the LEDGER_STAT Load utility:

(203105) Oracle drv_oci error:
OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-06512: single-row subquery returns more than one row
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "dbowner.OFSA_UTIL", line 2210
ORA-06512: at line 1
Driver Function: drv_oci::Execute()
SQL Statement: BEGIN ofsa_util.ledger_stat_load;END;

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