My Oracle Support Banner

ORA-04013: Number To CACHE Must Be Less Than One Cycle "Patch 7303030" (Doc ID 2376683.1)

Last updated on APRIL 18, 2018

Applies to:

Oracle Applications DBA - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

I have issue during apply upgrade Patch 7303030 as below:
------------------------------------------------------------------------
-> Failed worker fvfs.odf

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

Alter the sequence with :


Start time for statement below is: Mon Mar 19 2018 14:00:45

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:

ALTER SEQUENCE FV.FV_PAYMENT_SUMMARY_SCH_S MAXVALUE 999 CYCLE

AD Worker error:
Unable to compare or correct sequences
because of the error above

ERROR
-----------------------
ORA-04013: number to CACHE must be less than one cycle "Patch 7303030"

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!


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