Creating new View Template ORA-8004 Sequence View_template_column_seq Exceeds Maxvalue

(Doc ID 395984.1)

Last updated on MAY 13, 2011

Applies to:

Oracle Clinical - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Symptoms

When trying to create a view template the following error is displayed in the forms message bar:

ORA-08004: sequence VIEW_TEMPLATE_COLUMN_SEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated. ORA-06512 at "RXC.RXCCOPYTEMPLATES", line 102

- The error also happens if you try to copy a view template.

Cause

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 hundreds of Community platforms