My Oracle Support Banner

Detcfrun.dis Discoverer Report Columns Are All Blank - DECODE Does Not Work in OFSA 4.5 (Doc ID 287354.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5 to 4.5.41
Oracle Financial Data Manager - Version 4.5 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

The Risk Manager (RM) standard report DETCFRUN.DIS only returns blank values for the columns Beginning Balance, Ending Balance, Payment Runoff - Positive, etc.  Data does exist in the background table OFSA_PROCESS_CASH_FLOWS.

In Discoverer Desktop, if you go to Tools > Options... > Formats tab and change "Show values that can not be aggregated as:" to "N.A.", the blanks in the DETCFRUN.DIS report change to "N.A.", indicating that these values cannot be aggregated.

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!


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