Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apr 2019 CPU patch application to EBS

SGUMay 16 2019 — edited Feb 9 2021

HI Support,

We are trying to apply Apr2019 CPU patch 2922472 to EBS.We are on R12.2.5 version with database version 12.1.0.2

Read me says:

Required Code levels [required]

This patch requires additional code levels to have been successfully

applied to your system before it can be applied. These code levels,

as at the time that this patch was built, are listed below. Please check

'My Oracle Support' to determine if any of these have been superseded

12.2.3

R12.AD.C.delta.10

R12.TXK.C.delta.10

As we are on 12.2.5,can we proceed with EBS cpu patch application?or do we need to upgrade our existing delta 7 to delta 10 before applying this CPU patch?

Thank you

Comments

SreevalliK-Oracle
Answer

Hello,

Here is the documentation link which explains how to delete the sites from UI

https://docs.oracle.com/en/middleware/webcenter/sites/12.2.1.4/admin/assembling-content-management-sites.html#GUID-47830…

Usually Shared assets are not deleted when deleting a site

When attempting to delete a site, the Sites UI prompts the following message for confirmation:

"This action will permanently delete assets that belong to the site exclusively. It will delete all site configuration information, including start menus, workflow processes, workflow groups, and tree tabs which are configured solely for this site. It will permanently remove the site. Are you sure that you want to delete this site?"

As confirmed by this message, deleting a site will only delete assets that belong to the site exclusively, and not delete any assets that are shared with other sites.

Thanks,

Sreevalli

Marked as Answer by 3607075 · Sep 27 2020
1 person found this helpful
3607075

Thank You Sreevalli. Could please let me know the following?. 

At DB point of view, is it going to delete soft/hard delete the site and site related info?.

And how can i confirm those details in Db where all the site related info stores. 

Thank You,

Santosh Gajjala

SreevalliK-Oracle

Hello Santosh,

Sites will be deleted permanently from Database.
Sites related info and its references will be present in different tables based on its usage and data(assets and asset types). So, with just single table one cannot get all sites related information.

Usually list of sites present in the environment can be found in Publication table.

The documentation link which was provided earlier has the configuration information which is affected by the deletion of a site.

Thanks,

Sreevalli

1 person found this helpful
3607075

Hello Sreevalli,

So if we delete the site, the site will get deleted from Publication table right?. and i more thing, the site related info and the reference also deleted right?. Could please let me know the some tables like CSElement, Template, Blogs where those are available for specific site.

it is very helpful, if you provide the doc which has all the DB information.   

Thank You,

Santosh

SreevalliK-Oracle

Hello Santosh,

Yes Sites will be deleted from Publication table. Coming to the tables most of the tables are common for all the sites. For Example CSElements, Templates these tables contain all the templates, cselements created in whole Sites system not specific to one site. But particular site elements will be deleted from those tables if site is deleted.

For more information on Database, Go through the following documentation which might be helpful

https://docs.oracle.com/en/middleware/webcenter/sites/12.2.1.4/admin/webcenter-sites-database-tables.html#GUID-F6723F6A-D4F6-4C2E-AA10-9AB2A4430669

https://docs.oracle.com/en/middleware/webcenter/sites/12.2.1.4/develop/working-webcenter-sites-database.html#GUID-36CD3D68-4F04-4655-A104-BD5E9967931E

Thanks,

Sreevalli

1 - 5

Post Details

Added on May 16 2019
#general-ebs-discussion
0 comments
44 views