No Data Found Error When Attempting to Use Identity Code in a Ledger Stat Filter (Doc ID 1160519.1)

Last updated on JULY 30, 2010

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 and later   [Release: 7 and later ]
Linux x86
Oracle Financial Services Analytical Applications (OFSAA) 7.1
Migration from OFSA 4.5

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.1, in an environment migrated from OFSA 4.5, you cannot create a filter on the Ledger Stat column Identity Code. When you select the Identity Code column, you receive the following message:

No Data Found

Additionally, if you try to edit existing Filters migrated from OFSA 4.5 that already use Identity Code, null values are displayed.  If you run a process using one of these filters, the process runs with no data found.

Steps to Replicate:
  1. Go to Financial Services Applications
  2. Go to Master Maintenance > Filters
  3. Click the Add button to make a new Filter
  4. Select Filter Type = Data Element
  5. Go to Data Element Selection
  6. Select Entity Name = Ledger Stat, select the Identity Code member, and click the select arrow.
  7. Click OK

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