Is it possible to change the auto incremental format?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We notice the following after creating a custom object in the UI:

1. A corresponding table gets created in the DB
2. The table's name is of the form odf_ca_<custom-object-id>
3. That this table has a column called ID whose values get incremented one at a time, starting from 5000000 (5 million).

We would like to know, if it is possible to change this behaviour to start the numbers from 6 million, instead of 5.

Environment

Version: 16.0.1

Resolution

It is possible to do this by altering the sequence that the application uses for the ID column. However, this is not recommended or supported.