As of Date Parameter in Cash Flow Engine (CFE) Screen and Time Bucket Screen Different Than REV_APP_USER_PREFERENCES

(Doc ID 2187093.1)

Last updated on JANUARY 21, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)


On BSP 8 it seems that the as of date parameter and the time bucket screen have different values from REV_APP_USER_PREFERENCES.

Created and saved a time bucket with AS_OF_DATE in Hyperion BSP as 30th June 2015. When saving it, it is reduced by 1 and is displayed as 29th June. The same value is visible in CFE Preferences Screen. When querying the REV_APP_USER_PREFERENCES TABLE it is showing 30th June.

Expect the same as of date values to be displayed.

The issue can be reproduced at will with the following steps:
1. Create and save a time bucket in Hyperion BSP with AS_OF_DATE as 30th June 2015
2. Save it. Now it's shown as June 29th 2015
3. See the value from CFE Preference screen and from REV_APP_USER_PREFERENCES TABLE showing June 30th 2015


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