How to Submit more than 100000 req. to concurrent manger
Hi All
Our goal is to generate invoices say 100000 in PDF format and store it in one directory on server and then it ftp to another server for distribution to customers.
To achieve this we need to submit 100000 requests to process and generate the ouput in PDF format and then save it.
We are on 10.2.0.4 database with 11.5.10.2 Oracle apps version on IBM Aix 6.1
My questions
Is it possbile to submit 100000 jobs at a time? (Then FNd_concurrent_requests will be heavily used and latching will start.)
Can we submit the requests in batches? like 2000, 2000, 2000 .
Do we have alternate solution without using concurrent managers?
Our goal is to generate invoices say 100000 in PDF format and store it in one directory on server and then it ftp to another server for distribution to customers.
To achieve this we need to submit 100000 requests to process and generate the ouput in PDF format and then save it.
We are on 10.2.0.4 database with 11.5.10.2 Oracle apps version on IBM Aix 6.1
My questions
Is it possbile to submit 100000 jobs at a time? (Then FNd_concurrent_requests will be heavily used and latching will start.)
Can we submit the requests in batches? like 2000, 2000, 2000 .
Do we have alternate solution without using concurrent managers?
0