ALM Active Time Bucket Rule Does Not Show in Forecast Rates

(Doc ID 2343756.1)

Last updated on DECEMBER 28, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.1.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On ALM 6.1.1.1, it appears that the ALM Active Time buckets are not coming up in the Forecast rate rule.

A new time bucket is created and made as Active, but when navigating to Forecast Rates -> Interest Rates Codes -> Select any Currency -> Forecast Method -> Define, it shows a random time bucket, not the active bucket.
Then it shows some random time buckets not active one.

The Web Server alm.log is showing the correct Time bucket but in the UI it is showing some random time bucket.
(select* from (select a.BUCKET_NO as FROM_BUCKET_NUM,a.BUCKET_NO as TO_BUCKET_NUM,a.FROM_DATE as FROMDATE,TO_DATE as TODATE from fsi_time_bkt_isb a where a.TIME_BUCKET_SYS_ID=205104 and a.as_of_date = to_date('12/31/2016', 'mm/dd/yyyy') and a.process_sys_id = -1 order by a.BUCKET_NO asc) where rownum=1 )

The issue can be reproduced at will with the following steps:
1. Create a new time bucket click Active and save.
2. Navigate to Forecast Rates -> Interest Rates Codes -> Select any Currency -> Forecast Method -> Define

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