REV_LEAF_REGISTRATION Function Missing After Installing PFT, FTP, or ALM 6.0 (Doc ID 1605825.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Profitability Management - Version 6.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Oracle Financial Services Asset Liability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After installing Oracle Financial Services Profitability Management (PFT), Funds Transfer Pricing (FTP), or Asset Liability Management (ALM) 6.0, the function REV_LEAF_REGISTRATION does not exist in the database in the atomic schema.

select object_name, object_type, status from user_objects where object_name = 'REV_LEAF_REGISTRATION';

As a result, you cannot run the Leaf Registration procedure described in the Oracle Financial Services Analytical Applications Data Model Utilities User Guide.

The installation log specified in log4j.xml shows that the "common" scripts are executed:

[Thu 05/12/2013 09:40:31] [OFSFTP] [ INFO] - => Number of pre-installed FS Applications=0
[Thu 05/12/2013 09:40:31] [OFSFTP] [ INFO] - => Number of pre-installed FS Applications in the information domain=0
[Thu 05/12/2013 09:40:31] [OFSFTP] [ INFO] -
[Thu 05/12/2013 09:40:31] [OFSFTP] [ INFO] -
[Thu 05/12/2013 09:40:31] [OFSFTP] [ INFO] - => No FSAPPS detected on this Reveleus instance. Will install common config scripts


However, the "common" script fn_rev_leaf_registration.sql that creates the REV_LEAF_REGISTRATION function is not included in the list of scripts executed.

Note: LEAF_REGISTRATION.sql is executed successfully to create the LEAF_REGISTRATION package.

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