to reset the sequences for creation of temp files

Issue: to reset the sequences for creation of temp files
Solutions:
you please shutdown the managers and reset the sequence to a smaller value, 1000 or so.
To do this you will need to drop and recreate the sequence.

The create statement for fnd_temp_files_s is:
create sequence fnd_temp_files_s
increment by 1
start with 1
maxvalue 9999999
minvalue 0
cache 20
cycle;