ALM Active Time Bucket Rule Does Not Show in Forecast Rates
Last updated on DECEMBER 28, 2017
Applies to:Oracle Financial Services Asset Liability Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
On ALM 126.96.36.199, 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
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