We are looking at deploying a third party application that also utilizes Oracle as its backend and will need to interact with the IFS applications (Apps 10 UPD6). One suggestion has been to create a new schema within the IFS Oracle database and utilize that schema to host the third party application’s database objects. What considerations should we bear in mind before (and if) we proceed with this approach? The pros of this approach are the ease of integration. But we would like to gather opinions on where this approach may cause any issues with the IFS data hosted in the application owner and IFSINFO schema or where such a design might impede the performance or stability of IFS applications
This topic has been closed for comments
Please be aware that this could have a negative effect on APPS 10 performance. Databases temporarily lock rows, tables, and schemas in order to maintain transactions. Depending on the usage of the third party application, those locks could prevent normal APPS 10 data from being retrieved or updated in a timely manner. Do you have an experienced DBA who can monitor the database to ensure that there are no negative problems?
Another option is to create a separate database instance. If you do not need the latest data, backups from Production can be restored as needed. Another option is a BI approach to synchronizes changes on Production to another database. This is of course more work, though.
Another option is to use the IFS API to query the data needed by the third party application.
Userlevel 7
+31
Hi
I think you would have to sort out the license situation of your Oracle database first. IFS customers use Oracle database under Oracle ASFU license. As far as I know, Oracle ASFU license specifies that you can only use the database for the specified application; in this case, IFS Applications. Therefore, if you use the same database for another application, that would be a violation of the license. Please get that cleared up with your IFS project/account manager before everything else.
Please also refer to the response marked as answer in this post:
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.