Hi, 

There is no specific advantage in the way IFS runs with the backend Oracle database running as single instance or multi-tenant, as IFS currently supports only one PDB per CDB.

Multi-tenant architecture will become more handy from an administration standpoint once IFS starts supporting multiple PDBs per CDB.

Also, we found out through IFS NA, that IFS uses a multi-tenant database in their Help Documentation, however this doesn’t mean they are recommending to use it over a single instance setup.

Couple of our clients went live with Apps 10 running on a multi-tenant database and we found few DBA tasks like backups, database cloning, point in time refresh etc.to be little more complicated. However, once you figure out how things work there are few advantages specifically with PDB database refresh as well.

Hope this helps.

Thank you for explaining

Neno

We find that we can copy our Live PDB into our Test or Dev CDB easier than it might have been otherwise. It only takes a few minutes so we can deal with specific issues or test fixes etc with the most up-to-date data.

The reason why IFS recommends multitenant databases for IFS Applications 10 is that non-CDB technology is deprecated in Oracle Database from Oracle 12.2, although still supported. As of Oracle 20, non-CDB functionality is removed and only multitenant databases are supported.

I can agree with that multitenant technology adds an additional level of complexity when it comes to administration, but there are also advantages, even if you only use one PDB (e.g. cloning, upgrading, patching).

/Jonas