My Oracle Support Banner

ALM Process Fails with Blank 'Delete from' Statements at End of Log File (Doc ID 1340917.1)

Last updated on MARCH 07, 2019

Applies to:

Oracle Financial Services Asset Liability Management - Version 5.2 to 5.5 [Release 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

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.