1. Welcome to Core Maintenance

This user guide is designed to help you quickly get acquainted with the many functions routinely executed everyday in Oracle Banking.

This section contains the following topics:

Local Holiday

Country Code

BIC Directory

Currency Pair Definition

External Customer

Upload Source Preference

Host Code

Currency Rate Type

External Branch Parameters

System Date

Language Code

External Credit Approval (ECA) System

Currency Exchange Rate

External Customer Account

External Bank Parameters

Customer Category

Forget Customer

End of Day (EOD)

Transaction Code

Amount Text Language

Currency Definition

External Chart Account

Upload Source

Currency Holiday

1.1 Local Holiday

You can configure a local holiday.

1.1.1 Local Holiday Summary

The summary screen provides a list of configured local holidays. You can configure a local holiday using the Local Holidays Maintenance.

1.1.1.1 How to reach here:

Core Maintenance > Local Holiday > View Local Holiday

Field

Description

Branch Code

Displays the code of the branch.

Unexpected Holiday

Indicates if the record is an unexpected holiday.

Year

Displays the year of the holiday.

Status

Displays the status of the record.

1.1.2 Local Holidays Maintenance

The maintenance screen allows you to configure local holidays.

1.1.2.1 How to reach here:

Core Maintenance > Local Holiday > Create Local Holiday

1.1.2.2 How to add a local holiday:

  1. In the Create Local Holiday screen, provide the required details:
  1. Select the dates using the calendar. The selected dates appear in blue highlighted circle.
  2. Click Save. You can view the configured local holiday details in the Local Holiday Summary.

1.2 Country Code

You can configure a country code.

1.2.1 Country Code Summary

The summary screen provides a list of configured country code. You can configure a country code using the Country Code Maintenance.

1.2.1.1 How to reach here:

Core Maintenance > Country Code > View Country Code

Field

Description

Country Code

Displays the country code details.

Country Name

Displays the name of the country.

ISO Numeric Code

Displays the ISO numeric code details of the country code.

Status

Displays the status of the record.

1.2.2 Country Code Maintenance

The maintenance screen allows you to configure a country code.

1.2.2.1 How to reach here:

Core Maintenance > Country Code > Create Country Code

1.2.2.2 How to add a country code:

  1. In the Create Country Code screen, provide the required details:
  1. Click Save. You can view the configured country code details in the Country Code Summary.

1.3 BIC Directory

As part of setting up basic information, you must maintain Bank Identifier Codes (BIC). You can configure the BIC directory for a customer.

1.3.1 BIC Directory Summary

The summary screen provides a list of configured BIC directory. You can configure the BIC directory using the BIC Directory Maintenance.

1.3.1.1 How to reach here:

Core Maintenance > BIC Directory > View BIC Directory

Field

Description

Customer Number

Displays the number of the customer.

Sub-type Code

Displays the sub-type code associated with the customer number.

BIC Code

Displays the defined BIC code for the associated customer number.

Bank Name

Displays the name of the bank.

Status

Displays the status of the record.

1.3.2 BIC Directory Maintenance

The maintenance screen allows you to configure a BIC directory for a customer.

1.3.2.1 How to reach here:

Core Maintenance > BIC Directory > Create BIC Directory

1.3.2.2 How to add a BIC directory:

  1. In the Create BIC Directory screen, provide the required details:

Payment Message

Multi-Customer Credit Transfer

Request for Transfer

  1. Click Save. You can view the configure BIC directory in the BIC Directory Summary.

1.4 Currency Pair Definition

In the foreign exchange markets, the exchange rates for some currency pairs such as the USD-GBP or USD-JPY are easily obtainable, since these are frequently traded. The exchange rates of other currencies such as the ZAR-INR (South African Rand - Indian Rupee), which is not traded very often, is determined through a third currency. The third currency is usually the US dollar, since the US dollar is quoted in all trading centres.

You can define the static attributes of currency pairs for which a regular market quote is readily available. For other pairs, which do not have a regular market quote, you need to specify the third currency through which the system should compute the exchange rate. The currency pair is maintained at the bank level by the Head Office branch.

1.4.1 Currency Pair Definition Summary

The summary screen provides a list of define a currency pair. You can define a currency pair using the Currency Pair Definition Maintenance.

1.4.1.1 How to reach here:

Core Maintenance > Currency Pair Definition > View Currency Pair Definition

Field

Description

Maintenance Country

Displays the maintenance country details.

Number of Units

Displays the number of units.

Currency 1-2

Displays the currency associated with the country.

Status

Displays the status of the record.

1.4.2 Currency Pair Definition Maintenance

The maintenance screen allows you to define currency pair.

1.4.2.1 How to reach here:

Core Maintenance > Currency Pair Definition > Create Currency Pair Definition

1.4.2.2 How to define a currency pair:

  1. In the Create Currency Pair Definition screen, provide the required details:

The method of spread definition that you specify here applies to two instances:

  1. Click Save. You can view the defined currency pair details in the Currency Pair Definition Summary.

1.5 External Customer

You can configure the external customer details.

1.5.1 External Customer Summary

The summary screen provides a list of configured external customer details. You can configure the external customers using the External Customer Maintenance.

1.5.1.1 How to reach here:

Core Maintenance > External Customer > View External Customer

Field

Description

Customer Name

Displays the name of the customer.

Source System

Displays the source system details.

Customer Type

Displays the type of the customer.

Customer Number

Displays the customer number associated with the customer name.

Source Customer ID

Displays the source of the customer ID associated with the customer name.

Status

Displays the status of the record.

1.5.2 External Customer Maintenance

The maintenance screen allows you to configure the external customer details.

1.5.2.1 How to reach here:

Core Maintenance > External Customer > Create External Customer

1.5.2.2 How to add an external customer:

  1. In the Create External Customer screen, provide the required details:

Customer Details

Address

Other Details

  1. Click Save. You can view the configure external customer details in the External Customer Summary.

1.6 Upload Source Preference

You can configure upload source preference.

1.6.1 Upload Source Preference Summary

The summary screen provides a list of configured upload source preferences. You can configure an upload source preference using the Upload Source Preference Maintenance.

1.6.1.1 How to reach here:

Core Maintenance > Upload Source Preference > View Upload Source Preference

Field

Description

Source Code

Displays the code of the source.

Purge Days

Displays the number of purge days.

Status

Displays the status of the record.

1.6.2 Upload Source Preference Maintenance

The maintenance screen allows you to configure upload source preference.

1.6.2.1 How to reach here:

Core Maintenance > Upload Source Preference > Create Upload Source Preference

1.6.2.2 How to add an upload source preference:

  1. In the Create Upload Source Preference screen, provide the required details:

Error Handling

Post Upload

  1. Click Save. You can view the configured upload source preference details in the Upload Source Preference Summary.

1.7 Host Code

You can group branches in the same zone or region under a host for specific processing. You can have multiple hosts depending on processing requirements.

1.7.1 Host Code Summary

The summary screen provides a list of configured host codes. You can configure the host code using the Host Code Maintenance

1.7.1.1 How to reach here:

Core Maintenance > Host Code > View Host Code

Field

Description

Processing Time Zone

Displays the processing time zone.

Country Code

Displays the country code details.

Host Code

Displays the host code details.

Default Branch Code

Displays the default branch code associated with the host code.

Status

Displays the status of the records.

1.7.2 Host Code Maintenance

The maintenance screen allows you to configure host code.

1.7.2.1 How to reach here:

Core Maintenance > Host Code > Create Host Code

1.7.2.2 How to add a host code:

  1. In the Create Host Code screen, provide the required details:
  1. Click Save. You can view the configured host code details in the Host Code Summary.

1.8 Currency Rate Type

You can configure a currency rate type.

1.8.1 Currency Rate Type Summary

The summary screen provides a list of configured currency rate type. You can configure a currency rate type using the Currency Rate Type Maintenance.

1.8.1.1 How to reach here:

Core Maintenance > Currency Rate Type > View Currency Rate Type

Field

Description

Currency Rate Type

Displays the currency rate type.

Description

Displays additional information about the currency rate type.

Status

Displays the status of the record.

1.8.2 Currency Rate Type Maintenance

The maintenance screen allows you to configure currency rate type.

1.8.2.1 How to reach here:

Core Maintenance > Currency Rate Type > Create Currency Rate Type

1.8.2.2 How to add a currency rate type:

  1. In the Create Currency Rate Type screen, provide the required details:
  1. Click Save. You can view the configured currency rate type details in the Currency Rate Type Summary.

1.9 External Branch Parameters

You can configure branch level parameters.

1.9.1 External Branch Parameters Summary

The summary screen provides a list of configured external branch parameters. You can configure the external branch parameters using the External Branch Parameters Maintenance.

1.9.1.1 How to reach here:

Core Maintenance > External Branch Parameters > View External Branch Parameters

Field

Description

Branch Code

Displays the code of the branch associated with the bank.

Branch Name

Displays the name of the branch associated with the bank.

Local Currency

Displays the local currency details.

Source Branch Code

Displays the code of the source branch.

Status

Displays the status of the record.

1.9.2 External Branch Parameters Maintenance

The maintenance screen allows you to configure the branch parameters.

1.9.2.1 How to reach here:

Core Maintenance > External Branch Parameters > Create External Branch Parameters

1.9.2.2 How to configure an external branch parameter:

  1. In the Create External Branch Parameter screen, provide the required details:

Branch Details

Branch Address

Other Details

Note

There are two days of weekly holiday depending on the geographical zone.

SWIFT Address

  1. Click + to add a row and provide the required details:
  1. Click Save. You can view the configure branch parameter details in the External Branch Parameters Summary.

1.10 System Date

You can configure a system date.

1.10.1 System Date Summary

The summary screen provides a list of configured system date. You can configure a system date using the System Date Maintenance.

1.10.1.1 How to reach here:

Core Maintenance > System Date > View System Date

Field

Description

Branch Code

Displays the code of the branch.

Today’s Date

Displays system’s current date.

Today’s Date in Text

Displays the system’s current date in words.

Status

Displays the status of the record.

1.10.2 System Date Maintenance

The maintenance screen allows you to configure system dates.

1.10.2.1 How to reach here:

Core Maintenance > System Date > Create System Date

1.10.2.2 How to add a system date:

  1. In the System Date screen, click New to enable the fields.
  2. Provide the required details:
  1. Click Save. You can view the configured system date details in the System Date Summary.

1.11 Language Code

You can configure a language code.

1.11.1 Language Code Summary

The summary screen provides a list of configured language code. You can configure a language code using the Language Code Maintenance.

1.11.1.1 How to reach here:

Core Maintenance > Language Code > View Language Code

Field

Description

Language ISO Code

Displays the ISO code of the language.

Language Code

Displays the code of the language.

Language Name

Displays the name of the language.

Status

Displays the status of the record.

1.11.2 Language Code Maintenance

The maintenance screen allows you to configure a language code.

1.11.2.1 How to reach here:

Core Maintenance > Language Code > Create Language Code

1.11.2.2 How to add a language code:

  1. In the Create Language Code screen, provide the required details:
  1. Click Save. You can view the configured language code details in the Language Code Summary.

1.12 External Credit Approval (ECA) System

You can configure the ECA system.

1.12.1 ECA System Summary

The summary screen provides a list of configured ECA system. You can configure the ECA system details using the ECA System Maintenance.

1.12.1.1 How to reach here:

Core Maintenance > ECA System > View ECA System

Field

Description

Description

Displays any additional information of the ECA system.

ECA System

Displays the name of the ECA system.

Status

Displays the status of the record.

1.12.2 ECA System Maintenance

The maintenance screen allows you to configure ECA system details.

1.12.2.1 How to reach here:

Core Maintenance > ECA System > Create ECA System

1.12.2.2 How to add an ECA system:

  1. In the Create ECA System screen, provide the required details:
  1. Click Save. You can view the configure ECA system details in the ECA System Summary.

1.13 Currency Exchange Rate

You can maintain exchange rates for a currency pair, the rates at which you buy and sell one currency for another. A bank determines its buy and sell rate for a currency pair by applying a spread (that is, its profit margin) to the mid-rate of the currency pair. Mid rate is the basic rate at which a currency pair is exchanged.

The spread applied for a currency pair varies with the transaction type, while the mid-rate usually remains constant. Consequently, different rates are applicable to different transaction types. For instance dollars in currency are purchased at a certain rate, while USD traveller’s checks are bought at a different rate. You can define a rate type which you would like to associate with a transaction type example: CASH, TRAVCHKS, and so on.

You can define the mid-rate, buy and sell spread applicable to each rate type; the buy and sell exchange rates are computed by the system. Buy rates and sell rates can either be maintained by individual branches or can be input by the HO and propagated to all the branches.

If the branch for which the rate is being uploaded or maintained is the head office branch, then the rate would be copied to all those branches that have the same country code as the head office branch.

If the branch for which the rate is being uploaded or maintained is not the head office branch, but it has the same country code as the head office branch, then the rate being uploaded or maintained would be specific to the branch and would not be copied to any other branch.

If the branch for which the rate is being uploaded or maintained is not the head office branch and also does not have the same country code as the head office branch, then the rate being maintained would be copied to all the branches that has the same country code linked as the branch for which the rate is being maintained or uploaded.

1.13.1 Currency Exchange Rate Summary

The summary screen provides a list of configured currency exchange rates. You can configure a currency exchange rate using the Currency Exchange Rate Maintenance.

1.13.1.1 How to reach here:

Core Maintenance > Currency Exchange Rate > View Currency Exchange Rate

Field

Description

Branch Code

Displays the code of the branch.

Currency 1-2

Displays the currency associated with the branch code

Status

Displays the status of the record.

1.13.2 Currency Exchange Rate Maintenance

The maintenance screen allows you to configure a currency exchange rate.

1.13.2.1 How to reach here:

Core Maintenance > Currency Exchange Rate > Create Currency Exchange Rate

1.13.2.2 How to add a currency exchange rate:

  1. In the Create Currency Exchange Rate screen, provide the required details:

Currency Rule

  1. Click + to add a row and provide the required details.
  1. Click Save. You can view the configured currency exchange rate details in the Currency Exchange Rate Summary.

1.14 External Customer Account

You can configure the external customer account details.

1.14.1 External Customer Account Summary

The summary screen provides a list of configured external customer accounts. You can configure the external customer accounts using the ECA System Maintenance.

1.14.1.1 How to reach here:

Core Maintenance > External Customer Account > View External Customer Account

Field

Description

Account Name

Displays the name of the account.

Account Currency

Displays the currency associated with the account.

Source Account Branch

Displays the branch details associated with the source account.

Customer Account Num­ber

Displays the customer account number associated with the account name.

Customer Number

Displays the customer number associated with the account name.

Status

Displays the status of the record.

1.14.2 External Customer Account Maintenance

The maintenance screen allows you to configure external customer account details.

1.14.2.1 How to reach here:

Core Maintenance > External Customer Account > Create External Customer Account

1.14.2.2 How to add an external customer account:

  1. In the Create External Customer Account screen, provide the required details:

Account Details

Address

Other Details

  1. Click Save. You can view the configure external customer account details in the External Customer Account Summary.

1.15 External Bank Parameters

You can configure bank level parameters.

1.15.1 External Bank Parameters Summary

The summary screen provides a list of configured external bank parameters. You can configure the external bank parameters using the External Bank Parameters Maintenance.

1.15.1.1 How to reach here:

Core Maintenance > External Bank Parameters > View External Bank Parameters

Field

Description

Head Office Branch

Displays the head office branch details.

Maker

Displays the name of the user who has configured the bank details.

Once Authorized

Indicates if the record is authorized once or not.

Bank Code

Displays the code of the bank.

Bank Name

Displays the name of the bank.

Status

Displays the status of the record.

1.15.2 External Bank Parameters Maintenance

The maintenance screen allows you to configure external bank parameters.

1.15.2.1 How to reach here:

Core Maintenance > External Bank Parameters > Create External Bank Parameters

1.15.2.2 How to configure a external bank parameter:

  1. In the Create External Bank Parameter screen, provide the required details:
  1. Click Save. You can view the configure core bank parameter details in the External Bank Parameters Summary.

1.16 Customer Category

You can configure a customer category.

1.16.1 Customer Category Summary

The summary screen provides a list of configured customer category. You can configure a customer category using the Customer Category Maintenance.

1.16.1.1 How to reach here:

Core Maintenance > Customer Category > View Customer Category

Field

Description

Customer Category

Displays the customer category.

Description

Displays additional information about the customer category.

Status

Displays the status of the record.

1.16.2 Customer Category Maintenance

The maintenance screen allows you to configure a customer category.

1.16.2.1 How to reach here:

Core Maintenance > Customer Category > Create Customer Category

1.16.2.2 How to add a customer category:

  1. In the Create Customer Category screen, provide the required details:
  1. Click Save. You can view the configured customer category details in the Customer Category Summary.

1.17 Forget Customer

You can configure the forget customer details.

1.17.1 Forget Customer Maintenance

The maintenance screen allows you to configure forget customer details.

1.17.1.1 How to reach here:

Core Maintenance > Core Maintenance > Forget Process > Forget Customer

1.17.1.2 How to add forget customer:

  1. In the Forget Customer screen, provide the required details:

Note

Depending on the options selected, the grid options appears.

  1. Click + to add a row and provide the customer/bank details.
  2. Click Save.

1.18 End of Day (EOD)

You can configure the EOD activities, indicates that all the activities for the day are complete. Further activities can be done on the system only after the system date has been changed to the next working day and authorized.

Most of the automated functions are part of the beginning of day operations. Thereafter, some of them (for example, accruals) must be executed when the system is in the EOTI stage.

1.18.1 EOD Maintenance

The maintenance screen allows you to configure EOD details.

1.18.1.1 How to reach here:

Core Maintenance > Core Maintenance > Branch EOD > Invoke EOD

1.18.1.2 How to add an end of day:

  1. In the Invoke EOD screen, provide the required details:

Note

You can use the Reset option to reset all the configured details and start fresh.

  1. Click Save.

1.19 Transaction Code

You can configure the transaction code.

1.19.1 Transaction Code Summary

The summary screen provides a list of configured transaction code. You can configure a transaction code using the Transaction Code Maintenance.

1.19.1.1 How to reach here:

Core Maintenance > Transaction Code > View Transaction Code

Field

Description

Source System

Displays the source system details.

Transaction Code

Displays the transaction code details.

Source Transaction Code

Displays the source transaction code associated with the transaction code.

Status

Displays the status of the record,

1.19.2 Transaction Code Maintenance

The maintenance screen allows you to configure transaction code details.

1.19.2.1 How to reach here:

Core Maintenance > Transaction Code > Create Transaction Code

1.19.2.2 How to add a transaction code:

  1. In the Create Transaction Code screen, provide the required details:
  1. Click Save. You can view the configured transaction code details in the Transaction Code Summary.

1.20 Amount Text Language

You can configure an amount text language.

1.20.1 Amount Text Language Summary

The summary screen provides a list of configured amount text language. You can configure an amount text language using the Amount Text Language Maintenance.

1.20.1.1 How to reach here:

Core Maintenance > Amount Text Language > View Amount Text Language

Field

Description

Language Code

Displays the language code associated with the amount word.

Status

Displays the status of the record.

1.20.2 Amount Text Language Maintenance

The maintenance screen allows you to configure amount text language.

1.20.2.1 How to reach here:

Core Maintenance > Amount Text Language > Create Amount Text Language

1.20.2.2 How to add an amount text language:

  1. In the Create Amount Text Language screen, provide the required details:

Amount Word Currency List

  1. Click + to add a row and provide the required details:

Amount Word Text List

  1. Click + to add a row and provide the required details.
  1. Click Save. You can view the configured amount text language details in the Amount Text Language Summary.

1.21 Currency Definition

You can define the attributes of the currencies in which the bank can deal. For each currency, you can define attributes such as, the SWIFT code for the currency, the country the currency belongs, the interest method, the spot days, the settlement days, and so on.

Currencies can be maintained only at the Head Office. The list of currencies are available to the branches based on the currencies defined for the country linked to the branch.

1.21.1 Currency Definition Summary

The summary screen provides a list of defined currency. You can define a currency using the Currency Definition Maintenance.

1.21.1.1 How to reach here:

Core Maintenance > Currency Definition > View Currency Definition

Field

Description

Currency Code

Displays the code of the currency.

Currency Name

Displays the name of the currency.

Alternate Currency Code

Displays the code of the alternate currency.

Country

Displays the country associated with the currency.

Maintenance Country

Displays the maintenance country.

Status

Displays the status of the record.

1.21.2 Currency Definition Maintenance

The maintenance screen allows you to define currency.

1.21.2.1 How to reach here:

Core Maintenance > Currency Definition > Create Currency Definition

1.21.2.2 How to define a currency:

  1. In the Create Current Definition screen, provide the required details:

Cut Off Time

Refers to the time by which all transactions involving a currency should be generated. For a currency, you can indicate the cut-off hour and minute. This time should be expressed in the local time of the bank.

The maintenance of a cut-off time for a currency has particular reference to outgoing funds transfers involving it.

Example: The value date of a funds transfer transaction (incoming payment) involving USD, is 3rd June 2018. The number of cut-off days specified for the currency is 2. This means that the payment must be received on or before 1st June 2018. If the payment is received on 1st June, it must be received before the cut-off time specified for USD.

If the USD cut-off time is 1200 hrs, if the payment is received on 1st June 2018, it must be received before 1200 hrs.

Rounding

Currency Format Mask

Euro Type

Auto Exchange Rate

Currency Country Mapping

  1. Click + to add a row and provide the required details:
  1. Click Save. You can view the defined currency in the Currency Definition Summary.

1.22 External Chart Account

You can configure an external charts.

1.22.1 External Chart Account Summary

The summary screen provides a list of configured external chart accounts. You can configure an external chart account using the External Chart Account Maintenance.

1.22.1.1 How to reach here:

Core Maintenance > External Chart Account > View External Chart Account

Field

Description

General Ledger Code

Displays the code of the general ledger.

Source System

Displays the source system.

Source System GL Code

Displays the GL code of the source system.

Status

Displays the status of the record.

1.22.2 External Chart Account Maintenance

The maintenance screen allows you to configure external chart accounts.

1.22.2.1 How to reach here:

Core Maintenance > External Chart Account > Create External Chart Account

1.22.2.2 How to add an external chart account:

  1. In the Create External Chart Account screen, provide the required details:
  1. Click Save. You can view the configured external chart details in the External Chart Account Summary.

1.23 Upload Source

You can upload a source code.

1.23.1 Upload Source Summary

The summary screen provides a list of configured source code. You can upload a source code using the Upload Source Maintenance.

1.23.1.1 How to reach here:

Core Maintenance > Upload Source > View Upload Source

Field

Description

Upload Source

Displays the upload source details.

Source Description

Displays information about the source code.

Status

Displays the status of the record.

1.23.2 Upload Source Maintenance

The maintenance screen allows you to upload source.

1.23.2.1 How to reach here:

Core Maintenance > Upload Source > Create Upload Source

1.23.2.2 How to upload source:

  1. In the Create Upload Source screen, provide the required details:
  1. Click Save. You can view the configured upload source details in the Upload Source Summary.

1.24 Currency Holiday

You can configure a yearly list of holidays, for the currencies, defined in the currency screen. The system uses the information maintained to check if any settlement involving a foreign currency (in the foreign Exchange, Money market, Funds Transfer, Loans and Deposit modules) falls on that currency’s holiday. If yes, the system displays a message stating and ask the user for an override.

For any schedule or contract maturing at a future date, five years hence, you can input the future date, only if the calendar for that year is maintained. The currency holiday is maintained at the bank level by the Head Office.

1.24.1 Currency Holiday Summary

The summary screen provides a list of configured currency holiday. You can configure a currency holiday using the Currency Holiday Maintenance.

1.24.1.1 How to reach here:

Core Maintenance > Currency Holiday > View Currency Holiday

Field

Description

Currency

Displays the currency details.

Weekly Holidays

Displays the weekly holidays associated with the currency.

Status

Displays the status of the record.

1.24.2 Currency Holiday Maintenance

The maintenance screen allows you to configure a currency holiday.

1.24.2.1 How to reach here:

Core Maintenance > Currency Holiday > Create Currency Holiday

1.24.2.2 How to add a currency holiday

  1. In the Create Currency Holiday screen, provide the required details:
  1. Select the dates using the calendar. The selected dates appear in blue highlighted circle.
  2. Click Save. You can view the configured currency holidays in the Currency Holiday Summary.