A Script to Drop Obsolete Schemas in EBS 12.2

A Script to Drop Obsolete Schemas in EBS 12.2

After successful upgrade to 12.2.x, you should drop obsolete schemas. 

The following query generates a script to facilitate that:

select 'sqlplus apps/<apps_pwd> @$AD_TOP/patch/115/sql/addropschema.sql <system_pwd> applsys ' || username drop_schema from dba_users where username in ('ABM', 'AHM', 'AMF', 'AMW', 'BIL', 'BIV', 'BIX', 'BSC', 'CSS', 'CUE', 'CUF', 'CUI', 'CUN', 'CUP', 'CUS', 'DDD', 'EAA', 'EDWREP', 'EVM', 'FEM', 'FII', 'FPT', 'FTP', 'GCS', 'HCC', 'IBA', 'IBP', 'IGF', 'IGS', 'IGW', 'IMT', 'IPD', 'ISC', 'ITA', 'JTS', 'ME', 'MST', 'OKB', 'OKI', 'OKO', 'OKR', 'OZP', 'OZS', 'PFT', 'POA', 'PSB', 'RCM', 'RHX', 'RLA', 'VEH','XNC', 'XNI', 'XNM', 'XNS', 'ZFA', 'ZPB', 'ZSA');