12.2 E-Business Suite Applications DBA Upgrade Driver Fails On Script xleupg02.sql With Error 'ORA-20000: ORA-04002: INCREMENT must be a non-zero integer'
(Doc ID 2441004.1)
Last updated on OCTOBER 02, 2020
Applies to:Oracle Applications DBA - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.
E-Business Suite 12.2 Applications DBA, Upgrade related issues
During E-Business Suite upgrades (for example from 12.1.3 to 12.2.6), the patch driver fails on script xleupg02.sql with the following error:
ERROR at line 1:
ORA-20000: ORA-04002: INCREMENT must be a non-zero integer do_ddl(APPLSYS,
19, $statement$, XLE_ENTITY_PROFILES_S): private_do_ddl(APPS, APPLSYS, XLE,
$statement$, XLE_ENTITY_PROFILES_S): do_a_tab_a_seq_acd_ind(XLE,
: do_apps_ddl(XLE, $statement$): : substr($statement$,1,255)='ALTER SEQUENCE
XLE_ENTITY_PROFILES_S INCREMENT BY 0'
ORA-06512: at line 83"
The issue can be reproduced at will with the following steps:
1. Applying 12.2 driver patch
The issue has the following business impact:
Due to this issue, users cannot apply the 12.2 driver patch.
Upgraded EBS from 12.1.3 to 12.2.6.
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