Delete Obsolete Products in R12.2

Use the following example to Delete Obsolete Products in R12.2

 

Issue:

Warning error In Patch Log

AD Worker warning:

 Product Data File

 /u01/app/dev/fs1/EBSapps/appl/admin/cupprod.txt

 does not exist for product "cup".

This product is registered in the database but the

above file does not exist in APPL_TOP.  The product

will be ignored without error.

Solution

File to execute:    $AD_TOP/patch/115/sql/addropschema.sql

SYNTAX

sqlplus apps/apps @ addropschema.sql <SYSTEM_Password> <APPLSYS_Schema> <Schema_Name>

Example

sqlplus apps/apps @addropschema.sql manager APPLSYS cup;