FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated.

Issue:
=====
FDUUID failed due to ORA-08004: sequence
FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated.
TheCall to establish_icm failed
The Internal Concurrent Manager has
encountered an error.

Cause:
======

SQL> select
FND_CONCURRENT_PROCESSES_S.nextval from dual;
select FND_CONCURRENT_PROCESSES_S.nextval
from dual
*
ERROR at line 1:
ORA-08004: sequence
FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and
cannot be instantiated

The FND_CONCURRENT_PROCESSES_S Max value is
reached. we need to increase this value

SQL> select * from dba_sequences
where sequence_name =
‘FND_CONCURRENT_PROCESSES_S’ 2 ;

SEQUENCE_OWNER SEQUENCE_NAME MIN_VALUE
MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
—————————— —————————— ———- ———- ———— – –
———- ———–
APPLSYS FND_CONCURRENT_PROCESSES_S 1 9999999
67778 N N 1000 10048596

Solution:
=========

Increase max value;(shoud be greater Than
previoue Max value)

SQL> ALTER SEQUENCE
APPLSYS.FND_CONCURRENT_PROCESSES_S MAXVALUE 99999999;

Sequence altered.

Doc: Concurrent Manager Does Not Startup
ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE
  • July 11, 2017 | 20 views
  • Comments