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 MARCH 04, 2015

Applies to:

Oracle Legal Entity Configurator - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

Attempting to upgrade to R12 and receive the following error:

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

sqlplus -s APPS/***** @/u002/app/applmgr/OFR12appl/xle/12.0.0/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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms