Populate_Dim_Run_ALM Batch Failed With "Stored procedure execution failed" Error
(Doc ID 2509207.1)
Last updated on APRIL 24, 2023
Applies to:
Oracle Financial Services Asset Liability Management Analytics - Version 8.0.5 and laterInformation in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
Populate_Dim_Run_ALM batch fails to run after re-deploying the OFSAA .EAR in Weblogic.
This procedure used to work fine before this.
There are no records for this batch_run_id in FSI_MESSAGE_LOG table.
Redeployment was done as per KM note: How to Redeploy OFSAA for WebLogic Web Server <Document 1302923.1>.
ERROR
|SEVERE||Error code returned : 1493690431
|SEVERE||Stored procedure execution failed
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Login to OFSAA.
2. Run Populate_Dim_Run_ALM batch.
Note: You get the following additional error is you run the function directly in SQL*Plus:
ORA-00904: "P_MIS_DATE": invalid identifier
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 |
| References |