My Oracle Support Banner

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 MAY 20, 2024

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References

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