A contract that you process in Oracle FLEXCUBE goes through different stages during its life cycle. These stages are defined as Events. Every new module that you maintain has to be associated with a set of events, which will be triggered at appropriate stages during the lifecycle of the contract.
Apart from the factory shipped events, you can create your own events as per the requirements of the bank.
This chapter contains the following sections:
This section contains the following topics:
You can define the events through the ‘User defined Events’ screen. You can invoke this screen by typing ‘UDDEVMNT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can define events for a new module and also for existing modules in this screen.
User defined events will be linked to a product and is triggered in the life cycle of a contract, which is processed under that product.
Report Module
Specify the module for which you want to set up a user-defined event. The adjoining option list contains all the module codes available in the system. Select the appropriate one.
Event Code
Specify the event code that you want to set up for the module.
Event Description
Give a brief description of the event that you are defining. The description that you enter is for information purposes.
Accounting Entries Definition
Specify the accounting entries definition. You have the following options:
Advice Definition
Specify the advice entries definition. You have the following options:
UDE Advices Definition
Specify the UDE advice definition. You have the following options:
Indicate your preferences.
Allow Charge
Specify the association allow charge. You have the following options:
Allow Transaction Tax
Specify the association allow transaction tax. You have the following options:
Indicate your preferences. These fields will not be applicable if you have specified any one of the following in the ‘Report Module’ field:
Allow Charge
Specify the application allow charge. You have the following options:
Allow Transaction Tax
Specify the application allow transaction tax. You have the following options:
Indicate your preferences.These fields will not be applicable if you have specified any one of the following in the ‘Report Module’ field:
Allow Charge
Specify the liquidation allow charge. You have the following options:
Allow Transaction Tax
Specify the liquidation allow transaction tax. You have the following options:
Click ‘Default’ button in the ‘User Defined Events’ screen to define the triggering parameters for the configured event.
In this screen you can enter the following details below:
Module Code
The system displays the module code here.
Event Code
The system displays the event code here.
Event Trigger
The event, which you are defining, can be triggered in either of the following ways:
Value Date Derivation
Check this box to indicate that the value date derivation is defined for a particular event.
Event Processing
Check this box to indicate the event processing is defined for a particular event.
Execution Query
Enter the query condition to select the list of accounts for the execution of the event during EOD. Input to this field will be mandatory if you choose ‘Automatic’ triggering of the event.
Click ‘Value Date Derivation’ button on the ‘Event Trigger’ screen and invoke the ‘Derivation Rule’ screen to specify the value date derivation logic.
In this screen you can enter the following details:
Module Code
The system displays module code here.
Event Code
The system displays event code here.
Value Date Derivation Rule
Enter description about the value date derivation rule. You need to assign a value to ‘L_VAL_DT’. For instance, ‘L_VAL_DT:=global.application_date’.
Error
Click ‘X’ button to execute the code. The derivation code will be validated by the system. If any checks fail, you must alter the statement so that the validation can be made successfully. Click ‘E’ button to view the errors.
Click ‘Event Processing’ button on the ‘Event Trigger’ screen and invoke the ‘Derivation Rule’ screen to assign values for processing of the event.
In this screen you can enter the following details:
Module Code
The system displays module code here.
Event Code
The system displays event code here.
Click ‘X’ button to execute the code. The derivation code will be validated by the system. If any checks fail, you must alter the statement so that the validation can be made successfully. Click ‘E’ button to view the errors.
System uses UDE to calculate the commission on the highest outstanding balance of the loan and the mortgage Accounts.
You can define a UDE Highest Debit Balance Commission Event (HDBC) for computation of commission with following parameters:
You can view the event details maintained in the 'User Defined Events' screen under 'Events' screen of a contract screen. You can invoke the ‘Events’ screen by typing ‘CSDEVENT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Reference Number
Specify the reference number.
The system displays the following details:
You can view the accounting entries maintained for an event in the ‘Accounting Entries’ screen by selecting an event and clicking on ‘Accounting Entries’ button in the’ Events’ screen. To invoke the screen type ‘CSDACENT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Reference Number
Specify the transaction reference number
See Position Entries
Check this box to view currency position of the entries.
Event
Specify the event.
Event Number
The system displays the event number.
The following details are displayed in the Accounting Entries:
The following details are displayed in the Accounting Under Process:
Click on ‘Overrides’ button to view the override details of the accounting entries.
You can view the messages by selecting an event and clicking on ‘Messages’ button in the’ Events’ screen. To invoke the screen type ‘CSDMSGVW’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
The system displays the following details:
You can view the details of a message by selecting a message from the ‘Message’ screen and clicking on ‘Message Details’ button.
This section contains the following topics:
You can define the amount tags for accounting roles through the ‘Accounting Role and Head Maintenance’ screen You can invoke this screen by typing ‘UDDRLTAG’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters for the module:
This tab is displayed by default when you invoke the screen.
Amount Tag
Specify the amount tag.
Description
Enter the brief description for amount tag.
Charge
Indicate whether the amount tag pertains to a charge or not by choosing one of the following options:
Accounting
Indicate whether accounting entries are required or not by choosing one of the following options:
Transaction Tax
Indicate whether transaction tax is applicable or not by choosing one of the following options:
Local Currency
Indicate the local currency preference by choosing one of the following options:
Local Currency Eq. Tag
Specify the amount tag for the local currency equivalent amount.
Click ‘Derivation’ button and invoke the ‘Derivation Rule Details’ screen to derive the amount and currency for the amount tag.
Here you can specify derivation logic for the following:
Module Code
The system displays module code here.
Amount Tag
The system displays the amount tag here.
You can specify the following details.
Amount Rule Type
Check this box if the amount has to be derived based on a specified condition. The amount for a particular tag can be derived based on a condition.
Derivation Amount Rule
If you have checked against the option ‘Amount Rule Type’, the system will derive the amount for the amount tag that is being defined. You can use the following as variables while creating the derivation rule:
You can use any of the following SDEs:
Assume that you have an account-level UDF called ‘OSCHGRATE’.
The derivation rule using the SDEs and UDF may be given as under.
DECLARE
l_osprin_amt number;
rate number;
BEGIN
L_osprin_amt:=(@SDE_VAL#PRINCIPAL_OUTSTAND);
rate: =(@UDF_UD#OSCHGRATE);
l_amount:=rate * l_osprin_amt;
END
Amount Rule Error Description
Enter a brief description about amount rule error that should be displayed in case the derivation fails.
The currency can either be derived from the existing account currency or can be maintained as a UDF field in the account or it can be hard-coded in the ‘Currency Rule Definition’ screen.
Currency Rule Type
Check this box if the currency for a particular amount tag has to be derived based on the derivation rule.
Derivation Currency Rule
Specify the rule based on which the system should derive the currency for the amount tag. You need to assign a value to ‘L_CCY’. For instance, the rule may be given as under.
BEGIN
SELECT currency
INTO l_ccy
FROM cltb_account_master
WHERE account_number = p_acc_no
AND branch_code=p_branch;
END;
Currency Rule Error Description
Enter a brief description about currency rule error that should be displayed in case the derivation fails.
Click ‘Accounting Roles’ tab in the ‘Accounting Role and Head Maintenance’ screen.
In this screen you can enter the following details:
Role Code
Specify the role code.
Description
Enter a brief description about role code.
Role Type
Select the role type from the adjoining drop-down list. The following values are available:
This section contains the following topics:
You can add the user defined event batch to the mandatory programs to be run for the module, using the ‘Mandatory Batch Program Maintenance’ screen. You can invoke this screen by typing ‘EIDMANPR’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
Module
Choose the module code from the adjoining option list.
Function Identification
Specify ‘UDBATEVT’ as the batch that needs to be run. You can also select this value from the adjoining option list.
End Of Cycle Group
Select the option ‘End Of Transaction Input’.
Predecessors
You need to add the following batches as predecessors to the ‘UDBATEVT’ batch:
For further details about this screen, refer the chapter ‘Setting- up Mandatory Programs for EOD’ in the AEOD User Manual.
This batch fetches the list of user defined events of the following modules for which the event triggering is set as ‘Automatic’:
It fetches valid accounts associated with the event by the executing the query defined for the event in the ‘Event Trigger’ screen. The settlement account and branch are defaulted from the settlement details maintained for the account. If these details are not maintained, they will be defaulted from the settlement details maintained for the ‘Principal’ component.
The system triggers the derivation rule maintained for the event to arrive at the value date of the event. The system then posts accounting entries to the respective GLs using the value date derived. The system also derives the amount and currency for each amount tag of the accounting entries defined for the event. The system allows you to link only payment advice ‘CR_ADV, DR_ADV’ to the user defined event. So if linked to an account, this advice will be generated.