3 Batch Description

The topic provides information on the various Oracle Banking Accounts batch jobs.

1. Account Status Change

The status change of an account is performed automatically if the Automatic Account Status Change field is enabled at Account level. A number of statuses and rules are maintained in the rule engine. The status rules are attached to the Account Class at every stage movement. Finally, the batch picks up such accounts based on the below conditions, where -

  • The Automatic Account Status Change flag is set to Yes.
  • The rules maintained in Account Class are evaluated.

The new status for the account is derived and the status of the account is updated automatically by the system.

2. Account Revaluation

Revaluation is a calculated upward adjustment to a country's official exchange rate relative to a selected baseline.

The Account Revaluation batch is run to revalue the balances of foreign currency customer accounts and thus, the local currency balance is restated. The required revaluation setup is captured under Configurations. As a result of the batch, the system revalues the account balances and posts the revaluation profit or loss into a predefined account and the revaluation profit / loss is then handed over to the GL system.

Reval Split Required

Reval Split Required indicates that the user requires trading split in revaluation for the GL. You can choose to break-up the revaluation Profit / Loss for the GL that you are defining.
  • Trading Profit / Loss – Profit or loss due to revaluation of FCY entries posted into the FCY account during the day.
  • Revaluation P&L – Profit or loss due to revaluation of opening balances (balances without current day’s turnover).

Based on the Configurations, the system books profit and loss to the Profit GL and Loss GL respectively. When Reval Split Required is selected, the booking of the profit and loss happens to both Trading Profit and Trading Loss GLs.

3. GL HandOff

The Credit GL Line and Debit GL Line for every status is captured at the account class / account level.

The Reporting GL is determined based on the sign of account balance. If the account balance is positive, it reports to the Credit GL and likewise to the Debit GL, if negative.

To facilitate balance posting, an Intersystem Bridge GL is maintained at source code preference. The offset entries for each of the scenarios is posted to Intersystem Bridge GL.

The following GL's are defined in the Account Class maintenance to post account balances when a status movement occurs on any account belonging to that account class.
  • Debit and Credit GL's to which account balances must be posted, for movement to each status.
The following conditions are handled in the batch process.
  • No change in the balance sign and the account has net credit turnover.
  • No change in the balance sign and the account has net debit turnover.
  • No change in the account balance, as there are no transactions for the day.
  • No change in the account balance, since the net turnover (sum of debits and credits) is zero.
  • Net credit turnover in the account changing the account's balance sign from negative to positive.
  • Net debit turnover in the account changing the account's balance sign from positive to negative.

4. Dormancy

As a part of transaction processing depending on the flags and attributes sent in the transaction, the system sets the last credit activity date or the last debit activity date for an account. The dormancy date in the account is set based on the account’s activity date and dormancy days from the account class.

This batch job picks all accounts which are (i) not dormant, and (ii) whose dormancy date is lesser than the branch date; and marks it dormant.

5. Auto Cheque Book Request

The automatic reordering of Cheque Books is processed at EOD by executing a batch function. The following conditions should be satisfied for initiation of automatic reordering of cheque books:
  • The Auto Reorder of Cheque Book option is enabled at the Account level.
  • The number of unused check leaves for the account is less than or equal to the reorder level maintained at the Account level.
The system picks up the number of leaves to be reordered from Reorder Number of Leaves maintained for the account and issues a cheque book for the account.

6. Release Legal Amount Blocks

This API also performs the following actions -
  • It picks all the accounts having amount blocks that are expiring earlier or on the branch date.
  • It derives the value of the amount block that must be retained/valid.
  • It expires the Legal Block and updates the account balance.

7. Stop Payment

This batch job also performs the following actions -
  • Fetches Expired Stop Payments - It closes all stop payments for the branch date and if there are no active stop payments for the account, it updates the account's stop payment status to Yes.
  • Activates Stop Payments - It updates the stop payment flag in the account to Yes when there are active stop payments for the account on the branch date.