7.1.3 Load Maintenance Detail - Basis Button

This topic explains the Basis button of the Load Maintenanace Detail screen.

The basis of application of a load is not restricted only to the following parameters:
  • Date
  • Period
  • Amount
  • Units
  • Date and Amount
  • Date and Units
  • Period and Amount
  • Period and Units

The following example will make this clear:

Basis definitions are usually defined based on a number of holdings units, or a period of time, in days.

  1. In Oracle FLEXCUBE Investor Servicing, you can create a basis definition for any load, through the Basis Definition screen, after you have created a load in the Load Definition screen.
  2. Click Basis button.
    The Basis Load Set Up screen is displayed.

    Figure 7-6 Load Maintenance Detail_Basis Button



    Note:

    • You cannot build a basis definition more than once on the same load.
    • You can build a basis definition using either the units or period as a basis parameter. It is not possible to build a basis definition using amount as a basis parameter in this screen.
    • Basis definitions can be built only on Period and Units as parameters.
  3. On Basis Load Set Up screen, specify the fields.
    For more information on fields, refer to the field description table.

    Table 7-8 Basis Load Set Up - Field Description

    Field Description
    Basis Information

    The section displays the following fields.

    Basis Criteria Optional

    In this section, you can set up the criteria that will characterize this basis definition.

    Depending upon whether the basis is reckoned on a number of units or a number of days click the Criteria link and then use the Query Builder to make your specification. To do so, click the Criteria link. The Query Builder is opened.

    The criteria that you set up through the Query Builder must return a single value. Once you have saved your specification and closed the Query Builder, the SQL statement corresponding to the desired criteria appears in the Criteria box, and the tables that have been referred in the execution of the criteria are clicked in the Tables Referred Box.

    Load ID Display

    The ID of the load that you specified in the Load Definition screen, for which you are creating a basis definition, is displayed here.

    Load Type Display

    The type of the load for which you are creating a basis definition is displayed here, from the Load Definition screen.

    Amount Or Percentage Display

    The system displays if load is amount or percentage.

    Take Current Transaction into Account Optional

    Check this box to indicate the basis definition you are making in this record must take any current transactions into account while computing the return values. By default, this box is not checked.

    Load Description Display

    The system displays the load description.

    Tables Referred

    The section displays the following fields.

    Display Only

    After you have saved your criteria specification in the Query Builder, and closed the same, the SQL statement corresponding to the desired criteria appears in the Criteria box, and the tables that have been referred in the execution of the criteria are clicked in this Box.

    Criteria can be based on any one of the eight parameters given under the Tables Referred section.

    They can be any of the following:
    • Ageing
    • LOI
    • Group Benefits
    • Fund Price Header
    • Unit Holder Additional Info
    • Unit Holder Fund Units
    • Unit Holder Fund Amount
    • Investor

    Note: The dynamic packages will get recreated on unlock, save and authorization.