You are html tracking Visitor

Thursday, October 2, 2008

Concurrent program name based on the request ID

Concurrent program name based on the request ID:-
------------------------------------------------------------

With the following query, you can get the concurrent program name based on the Concurrent request ID

Select program from FND_CONC_REQ_SUMMARY_V
where request_id = 'Your request ID';

5 comments:

Sagar Madurwar said...

Hi,
Sorry to post comment at wrong place, I need some help...

My company is using Oracle ERP, we want to give view access to the customer through our website.
Can you please tell me how to give data (Customer Account Statement) access to customers through company website..

Thanks in Advance.....


Regards

CA Sagar S M
sagarmadurwar@gmail.com

My Life..... My Thoughts said...

Hi Sagar,

You can do this by developing a custom jsp/servlet directly to work in Apps server and by publishing it as web service. or u can achieve same by using Oracle Portal which can be integrated with Oracle ERP

Regards
Gautam

phani said...

Hi sagar,
Oracle Portal would be the best may to implement your requirment. You needs to configure the website for the Oracle Portal, but you can not give the access to all the objects. (In Oracle Portal there is a way to do it). It is better to write a report and automatically post it to Customer email id , if this can be done.

Regards,
Phani

Unknown said...

Hi,
You can create database connection from your web site to the Oracle database. Create one schema in your Oracle database and create the synonym for the views from where you want to get the customer data. map your web page to that schema and write your logic in your page.

phani said...

but, if something of this sort of thing (third party connection) would cause the network issues. So, it would be better to do it through Oracle Portal.

Regards,
Phani