7.1.6 Creating Reporting Bucket

The Time Bucket definition screen allows you to define multi-level time buckets. Reporting time buckets are defined over an existing computational time bucket set.

To create a reporting bucket, perform the following steps:

1. On the Oracle Financial Services Analytical Applications Infrastructure window under Time Bucket Summary window, select a Computational Time Bucket already created and then click
   
   
   
   icon to create a reporting bucket.

   The Time Bucket Details – Edit window is displayed.

   Figure 6-3 Time Bucket Details – Edit window

   
   

   

   
   
2. Enter the time bucket Name.
3. Enter the time bucket Description.

   Note:

   Active option and dynamic start date selection is disabled for LRM users.
4. Select the Folder from the drop-down list.
5. Under Liquidity Buckets section, the level 0 buckets defined as part of the selected computational bucket are displayed.
6. Click the
   
   
   
   icon to select the Start Date from the MIS Date format.
7. In order to group, click Apply. The Time Bucket Grouping icon is now enabled to group different levels. Only the Level 0 buckets defined in computational time bucket are displayed. Hence you must define new higher levels. It is possible to group up to 5 levels. Once the grouping is done you can save it.
8. Click
   
   
   
   icon. The Time Bucket Grouping window is displayed.

   The process of grouping more granular buckets in higher level buckets is consistent for all bucket levels.

   
   

   

   
   
9. Click
   
   
   
   against a time bucket and click
   
   
   
   to group the time buckets. You can select multiple time buckets which form a single higher level bucket at a single instance by clicking the last time bucket. A dialog box is displayed to define the Level 1 Bucket name that is, a user-specified name for the higher level time bucket is created.
10. Enter the Node Name and then click OK. Repeat steps 10 and 11 to group the other level 0 buckets into level 1 bucket.
11. Click
    
    
    
    icon to reset all the levels defined for the time bucket definition.
12. Once all level 0 buckets are grouped, click the
    
    
    
    icon to save the grouping. On clicking the
    
    
    
    icon, the level 1 grouping is displayed in a new section named Level 2 Bucket Definition.The process of grouping level 1 bucket to level 2 buckets is similar to that detailed in points 10 through 12.
13. Once you have defined your multi-level time buckets, click OK to save the definition. The hierarchy for the specified time bucket definition is now created and can be used for further computations.

    Note:

    • In case of all bucket types you are allowed to specify a bucket called Unspecified Bucket. This is available at all bucket levels and will not have a time period associated with it.
    • The Overnight bucket will be the second time bucket in the list. The frequency and multiplier are 0 and days respectively. The start date and end date are set to as of date.
    • Additionally, a time bucket called Open Maturity is present. This is the time bucket used to bucket all cash flows from accounts that have do not have a maturity associated with them.
    • On execution of a Run, the start and end date is stored against each time bucket. This is for reporting purpose only. All definitions will use bucket names.