1.9.1 Contract Upload

This topic describes how to upload contract.

Your bank may use Oracle FLEXCUBE to process certain transactions (say LD and FT transactions) and use another application to process other transactions (say MM and FX transactions).

At some point of time, your bank may want to use the values from the external system in Oracle FLEXCUBE. For this purpose, Oracle FLEXCUBE stores the values of the various fields from the external system (an application other than Oracle FLEXCUBE) in a database table. If your bank wants to use the value of the fields from the external system in Oracle FLEXCUBE, the values have to be brought into Oracle FLEXCUBE database. This is done through a process called ‘Upload’.

Let us assume that your bank is processing LD transactions in Oracle FLEXCUBE and MM transactions in an external system. For processing certain LD transactions, your bank wants to use the values from certain MM transactions. Therefore, you will have to put the value of the contract reference number along with the field name and value of the MM transactions, which you want to use in Oracle FLEXCUBE into a database Upload table with the status marked as ‘U’ (indicating that it has to be taken up for processing). This Upload table contains the values posted from the external system. Subsequently, you will have to bring the values of these fields into Oracle FLEXCUBE. This is done by running the contract upload program.

When you run this program, Oracle FLEXCUBE selects the fields for which the status is ‘P’. It will upload the values from the external system into Oracle FLEXCUBE database.