Project and Portfolio Management Practitioners Forum
cancel

Integration with another Oracle Application

Highlighted
H Hussain
Regular Contributor.

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
Acclaimed 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
Regular Contributor.

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
Acclaimed 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