XLEUPG02.sql Failing in the R12.2 Upgrade - ORA-20000: ORA-04002: INCREMENT Must Be a Non-Zero Integerdo_ddl (Doc ID 470805.1)

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

Attempting to upgrade to R12 and receive the following error:

u444000.drv failed with $XLE_TOP/patch/115/sql/xleupg02.sql

DECLARE
*
ERROR at line 1:
ORA-20000: ORA-04002: INCREMENT must be a non-zero integerdo_ddl(APPLSYS, XLE,
19, $statement$, XLE_ENTITY_PROFILES_S): private_do_ddl(APPS, APPLSYS, XLE, 19,
$statement$, XLE_ENTITY_PROFILES_S): do_a_tab_a_seq_acd_ind(XLE, $statement$):
: do_apps_ddl(XLE, $statement$): : substr($statement$,1,255)='ALTER SEQUENCE
XLE_ENTITY_PROFILES_S INCREMENT BY 0'
ORA-06512: at line 83

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.