Native Sequence

Owned by Gaurav
Last updated: Aug 01, 2023
2 min read

Overview 

Vienna has introduced option to use DB (oracle or PostgreSQL) sequences to generate new primary key of records. 

Product Version and dependency 

Native Sequence feature is supported by the below-mentioned modules:  

  1. Vienna Advantage Framework Version-  4.3.16.0 

 After module is downloaded, System administrator can see a new process in menu having name "Enable Native Sequence". 

Use 

If you wants to use Native sequences of DB instead of Vienna's Sequencing for primary keys values generation, then Login with System Administrator Role. Open menu and search for "Enable Native Sequence" process. 

Execute this process and click OK.  

This process will create sequence for each table in DB. Sequence name in for each table in Db will be TableName_Seq. For example for AD_User table, sequeuce name will be AD_User_Seq. 

 

This process will set start value of sequence by adding 1 in maximum primary key value of each table.  For Example if maximum primary key for AD_User table is 1000050, then Sequence of AD_User table in DB will start from 1000051.  

 

If you wants to see what will be next value for primary key for a table, then execute "Sequence Check" process and open "Document Sequence" window and search for your table. You will see next value for primary key for that table in Current Next textbox. 

Once you start using DB sequence, then you will not be able to use Vienna Sequencing in future. 

VServer should be in Stop mode at the time of run "Enable Native Sequence" Process