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 laterInformation 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 |