ADZDPSUM.sql error

[VinodNN]

Hello Erman,

The ADZDPSUM.sql is throwing this error:

SQL> @ADZDPSUM.sql

PL/SQL procedure successfully completed.


Table created.


Index created.


Table created.


Table truncated.


175 rows created.


Commit complete.


Table truncated.

declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 93
ORA-06512: at line 93
ORA-01403: no data found
ORA-06512: at line 56
ORA-06512: at line 93


Is this due to version issue? We are on EBS 12.2.10

::::::::::::::
ADZDPSUM.sql
::::::::::::::
REM +======================================================================+
REM |    Copyright (c) 2005, 2023 Oracle and/or its affiliates.           |
REM |                         All rights reserved.                         |
REM |                           Version 12.0.0                             |
REM +======================================================================+
REM $Header: ADZDPSUM.sql 120.5.12020000.24 2023/02/01 09:45:19 rsatyava ship $
REM dbdrv: none
REM +=======================================================================+

[ErmanArslansOracleBlog]

It gets no data found and then character string buffer too small.

What is in the line 56 and 93 of the relevant plsql that resides in the ADZDPSUM.sql? Check that and then think.

Note: ADZDPSUM.sql - Provides a summary of the schemas that will be editioned and the schemas with objects that depend on Oracle E-Business Suite code that are recommended to be editioned.

[VinodNN]

Thanks!