EFFECTIVE_TO_DATE Is Not Populated In OFSA 4.5 After RDBMS Upgrade to 11i (Doc ID 1951290.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5.30 and later
Information in this document applies to any platform.

Symptoms

After ugrading the database from version 10.2.0.5.12.c to 11.2.0.4.3 for OFSA version 4.5
the following issue occurs:

The results from res_dtl_x tables are converting at the first exchange rate in the ofsa_exchange_rate_hist table instead of current rate for any process ID where the functional output dimension
 is by product. Outputs where functional output dimension is by product & currency are all correct.

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