We have oracle Form A from which we are selecting List Item i.e. country code, and then displays all Tax Registration details in lower block
Form A Tax Registraion details execution Flow
1) Selects Country code from List item
2) Picks all Tax registration number which are belonging to user selected country code from database
3) All tax numbers are going to be validate from Online java webservices, here Java Webservices returns taxnumber with TRUE or FALSE values
4) Taking Java Webservice's returned values(Tax Registration numbers and TRUE OR FALSE) and again we point database to get more fields values for all tax numbers and same will be displayed in forms block with TRUE or FALSE values
5) When user selects country code in Form A, all tax number details are displaying in block with TRUE or FALSE status
All above steps are achieved successfully.
Now the Problem is, when user selects the Country code in Form A, it takes lot of time to get all details from Webservice and database. we can understand this delay because of it is connecting to Java Webservice to fetch thousand of records for validation.
So now user wants to point to other forms when this Form A is in execution.
I tried to calling this form using OPEN_FORM to create separate session for this Form A and the execute in background. Using
but it was not helped us to point to other form when the Form A is in execution.
We call all forms from menu items, now user is not able to click on menu items when Form A is in execution.
This is very critical, So can we know please as soon as possible, how to point to other forms when FormA is in execution.
Front end: Oracle Forms 10g(Forms [32 Bit] Version 10.1.2.0.2 (Production))
Back end : Oracle 10g
Server : Putty Unix Application server
Windows : Windows Xp professional service pack 3
The forms are synchronous by it's nature. So there in no out of the box way to make forms act asynchronously. One way though it would be to write your own java bean (being asynchronous) to call out the web service. This way you can kind of simulate asynchronous web service call which would allow you to continue to work in your forms session synchronously. In you example call another form. But there is a catch here as soon as the java bean had to communicate with forms session there could be a problem as the form which initially called web service is not active. So you should plan and test this scenario carefully.
You could also try to use integration with AQ feature in Forms 11g. This way the communication with web service had to be done inside database. Those are just some ideas but the real implementation depends on your needs.
In case you do not wish for the form to wait for a given web-service to return something, then, the form should launch a job in the database that would query the web-service, and then, on a when-timer-expired in the form check if that job has finished running. So, the user may be moving within the form while the job is running in the database, the main problem being how to transmitt data from the job to the form. Maybe via a database table. Or possibly using the facilities of dbms_pipe.