APEX

Hi All:

ENV: APEX 4.0
EBS: 11i10
DB: 10r2

APEX is installed in the same database as EBS 11i10

1. I have developed a APEX application that is can be launched from EBS as a form function. Also, the APEX will not ask any credential when user launch it from EBS, since user is already authenticated. Also, APEX will also display FND username, responsibility for user who has login - <<This is already implemented>>

2. by Default, APEX will display a page, where user can browser and import a csv file into a predefined custom table <<This is already implemented>>

3. After csv file is imported into cusotm table, user will click "Submit" button to process the data. APEX will submit a concurrent request (eventually, the concurrent program will call Oracle API to process data). A concurrent request is will display on the apex page. << This is WIP and I don't forsee any issue to implement this, since many have done this before>>

4. User will write down the request id from step 3 and go to another apex page. In this page, user will enter request id and click "View Output", which should retrieve the concurrent output for that request id and display the output in a new browser. I don't want user go back to EBS to view the concurrent output. << This is my question for this thread>>

My question for step 4: is there a seeded EBS API (FND_???) that I can call by passing a request id and API should display the concurrent request output in a browser automatically? Assuming, I will use fnd_global.apps_initialize() API in this page to set EBS env properly.

My question may not be a direct APEX question; however, I hope someone can offer some help to me. I have done numerous research on this and still haven't find this API.


Thanks!

Kevin