BSP Cash Flow Engine Fails With Error: ORA-01422:Exact Fetch Returns More Than Requested Number of Rows (Doc ID 2081649.1)

Last updated on APRIL 26, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

While running BSP 6.0.1 cash flow, the current position process failed for current business with error saying "Function failed with generic exception"

ERROR
In file BSPCalculation_UnpricedAcc_udf.log:

2015-10-13 15:32:56,351 INFO  com.oracle.bsp.udf.BSPCfeCall :: Procedure PR_NB_CREATE_TBL  is not exceuted either processId is not a valid or its not a new Bussiness scenario
2015-10-13 15:32:56,351 INFO  com.oracle.bsp.udf.BSPCfeCall :: ++++++++++++++++++++++++++++++++++++++++++++++++++++
2015-10-13 15:32:56,351 INFO  com.oracle.bsp.udf.BSPCfeCall :: CFE is  not exceuted because function failed with the exception
2015-10-13 15:32:56,351 INFO  com.oracle.bsp.udf.BSPCfeCall :: ================================================
2015-10-13 15:32:56,351 INFO  com.oracle.bsp.udf.BSPCfeCall :: Status : -1 Process Id : -999
2015-10-13 15:32:56,351 INFO  com.oracle.bsp.udf.BSPCfeCall :: Procedure PR_RES_DET_IMPORT  is not exceuted because CFE execution failed or function failed with generic exception

and

From file: FSI_BSP_PROCESS_LOG:

ON GOING [MSG-INFORM]: DEFAULT PRODUCT DIMENSION : DIM_COMMON_COA_HIER AND DEFAULT ORG_UNIT DIMENSION : DIM_ORG_UNIT_HIER
FAILED [MSG-FATAL]: ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01422: EXACT FETCH RETURNS MORE THAN REQUESTED NUMBER OF ROWS
STARTED [MSG-INFORM]: PR_BSP_PROCESSING PROCEDURE STARTED
ON GOING [MSG-INFORM]: DEFAULT PRODUCT DIMENSION : DIM_COMMON_COA_HIER AND DEFAULT ORG_UNIT DIMENSION : DIM_ORG_UNIT_HIER
FAILED [MSG-FATAL]: ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01422: EXACT FETCH RETURNS MORE THAN REQUESTED NUMBER OF ROWS

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