My Oracle Support Banner

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)

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 ( Doc ID 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


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