How to Refresh Views After Defining a New Leaf Column (Doc ID 260881.1)

Last updated on JANUARY 13, 2010

Applies to:

Oracle Financial Data Manager - Version: 4.5.30 to 4.5.39
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Checked for relevance on 13-Jan-2010.

Goal

In Chapter 14, "FDM Leaf Management", the 4.5 OFSA Installation and Configuration Guide states the following regarding views:

The ADD_LEAF procedure does not modify views. Manually drop and re-create any views with the designated Table Classification assignments so that they include the new Leaf Column.

How does one identify and refresh these views?

Solution

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