Patch 10049519: 11i - Fails Processing EGOEXTBUPGRADE.sql

@/a01/oracle/tst1/tst1appl/ego/11

Hi Support,
When we applied patch 10049519, we got following error:

sqlplus -s APPS/***** @/a01/oracle/tst1/tst1appl/ego/11.5.0/patch/115/sql/EGOEXTBUPGRADE.sql &un_ego &pw_ego

Session altered.

DECLARE
*
ERROR at line 1:
ORA-20001: EGOEXTBUPGRADE : ORA-00947: not enough values
ORA-06512: at line 171


I found that the error was raised when the procedure was doing following dynamic statement:

INSERT /*+ APPEND PARALLEL (B) */
      INTO EGO_MTL_SY_ITEMS_EXT_B B
SELECT /*+ PARALLEL(A) */ *
       FROM EGO.EGO_MSI_EXT_B A

The reason is that EGO_MTL_SY_ITEMS_EXT_B has 106 columns, but EGO.EGO_MSI_EXT_B has only 102 columns.