My Oracle Support Banner

How To Populate Missing Dates in FSI_EXCHNG_RATE_DIRECT_ACCESS Where EFFECTIVE_TO_DATE Is NULL? (Doc ID 2770571.1)

Last updated on APRIL 30, 2021

Applies to:

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

Goal

What can be done if the "EFFECTIVE_TO_DATE" column in FSI_EXCHNG_RATE_DIRECT_ACCESS table is null for few dates (excluding for the latest date)? Because of this, the rate conversion in CONS_DTL_XXXX table is not happening correctly.

Running the Exchange Rate Validation might fail or hung if all the dates are executed since the number of dates is huge. How can the issue be resolved?

 

It has been observed that:

(1) When Exchange Rate Validation is run daily, 'fsi_exchng_rate_direct_access' table is properly populated with valid exchange rates.

(2) When Exchange Rate Validation is run on prior month-end (i.e. back dated run, say you run Exchange Rate Validation on March on an as_of_date=28th Feb, with start date = 27th Feb and end date = 28th Feb), then in 'fsi_exchng_rate_direct_access' table which already had entry for 28th Feb (before back-dated batch execution), entry for 28th Feb goes blank in 'effective_to_date' column.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.