Bank Statement uploading

[mkaleemzs]

We are implementing Cash Management.
We need help Bank Statement provided by Banks in MS Excel or in PDF format.
What is procedure of uploading Excel format? I need A to Z procedure.
Kindly reply or email at mkaleemzs@yahoo.com.

Regards,
Kaleem

[admin]

Pl ask your bank to provide data in BAI2 or Swift format also check if the provided data by bank is up loadable or not. tks

[mkaleemzs]

Some banks are providing but some banks are not.....like MCB providing in MS Excel.
Then what to do?

[sudhir]

Hi,

Have you tried dataload to the oracle forms directly?

Regards,

[mkaleemzs]

[quote]Hi,

Have you tried dataload to the oracle forms directly?

Regards,

<i><div align="right">Originally posted by sudhir

[tgs100]

You may follow the below steps.

1. Get the data in excel in the required format.
2. Convert to Text file (either CSV or TAB Delimited)
3. Transfer the text file to Oracle Server to a specific directory
4. Run the custom program (You should develop this program through control file) to transfer this data to a Temp table. If there are any issues in the data, inform the users through log file.
5. Transfer the Data to Bank Interface Table using Custom Program
6. Run Import Bank Statement Interface
7. Run Auto Reconciliation

You may also combine steps 4 and 5.

Cheers,
Saravanan TG

[mkaleemzs]

[quote]You may follow the below steps.

1. Get the data in excel in the required format.
2. Convert to Text file (either CSV or TAB Delimited)
3. Transfer the text file to Oracle Server to a specific directory
4. Run the custom program (You should develop this program through control file) to transfer this data to a Temp table. If there are any issues in the data, inform the users through log file.
5. Transfer the Data to Bank Interface Table using Custom Program
6. Run Import Bank Statement Interface
7. Run Auto Reconciliation

You may also combine steps 4 and 5.

Cheers,
Saravanan TG

<i><div align="right">Originally posted by tgs100

[tgs100]

You should prepare the functional requirement document (MD050) and give it to the technical resource. The technical resource will develop the program and register in oracle apps.

Step 4 and 5 are part of technical related work, neither DBA no0r functional (MD050 should be prepared by functional consultant).

This MD050 contains the detailed requirement which will be converted into coding by the developer.

Cheers,
Saravanan TG

[hiszaki]

Hi Kaleem

You can use the data loader to upload the bank statement (in excel sheet) into the bank statement form then make the reconciliation if you don't have any technical resources.

Thanks
Hisham

[mkaleemzs]

[quote]Hi Kaleem

You can use the data loader to upload the bank statement (in excel sheet) into the bank statement form then make the reconciliation if you don't have any technical resources.

Thanks
Hisham

<i><div align="right">Originally posted by hiszaki

[tgs100]

There are many tools available for loading data into oracle apps.

You may check the following links.

http://www.dataload.net/
http://www.formsdataloader.com/

You can download the free trial version and test it out. But remember these tools can be used for temporary period. For long term, it is better to do it through scripts.

Cheers,
Saravanan TG