How to trigger Standard Concurrent Program/Set at the end of my custom Integrator
Hi,
I created a customized Web ADI Integrator that uploads Supplier, Supplier Sites, & Contacts to the interface. I created a package/api to insert the uploaded rows/data and I execute the standard Import interface -- Supplier Open Interface Request Set(1) -- in my script using the Fnd_submit.set_request_set. However, it's not practical because it runs per row of data. So if I uploaded 100 rows, it'll trigger the set 100 times.
My question is, is there a way of executing the set after all the rows are loaded. Just like how Oracle does in there standard GL Journal Batch Loading integrators? We're running in R12.1.2. I saw a tip in the net -->
I created a customized Web ADI Integrator that uploads Supplier, Supplier Sites, & Contacts to the interface. I created a package/api to insert the uploaded rows/data and I execute the standard Import interface -- Supplier Open Interface Request Set(1) -- in my script using the Fnd_submit.set_request_set. However, it's not practical because it runs per row of data. So if I uploaded 100 rows, it'll trigger the set 100 times.
My question is, is there a way of executing the set after all the rows are loaded. Just like how Oracle does in there standard GL Journal Batch Loading integrators? We're running in R12.1.2. I saw a tip in the net -->
1