My Oracle Support Banner

BSP Calculate Fails with ORA-01403: NO DATA FOUND and 'Oracle ALM Process Rule (xxxxxx) not found in database.' (Doc ID 2731543.1)

Last updated on NOVEMBER 26, 2020

Applies to:

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

Symptoms

When trying to execute a Calculate in BSP, the cash flow engine process fails with the following error:

From the BSPCalculation_UnpricedAcc_udf.log:

ProcSysID = 123456
Running Oracle ALM, Process Rule: 123456 Engine started execution
1 | OFSAA.EXEC_STARTED | INFORMATION
2 | OFSAA.EXEC_FAILED | FATAL
Final CFE return status :100
CFE execution Failed

From FSI_PROCESS_ERRORS:

Oracle ALM Process Rule (123456) not found in database.

From FSI_BSP_PROCESS_LOG:

For V_PROCESS_CODE = FN_BSP_PROCESSING:

POPULATION OF BSP PROCESSING TABLES STARTED [MSG-INFORM]: PR_BSP_PROCESSING PROCEDURE STARTED  STG - 1
POPULATION OF BSP PROCESSING TABLES ON GOING [MSG-INFORM]: DEFAULT PRODUCT DIMENSION : DIM_PRODUCTS_HIER AND DEFAULT ORG_UNIT DIMENSION : DIM_ORG_UNIT_HIER  STG - 6
POPULATION OF BSP PROCESSING TABLES FAILED [MSG-FATAL]: ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01403: NO DATA FOUND  STG - 10C

As a result, no output is generated for the Calculate

Cause

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
Symptoms
Cause
Solution


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