My Oracle Support Banner

'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.


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:

Rule Name: Update_Dimension_Code
Parameters: 3

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.