My Oracle Support Banner

Rate Validation Function Not Populating Record with FROM_CURRENCY_CD = TO_CURRENCY_CD (ex. USD->USD) (Doc ID 2373648.1)

Last updated on MARCH 19, 2018

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when executing the Currency Rate Validation program (or function fn_ratevalidation) to move exchange rates from FSI_EXCHANGE_RATE_HIST to FSI_EXCHNG_RATE_DIRECT_ACCESS, the row with FROM_CURRENCY_CD = TO_CURRENCY_CD is not getting populated in FSI_EXCHNG_RATE_DIRECT_ACCESS.

For example, you have the following row in FSI_EXCHANGE_RATE_HIST:

This row is not moved into FSI_EXCHNG_RATE_DIRECT_ACCESS.

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.