'ORA-01422: Exact Fetch Returns More Than Requested Number of Rows' Running Update_Dimension_Code
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:
- Go to Operations > Batch Maintenance
- Create a new Batch
- Create a new task under the batch with the following:
Component: TRANSFORM DATA
Rule Name: Update_Dimension_Code
The ORA-01422 error is output to FSI_MESSAGE_LOG for the Batch.
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