7. Uploading an External Statement

7.1 Introduction

An external statement (MT 940 and 950) can be uploaded automatically or entered manually into Oracle FLEXCUBE. To recall, messages can come into your bank through the media types that you have maintained for your bank in the Messaging module of Oracle FLEXCUBE. The procedure involved in uploading an MT 940 and MT 950 to Oracle FLEXCUBE is detailed in the paragraphs that follow.

This chapter contains the following sections:

• Section 7.2, "The Procedure"
• Section 7.3, "Reconciliation External Statement Upload Screen"
• Section 7.4, "Features on the External Upload Screen"

7.2 The Procedure

To recall, the external statements that come in through SWIFT (MT 950) can be automatically uploaded onto Oracle FLEXCUBE from the Incoming Message Browser.

Step 1

Through the upload facility provided in the Incoming Message Browser of the Messaging sub system you can upload an MT 940 and MT 950 on to Oracle FLEXCUBE. The detailed procedure for this step is covered in the Messaging User Manual of Oracle FLEXCUBE.

Step 2

Once the message is in Oracle FLEXCUBE, you should do an MT 940/950 hand-off. From the Application Browser, select ‘Nostro’ and the MT 940/950 hand-off option under it.

Step 3

After the hand-off you should upload the statement into the Nostro subsystem. To do this you should invoke the External Statement Upload screen.

Through the upload facility you can automatically upload statements that have come in for a reconciliation class + external entity + account + currency combination. To upload an external statement into the nostro subsystem, you should:

• Indicate the source from which the statement should be uploaded
• Indicate the external entity and account to which the statement belongs
• Indicate the reconciliation class that should be used to match and reconcile the transaction
• Indicate the details of the statement like its sequence number, sub sequence number (if any) and the year in which the statement was received

The details of an uploaded statement will be automatically displayed in the relevant fields of External Statement Input screen.

Note

The statements that come in through media types other than SWIFT should be manually entered into Oracle FLEXCUBE through the External Account Definition screen.

7.3 Reconciliation External Statement Upload Screen

You can invoke the ‘Reconciliation External Statement Input’ screen by typing ‘REDXSTIN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

7.4 Features on the External Upload Screen

Indicating the Upload Source

To upload an external statement from a source external to Oracle FLEXCUBE you should indicate the code assigned to the source from where the message should be uploaded.

Indicating Details of the External Statement

The details of an external statement that you should specify are as follows:

• The year in which the statement reached your branch
• The sequence number of the statement and the subsequence number (if required)
• The external entity and account to which the account belongs
• The reconciliation class to be used
• The currency of the statement

Click to view the exceptions that occurred while the statement was being uploaded. If the button is disabled it means that no exceptions were encountered during the upload session.

The Upload Exception report which when generated, gives a detailed description of the exceptions that occurred during upload.

Viewing the Exceptions that Occurred

Click ‘E’ button to view the exceptions that occurred while the external statement was uploaded. This screen will contain details of only the exceptions that occurred during the current upload session.

You can retrieve information of all the exceptions that were encountered during a day by invoking the Upload Exception Report.