ORA-01400: cannot insert NULL into ("EGO"."EGO_ODI_WS_XSL_ZD"."ZD_EDITION_NAME")

R12.2.0 to R12.2.7 upgrade worker failed with ORA-01400

 sqlplus -s APPS/***** @/web03/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/web03/TEST/fs1/EBSapps/appl/ego/12.0
.0/patch/115/sql/egoxslzd.sql &un_apps &un_ego'

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("EGO"."EGO_ODI_WS_XSL_ZD"."ZD_EDITION_NAME")
ORA-06512: at line 7

solution:

ALTER TABLE EGO.ego_odi_ws_xsl_zd  MODIFY ZD_EDITION_NAME varchar2(30 Byte) NULL;

restart the adop session

adop phase=apply apply_mode=downtime patches=24690690 restart=yes abandon=no