Reset Sequences

This page is accessed via Configuration and Administration > Process Management > Reset Sequences.

This process allows you to reset sequence IDs when you load data. Sequences are typically used to generate IDs. e.g. instead of using the business number generator to generate IDs, you can generate simple numeric IDs via an Oracle sequence. They are also used to generate transmission numbers, transaction numbers, and process control request IDs. When you load data, you need to reset the IDs so the next sequence number matches the largest ID value for a column tied to a sequence.

1. Select the sequences you want to reset.
2. If you are running cluster scalability, specify a cluster to which this request should be assigned.
3. Enter a User Role. When you run, publish, or schedule a recurring process, you can specify the user role used to perform the process, just like when you run agents. The user role can be used to specify a separate VPD role or another domain to run the agent. When a recurring process is modified, the user role of the recurring process can be modified as well.
4. Select a Log Profile to generate focused logging when reproducing an error for the specific action. You cannot select a log profile when you choose to schedule a process, as automatic generation of action logs is not supported.
5. Select Execute, Publish, or Schedule to determine when the process will be executed.
6. Click Submit.