My Oracle Support Banner

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 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 <Document 1302923.1>.


|SEVERE||Error code returned : 1493690431
|SEVERE||Stored procedure execution failed


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

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