ORA-01427: Single-Row subquery Returns More than One Row on TIME UPDATES (Doc ID 968822.1)

Last updated on JANUARY 24, 2012

Applies to:

Oracle Financial Services Profitability Analytics - Version: 4.5.39 to 4.5.41 - Release: 4.5 to
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
OBIEE
OFS-PA
Checked for relevance on 24-Jan-2012.

Symptoms

In Oracle Financial Services Profitability Analytics (OFS-PA), when you attempt to run the data load procedure OFS_BI_DATA_LOAD.OFS_BI_LOAD, the new data is not loaded and you receive an ORA-01427 error on TIME UPDATES in the OFS_BI_PROCESS_LOG table:

LOG_ID
RUN_DATE
INST_NAME
RESULT
REMARKS
333
04/22/2009
Process Status
F
Done Processing with Errors - Please see earlier error for Details

332
04/22/2009
General Error - Process Aborted
F
ORA-01427: single-row subquery returns more than one row
331
04/22/2009
TIME UPDATES

F
ORA-01427: single-row subquery returns more than one row


Steps to reproduce:
  1. Execute the OFS_BI_LOAD procedure:
    exec OFS_BI_DATA_LOAD.OFS_BI_LOAD;
  2. Review results of the load in OFS_BI_PROCESS_LOG :
    select * from OFS_BI_PROCESS_LOG order by log_id desc;

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