'ORA-01422: Exact Fetch Returns More Than Requested Number of Rows' Running Update_Dimension_Code

(Doc ID 1367973.1)

Last updated on APRIL 15, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 15-Apr-2013.

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) infrastructure, when you run the "Update_Dimension_Code" (fn_updatedimensioncode) program to populate the <Dimension>_CODE column (ex. COMMON_COA_CODE) column on the DIM_<Dimension>_B table (ex. DIM_COMMON_COA_B), the program fails to update the column.  You see the following error in FSI_MESSAGE_LOG:

Starting Updation of Code column
ORACLE ERROR. ORA-01422: exact fetch returns more than requested number of rows

This error prevents you from populating the CODE column which is often required for T2T data loading.

Steps to Reproduce:

  1. Go to Operations > Batch Maintenance
  2. Create a new Batch
  3. Create a new task under the batch with the following:

Component: TRANSFORM DATA
Rule Name: Update_Dimension_Code
Parameters: 3

The ORA-01422 error is output to FSI_MESSAGE_LOG for the Batch.

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