Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.1 upgrade driver fails with error ORA-04013: number to CACHE must be less than one cycle

edited Oct 8, 2013 12:22AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered

 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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center