Populate_Dim_Run_ALM Batch Failed With "Stored procedure execution failed" Error
(Doc ID 2509207.1)
Last updated on JULY 26, 2019
Applies to:Oracle Financial Services Asset Liability Management Analytics - Version 8.0.5 and later
Information 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)
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 ( Doc ID 1302923.1 ).
|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
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