Unzip patch p32078417_R12_GENERIC.zip (DO NOT APPLY
PATCH).
Go to PATCH_Folder/32078417/cdr/patch/115/sql.
Connect to the database as APPS user and run the
cdrdropnepubsynonym.sql script.
In the promt, enter Y.
To verify whether or not the script has completed, run the following query to
make sure there are no rows returned:
SELECT owner, object_name, object_type
FROM all_objects
WHERE owner = 'PUBLIC'
and (upper(object_name) like 'CDR_%' or upper(object_name) like 'DME_%')
and OBJECT_TYPE= 'SYNONYM'
and edition_name is null;
Check the log file for any errors, and save it for future references. If you
need help to fix any error, contact Health Sciences Support.