While upgrading Oracle E-Business Suite to R12.2.11, we faced an issue which highlights the aftermath of the “event” initialization parameter being absent at CDB level. sqlplus -s APPS/***** @/d01/apps/PDBSID/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/d01/apps/PDBSID/fs1/EBSapps/appl/xdp/12.0.0/patch/115/sql/XDPMIGFX.sql ‘ Connected. PL/SQL procedure successfully completed. DECLARE * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at … Continue reading Significance of EVENT initialization parameter in Oracle 19c Database