Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Integration with another Oracle Application

Highlighted
H Hussain
Occasional Advisor

Integration with another Oracle Application

Hi,

I need to integrate the PPM application with Oracle Financials

the DBAs at oracle financials have created a view for me through which I can fetch the records.

The requirement is to display those records in the Project Home page under Details section.

What should be the best way to do that?

Regards - hashimi
3 REPLIES
Mahen M
Honored Contributor

Re: Integration with another Oracle Application

I would suggest creating a custom table in PPM and load data from your Oracle Financials DB to PPM at regular interval.

If you want that to be integrated with PPM, Please see options of using webservices.

Regards,
Mahendran M
H Hussain
Occasional Advisor

Re: Integration with another Oracle Application

Hi, there

Creating a materialized view would work for it, but how would i catch those records and display within the Project Home page, since the Project fields would be only displayed through the DB fields provided by PPM like PARAMETER10, PARAMETER11 etc.

is there any way for it?

regards - hashimi
Mahen M
Honored Contributor

Re: Integration with another Oracle Application

If you create a custom table you can access the table in PPM Datasource.... I hope there is option to have the custom portlets in Project Summary page.

Regards,
Mahendran M
//Add this to "OnDomLoad" event