ALM Process Fails with Blank 'Delete from' Statements at End of Log File

(Doc ID 1340917.1)

Last updated on AUGUST 07, 2011

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.2 to 5.5 - Release: 5 to 5
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 5.5, when you run an ALM process, no rows are output to the Result Detail table and the ofsrm log file in $FIC_DB_HOME/logs/FusionApps contains the following bad SQL statements at the end:

Module Logging OFS Access module data: delete
delete from

Module Logging OFS Access module data: delete
delete from

The bad SQL prevents ALM from generating output.

Steps to Reproduce:
  1. Go to Asset Liability Management
  2. Go to ALM Processing > Static Process > Static Deterministic
  3. Create and run an ALM Process

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms