Apart from the maintenances mentioned in previous sections, if Multi Bank Cash Concentration facility is allowed, the following maintenances need to be done during implementation. This is necessary only if they have not been maintained earlier.
This chapter contains the following sections:
You can invoke the ‘BIC Code Details’ screen by typing ‘ISDBICDE’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘Message Media format Maintenance’ screen by typing MSDMDFMT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘Advise Format Maintenance’ screen by typing ‘MSDADVFT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘Message Type Maintenance’ screen by typing ‘MSDMSTYP’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘STP Rule Maintenance’ screen by typing ‘MSDMTUDF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘STP Preferences Maintenance’ screen by typing ‘MSDSTPRF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘Upload Source Preferences Maintenance’ screen by typing ‘CODUPLDM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘Retail Teller Settlement Details Maintenance’ screen by typing ‘FTDRCST’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can invoke the ‘Retail Teller Product Maintenance’ screen by typing ‘DEDRTPRM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
For details on User Defined Fields screen refer Other Maintenances chapter in Core Service User Manual.
You can invoke the ‘ARC Maintenance’ screen by typing ‘IFDATMMN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In a transaction, if the account branch of the teller transaction is different from the transaction branch, then charges maintained by inter-branch product will be applied to the transaction.
If the IB checkbox is checked for a product, then the system will pick up and process the charge entries maintained at the IB product level.
During a transaction, If IB product is not maintained and if the transaction branch is different from account branch, then charges maintained in non-ib product will be applied to the transaction.
IB Transaction
Check this box if you want the system to pick up the product, for inter-branch transactions.
You will notice the difference in the service charges processed for two transactions with same kind of product.
Refer the chapter ‘Maintaining Account, Rate, and Charge Details’ in the Clearing user manual, for detailed explanation of the fields in this screen.
The message product mapping maintenance is used for resolving the product code on Branch, Message Type, Queue, Direction flag, covered required and Envelope Message type.
You can invoke the ‘Message Product Mapping Maintenance’ screen by typing MSDPRDMP’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch
Indicate the branch for which you are maintaining product-mapping preferences. The mapping is for a branch and message type combination.
Message Type/Sub Message Type
Select the message type/sub message type.The adjoining list displays a list of message types maintained in the system. Choose the appropriate one.
Specify the message for which you want to define the Rule based on which the STP will process the same.
Envelope Message Type
This field displays the index messages MT798. The index messages values are available in list.
Product
On indicating the branch and message type, you can map a product to the combination. Click the adjoining option list and select a product code from the option list. The information that is derived from an uploaded MT 100 or MT 202 message will be enriched with attributes defined for the product to which it is linked.
Queue
You can specify the messaging queue to which the messages should be routed,for a branch, message and product combination.You can also assign multiple queues to a message type. Select the appropriate queue from the option-list.Indicate the queue to which the message must be routed,at the time of maintaining rules for a message type, if it satisfies the rule being defined.
Direction Flag
Indicate whether the message type for which you are maintaining product mapping preferences is an outgoing message or an incoming message. Click on the drop-down list and select the appropriate flag.
Cover Required
Indicate whether a a cover needs to be sent for the transfer. The options available are:
Whether a cover is required or not is decided based on the settlement instructions maintained for the party to which the onward message is sent.
On No Beneficiary
For your branch, indicate how FLEXCUBE should handle S.W.I.F.T. messages that do not carry information on the ultimate beneficiary of the transfer. The preference that you stated for your branch in the Product Mapping detailed screen is defaulted. You can change the default to suit the current upload session. The options available are:
When you receive adequate information on the beneficiary, you can transfer the funds posted to the suspense GL to the customer account by liquidating the transfer. If you indicate Repair ,the message will not be processed, and will be placed in Repair status.
You can invoke the ‘Settlement Instruction Maintenance’ screen by typing ‘ISDINSTN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You are required to maintain the following sequence for ILM batches that need to be run, for any branch which is enabled for ILM. You can invoke the ‘Mandatory Batch Program Maintenance’ screen by typing ‘EIDMANPE’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
At EOTI – Stage
At BOD - Stage
The various mandatory programs are show below:
You can maintain the following mandatory batch programs using ‘Mandatory Batch Program Maintenance’ screen.
Interest resolution for customer accounts with non-integrated LM IC products is carried out by the system at the time of saving the accounts. In the case of customer accounts with integrated LM type of IC product, System Account records for the customer accounts are created after the account structure has been maintained. The system accounts are created on the basis of their account type (Header and Reallocation) and are resolved in a similar manner to customer accounts.
The following points need to be considered for IC processing:
A change in UDE values does not impact the resolution of System Accounts since both the UDEs and the UDE values are taken from the corresponding Customer Account of each System Account.
The UDE values are maintained in the Node and the same is picked up for interest calculation. If the UDE values are changed for an effective date, the IC calculations will be based on the new UDE value as on that effective date.
A back valued change in a UDE value leads to a back valuation for the following:
For ILM type of products, the Balance SDEs used for the calculation of the Pool System Accounts are the consolidated pool balance and for the System Accounts it is the System Accounts independent balances. For non ILM type of products the balances are taken from the customer accounts.
The System Account interests which are affected by BVT are recalculated and will be compared with the interest posted during that period. The adjustment entry to the System Account will be the difference of interest computed and interest posted.
The adjustment entry due to BVT is maintained in the corresponding Booking Account of the System Account maintained in the Account Structure Maintenance.
If the interest calculated cannot be posted due to the closure of the booking account maintained for the System Account in the Account Structure, then the system will post the interest entry to the suspense account maintained.
The System Accounts considered for calculation are those which:
The reallocation of interest depends on the interest conditions (based on the Value Dated Sweep Amounts) set up on the Child Accounts. The system obtains the interest rates for calculating re-allocation interest from the UDEs specified in IC Maintenances.
The interest so derived on the contribution of the child accounts is re-allocated to the respective child accounts.
The subsequent sections of this chapter explains the various processes (real time, intra day and end of day) performed by the system as part of ILM processing.
The system automatically validates the account structure that you have maintained. You can run this batch process anytime during the day to check the validity of account structures. If you have modified the account structure details, you need to manually run the validation.
The system will execute the validation batch as part of ILM Processing (Intra-day or End of Day) for all account structures which have not been validated.
This section contains the following topics:
An account can play the role of child or parent in an account structure. For this purpose (and to help in the processing of corrections such as back value dated transactions), Oracle FLEXCUBE creates system accounts. This helps the system to identify the role of the account in a structure at any point of time.
The resolution for generation of system accounts is as follows:
For instance, in the illustration explained under the section ‘Linking Account Structure to Group Code’, the Account Structure for the Group GRP is maintained as:
Child Account |
Parent Account |
IL Relation |
HACC |
GRP |
C |
HACC |
HACC |
P |
PACC1 |
HACC |
C |
PACC2 |
HACC |
C |
PACC1 |
PACC1 |
P |
PACC2 |
PACC2 |
P |
CACC1 |
PACC1 |
C |
CACC2 |
PACC2 |
C |
CACC3 |
PACC2 |
C |
The System Account is created for the above mentioned Account Structure as follows:
Account |
IL Relation As |
System Account |
Account Level |
System Account Level |
HACC |
Parent |
T3 |
2 |
1 |
HACC |
Header |
T4 |
2 |
2 |
PACC1 |
Child |
T1 |
2 |
3 |
PACC2 |
Child |
T2 |
2 |
3 |
PACC1 |
Parent |
S3 |
3 |
1 |
PACC1 |
Header |
S4 |
3 |
2 |
PACC2 |
Parent |
S6 |
3 |
1 |
PACC2 |
Header |
S7 |
3 |
2 |
CACC1 |
Child |
S1 |
3 |
3 |
CACC2 |
Child |
S2 |
3 |
3 |
CACC3 |
Child |
S5 |
3 |
3 |
During End of Day (EOD) process, you can execute the sweep process for integrated liquidity management.
When you execute this process, based on your specifications, funds are swept between accounts in a structure. That is:
Dr |
Contributing Account |
Amount |
Cr |
Receiving Account |
Amount |
All sweeps will be single currency sweeps. During EOD:
The processing for Notional Pooling structures is as follows:
The system converts the Child Account balances to Parent Account currency. This is done in order to arrive at the ultimate Pool Balance in terms of the Parent Account currency.
To determine the Contribution Amount, the ILM batch considers the Sweep Eligible Balance instead of the Available Balance.
Note
The Sweep Ineligible Balance is populated from E-Gifts DEUPLOAD interface based on the 'AIP Eligible' value as Y or N. Any record with 'AIP Eligibility' set to N increases the Sweep InEligible balance by that amount.