R12.1.1 upgrade driver fails with error ORA-04013: number to CACHE must be less than one cycle
Hi,
Issue: We are upgrading our e-business suite from 12.0.6 to 12.1.1,as a part when we applying 12.1.1 patch 7303030 it fails with below error.
R12.1.1 patch 7303030 fails with below error.
The sequence FV_PAYMENT_SUMMARY_SCH_S in the database is defined as:
MINVALUE = 1 MAXVALUE = 2147483647 INCREMENT BY = 1
CYCLE = NO ORDER = NO CACHE = 1000
which should be defined as:
MINVALUE = 1 MAXVALUE = 999 INCREMENT BY = 1
CYCLE = YES ORDER = NO CACHE = 20
Start time for statement below is: Thu Oct 03 2013 05:42:17
ALTER SEQUENCE FV.FV_PAYMENT_SUMMARY_SCH_S MAXVALUE 999 CYCLE
AD Worker error:
The following ORACLE error:
ORA-04013: number to CACHE must be less than one cycle
occurred while executing the SQL statement:
Tagged:
0