Note
Oracle FLEXCUBE ELCM provides a feature to maintain Facility details based on a particular value date. Oracle FLEXCUBE ELCM also tracks all the Utilizations of the Facility based on the value date of the transaction.
Oracle FLEXCUBE ELCM process all the utilization transaction as of book date.
Oracle FLEXCUBE ELCM facilitates maintaining Facility details based on a particular value date. The following parameters are taken from the Facility Maintenance screen:
Whenever a new Limit Line is created, a new record is automatically created by the system with the value date as the Limit Start Date. The Main Line and the Limit Amount are same as the booking dated limit maintenance.
Whenever the Mainline or the Limit amount is changed in the facility, a new record is created in the maintenance with value date as the application date. The mainline and limit amount values are same as in the booking dated Limits maintenance. You can view these details by clicking ‘Value Date’ button.
Oracle FLEXCUBE ELCM also tracks all the utilizations of the facility based on the value date of the transaction. The following transactions are supported for Value dated processing:
As part of the above utilization transactions, the Value Date is the value date of the transaction. Updating of value dated utilization can be set to be online or to be a part of EOD process. This parameter is maintained in Oracle FLEXCUBE ELCM Parameter Maintenance.
● If the parameter is set to update Value Date online, then during the transaction process the Value Date utilization details are updated online. Otherwise, it is updated during EOD process.
● In the case of main lines, the system identifies all the sub lines linked and track the utilization. This utilization is tracked in addition to the contracts that are directly linked to the main line.
Refer Annexure – 1 for more details on Utilization Transactions.
If the value date update is not online, but as part of Facility EOD process, it would be updated as shown in the following examples.
Example,
Let us consider a Loan of 1 Million USD. Value date 10-Jan-2005 Revolving Line
Step 1: Initiation - Utilization Log
Serial no |
Value date |
Line code |
Utilization |
Component |
Increase/Decrease |
1 |
10-Jan-05 |
LINE 1 |
1000000 |
PRINCIPAL |
Increase |
Line Utilization
Serial no |
Value date |
Line code |
Utilization |
1 |
10-Jan-05 |
LINE 1 |
1000000 |
Step 2: Payment of 0.1M Principal value date 10-Feb-2005 - Utilization Log
Serial no |
Value date |
Line code |
Utilization |
Component |
Increase/Decrease |
1 |
10-Jan-05 |
LINE 1 |
1000000 |
PRINCIPAL |
Increase |
2 |
10-Feb-05 |
LINE 1 |
100000 |
PRINCIPAL |
Decrease |
Line Utilization
Serial no |
Value date |
Line code |
Utilization |
1 |
10-Jan-05 |
LINE 1 |
1000000 |
2 |
10-Feb-05 |
LINE1 |
900000 |
Step 3: Value dated amendment of 0.5M Principal increase value date 15-Feb-2005 - Utilization Log
S.no |
Value date |
Line code |
Utilization |
Component |
Increase/Decrease |
1 |
10-Jan-05 |
LINE1 |
1000000 |
PRINCIPAL |
Increase |
2 |
10-Feb-05 |
LINE1 |
100000 |
PRINCIPAL |
Decrease |
3 |
15-Feb-05 |
LINE1 |
500000 |
PRINCIPAL |
Increase |
Line Utilization
Serial no |
Value date |
Line code |
Utilization |
1 |
10-Jan-05 |
LINE 1 |
1000000 |
2 |
10-Feb-05 |
LINE1 |
900000 |
3 |
15-Feb-05 |
LINE1 |
1400000 |
Step 4: Payment of 0.2M value date 10-Mar-2005 - Utilization Log
S.no |
Value date |
Line date |
Utilization |
Component |
Increase/Decrease |
1 |
10-Jan-05 |
LINE1 |
1000000 |
PRINCIPAL |
Increase |
2 |
10-Feb-05 |
LINE1 |
100000 |
PRINCIPAL |
Decrease |
3 |
15-Feb-05 |
LINE1 |
500000 |
PRINCIPAL |
Increase |
4 |
10-Mar-05 |
LINE1 |
20000 |
PRINCIPAL |
Decrease |
Line Utilization
S.No |
Line code |
Value date |
Utilization |
1 |
LINE1 |
10-Jan-05 |
1000000 |
2 |
LINE1 |
10-Feb-05 |
900000 |
3 |
LINE1 |
15-Feb-05 |
1400000 |
4 |
LINE1 |
10-Mar-05 |
1200000 |
Step 5: Reversal of Payment of 0.2M value date 10-Mar-2005 on 15-Mar-2005 - Utilization Log
S.no |
Value date |
Line date |
Utilization |
Component |
Increase/Decrease |
1 |
10-Jan-05 |
LINE1 |
1000000 |
PRINCIPAL |
Increase |
2 |
10-Feb-05 |
LINE1 |
100000 |
PRINCIPAL |
Decrease |
3 |
15-Feb-05 |
LINE1 |
500000 |
PRINCIPAL |
Increase |
4 |
10-Mar-05 |
LINE1 |
200000 |
PRINCIPAL |
Decrease |
5 |
10-Mar-05 |
LINE1 |
200000 |
PRINCIPAL |
Increase |
Line Utilization - Step 6 Liquidation of Contract Value date 10-Apr-2005 - Utilization Log
S.no |
Value date |
Line date |
Utilization |
Component |
Increase/Decrease |
1 |
10-Jan-05 |
LINE1 |
1000000 |
PRINCIPAL |
Increase |
2 |
10-Feb-05 |
LINE1 |
100000 |
PRINCIPAL |
Decrease |
3 |
15-Feb-05 |
LINE1 |
500000 |
PRINCIPAL |
Increase |
4 |
10-Mar-05 |
LINE1 |
200000 |
PRINCIPAL |
Decrease |
5 |
10-Mar-05 |
LINE1 |
200000 |
PRINCIPAL |
Increase |
6 |
10-Apr-05 |
LINE1 |
1400000 |
PRINCIPAL |
Decrease |
Line Utilization
S.No |
Line code |
Value date |
Utilization |
1 |
LINE1 |
10-Jan-05 |
1000000 |
2 |
LINE1 |
10-Feb-05 |
900000 |
3 |
LINE1 |
15-Feb-05 |
1400000 |
4 |
LINE1 |
10-Mar-05 |
1400000 |
5 |
LINE1 |
10-Apr-05 |
0 |
Oracle FLEXCUBE ELCM provides a facility to capture and compute fees based on different value dated balances.
The following are the different activities that takes place and it impact on each other.
You can invoke this screen by typing ‘GEDRULES’ in the field at the top right corner of the application tool bar and clicking the adjoining arrow button.
Rule ID
Every fee rule is identified by a unique code, called a Rule ID. You can link a valid fee Rule ID to the fee classes.Fees for a limit with which you associate a fee class is calculated on the basis of the Rule that is associated with the class.
Rule Description
For every rule that you define, you can enter a description. Specifying a description helps identify a rule.
SDE Type
Specify the System Data Elements (SDE). The adjoining option list displays a list of SDEs maintained in the system.
Day Basis
A day basis method is used for fee calculations.
Different values for the numerator basis are as explained below:
Different values for the denominator of the fee basis are as explained below.
Fee Component Type
Select the fee component type either as ‘Slab’ or ‘Tier’.
Fee Type
Select the fee type either as ‘Rate’ or ‘Amount’.
You can invoke this screen by typing ‘GEDCLSMT’ in the field at the top right corner of the application tool bar and clicking the adjoining arrow button.
Class Code
Before defining the attributes of a fee class, you should assign the class a unique identifier, called the Class Code.
Description
A brief description about the class. A description helps you to easily identify the class.
Start Date
Specify the start date from which the fee calculation starts. The start date can only be a current date or the future and it cannot be a back dated date.
End Date
Specify the end date till which the fees will be calculated.
You can specify accounting roles details in ‘Accounting Roles’ screen. Click ‘Accounting Roles’ tab to open this screen.
Accounting Role
Accounting Roles are tags that identify the type of accounting entry that is posted to an accounting head.
Accounting Head
The different General Ledgers (GLs) and Sub-Ledgers (SLs) maintained in your Chart of Accounts are referred to as accounting heads or account heads.
You can specify event and accounting entries details in ‘Events’ screen. Click ‘Events’ tab to open this screen.
Event code
Specify the event code.
Accounting Role
Accounting Roles are tags that identify the type of accounting entry that is posted to an accounting head.
Amount Tag
Specify the amount tag.
Transaction Code
Indicates the type of accounting entry associated with every accounting entry.
Dr/Cr Indicator
Indicates whether the amount was debited or credited to the ‘Net’ Account
Netting
Select this drop-down list if you need netting for fee liquidation.
Click ‘Preferences’ tab to open ‘Preferences’ screen.
Rule Code
You can link a valid fee Rule to the fee classes. Fees for a limit with which you associate a fee class is calculated on the basis of the Rule ID that is associated with the class.
Accrual Required
Selecting this indicates that the fees have to be accrued.
Accrual Frequency
Specify the fee accrual frequency.
Liquidate Frequency
Specify the fee liquidate frequency.
This section contains details of the suggested accounting entries that can be set up, for ELCM Facility. The details of the suggested accounting entries are given event-wise.
Event Code |
Description |
INIT |
Facility Initiation |
AMND |
Facility Amendment |
UTIL |
Facility Utilization |
DUTL |
Release of Utilization to Facility |
FACR |
Fee Accrual |
FLIQ |
Fee Liquidation |
INIT: Facility Initiation
Accounting Entries
Accounting Role |
Amount Tags |
Dr/Cr. Indicator |
CONASSETGL |
EFF_LINE_AMT |
Dr |
CONASSETOFF |
EFF_LINE_AMT |
Cr |
AMND: Facility Amendment
Accounting Role |
Amount Tags |
Dr/Cr. Indicator |
CONASSETGL |
EFF_LINE_AMT_INCR |
Dr |
CONASSETOFF |
EFF_LINE_AMT_INCR |
Cr |
CONASSETGL |
EFF_LINE_AMT_DECR |
Dr |
CONASSETOFF |
EFF_LINE_AMT_DECR |
Cr |
UTIL: Facility Utilization
Accounting Entries
Accounting Role |
Amount Tags |
Dr/Cr. Indicator |
CONASSETGL |
UTIL_INCR |
Cr |
CONASSETOFF |
UTIL_INCR |
Dr |
DUTIL: Release of Utilization to Facility
Accounting Entries
Accounting Role |
Amount Tags |
Dr/Cr. Indicator |
CONASSETGL |
UTIL_DECR |
Dr |
CONASSETOFF |
UTIL_DECR |
Cr |
FACR: Fee Accrual
Accounting Entries
Accounting Role |
Amount Tags |
Dr/Cr. Indicator |
RULEINC |
RULE_ACCR |
Cr |
RULEREC |
RULE_ACCR |
Dr |
FLIQ: Fee Liquidation
Accounting Entries
Accounting Role |
Amount Tags |
Dr/Cr. Indicator |
RULEREC |
RULE_LIQD |
Cr |
CUSTOMER |
RULE_LIQD |
Dr |