Did we connect to all those 400 bank accounts using Java Concurrent Program?
Not really. We used a third party named Biveroni[link]. Biveroni used to collect SWIFT messages for all our 400+ bank accounts. SWIFT message, if nothing but an message/instruction in specific format, that tells how much moneyhas been transacted on a given bank account number.
So Biveroni received all the SWIFT messages, and java concurrent program was used to get those messages from Biveroni?
Correct.
What happened next?
Following steps happened:-
1. The Java concurrent program FTP'ed the all the SWIFT messages from Biveroni to our server.
2. After FTP'ing the messages, the same Java Concurrent Program parsed the messages [using string tokenizer]
3. Using JDBC connection object within Java Concurrent Program, the messages were loaded into our staging tables.
4. After validations, data was transferred to Cash Management Interface tables. Validations on staging tables were performed via PL/SQL API.
The key is that all this happened within one single Java Concurrent Program. This is where lies the strength of using Java Concurrent program, you can do it all within one go. Imagine how this would have worked if using PL/SQL Concurrent program coupled with Host Concurrent Programs.
How did we update the cash positions every 15minutes?
Simple, all we did was to schedule the Java Concurrent Program to run every 15minutes.
For the complete java technical design, please click on the link Java Bank Poller- Using Java Concurrent Program.
I primarily used JDeveloper 9.0.2 for this development then, although Eclipse was partially used as well for its code generation features.
Comments
We are trying to email the invoices to the customer. Do you have any suggestions how to do this?
Thanks
We are trying to email the invoices to the customer. Do you have any suggestions how to do this?
Thanks
It appears you want to transmit the output of Invoice Print report to the customer.
St andard way of doing this will be to implement Bursting in XML Publisher.
Have a look at these links for further details:-
http://blogs.oracle.com/xmlpublisher/2006/08/03#a77
http://blogs.oracle.com/xmlpublisher/2006/08/04#a80
http://blogs.oracle.com/xmlpublisher/2006/08/16#a83
http://blogs.oracle.com/xmlpublisher/2006/08/17#a90
http://blogs.oracle.com/xmlpublisher/2006/08/24#a97
http://forums.oracle.com/forums/thread.jspa?messageID=1505931
Thanks,
Anil
RSS feed for comments to this post