I am trying to upload the bank statement of Indian Banks to Our oracle ERP System and Reconcile.I have seen there are three formats which are seeded one from Oracle i.e SWIFT940,BAI2 and EDIFACT. Are these formats are used in the Indian banks. If they are using do we need to advise the bank to send it in the above format. If not which format is being used. Do we need to create our own Mapping and customize the loader program. Could any one please help me with this process.If we need to customize what are the steps need to be taken.
Please help me on this Issue Since i have a deadline on this
These formats which we are using to upload bank statements are generally accepted formats. Most of the banks are capable of giving the bank statement out put in the above mentioned formats. There may be slight differences in the formats Ex: Length given for the transaction type and all.
Attached here with a general format description of SWIFT MT 940 format. Also you may have to change the mapping accordingly with the client requirements through bank statement mapping window. Also review the following document as well.
"Mapping BAI2, SWIFT Bank Statement Format Masking: BANK_ACCOUNT_NUM, BANK_TRX_NUMBER, BANK_ACCOUNT_TEXT, Agent Bank account number And Others (Doc ID 752532.1)"
Good luck.. / Lathika