Page 1 of 1
Bank Statement uploading
Posted: Mon Jul 27, 2009 3:08 am
by 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
Posted: Mon Jul 27, 2009 3:46 am
by 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
Posted: Mon Jul 27, 2009 4:00 am
by mkaleemzs
Some banks are providing but some banks are not.....like MCB providing in MS Excel.
Then what to do?
Posted: Mon Jul 27, 2009 4:28 am
by sudhir
Hi,
Have you tried dataload to the oracle forms directly?
Regards,
Posted: Mon Jul 27, 2009 4:46 am
by mkaleemzs
[quote]Hi,
Have you tried dataload to the oracle forms directly?
Regards,
<i><div align="right">Originally posted by sudhir
Posted: Mon Jul 27, 2009 4:47 am
by 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
Posted: Mon Jul 27, 2009 5:11 am
by 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
Posted: Mon Jul 27, 2009 5:16 am
by 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
Posted: Tue Jul 28, 2009 3:00 am
by 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
Posted: Tue Jul 28, 2009 3:55 am
by 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
Posted: Tue Jul 28, 2009 4:23 am
by 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