Time Bucket Ranges Change After February in a Leap Year (Doc ID 1339052.1)

Last updated on MARCH 25, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.1 to 5.5 - Release: 5 to 5
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 5.5 and lower, the Time Bucket range changes in a Leap Year when the As of Date is not the last day of the month.

For example:

As of Date: 06/28/2011.

In February 2012, the date range changes from:

01/29/2012 to 02/28/2012 (30 Days)
to
02/29/2012 to 03/27/2012 (27 Days)

Before the leap year, the End Date was always on the 28th. After the leap year, the End Date is always on the 27th:

Bucket
Start Date
End Date
6
11/29/2011
12/28/2011
7
12/29/2011
01/28/2012
8
01/29/2012
02/28/2012
9
02/29/2012
03/27/2012
10
03/28/2012
04/27/2012


Steps to Reproduce:
  1. Go to Asset Liability Management
  2. Go to ALM Maintenance > Application Preferences
  3. Set to As of Date = 6/29/2011 and Save
  4. Go to ALM Maintenance > Time Buckets
Review the Time Buckets before and after the Leap Year month of February 2012.

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