'Reverse Population Has Not Been Run for the selected FTP Product Hierarchy : xxxxxx' Running FTP Process (Doc ID 2035753.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Funds Transfer Pricing (FTP), when running an FTP Process, you get the following error in FSI_PROCESS_ERRORS:

Dimension members not found in required format. Reverse Population has not been run for the selected FTP Product Hierarchy :200189.000000

The ofstp.xxxxxx.log from $FIC_DB_HOME/log/FusionApps ends with SQL like the following:

Module Logging OFS calculation module data: select
select distinct a.ISO_CURRENCY_CD, a.PRODUCT_ID
from FSI_D_CREDIT_LINES a
where as_of_date = to_date('06/ 30/ 2015', 'mm/ dd/ yyyy')
order by a.ISO_CURRENCY_CD, a.PRODUCT_ID

Module Logging OFS calculation module data: Executing: ISO_CURRENCY_CD:USD, PRODUCT_ID:11001

The error prevents Transfer Rates from being created for the input records.

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