Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Receivables
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

This article gives another practical example of Java Concurrent Program usage. I had developed this solution for a big Financial Services client 4 years ago [2002]. My client had over 400 bank accounts and there was a need to monitor cash balances across all their bank accounts globally. They wanted to get up-to-date current total cash levels across all their bank accounts [with a 15minutes lag period].


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.



Anil Passi

Comments   

0 #1 Saritha 2007-04-13 00:00
Hi Anil,

We are trying to email the invoices to the customer. Do you have any suggestions how to do this?

Thanks
Quote
0 #2 Saritha 2007-04-13 00:00
Hi Anil,

We are trying to email the invoices to the customer. Do you have any suggestions how to do this?

Thanks
Quote
0 #3 Anil Passi 2007-04-14 00:00
Hi Saritha

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
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner