Unique Checkbox

Owned by Gaurav
Last updated: Jul 27, 2023
2 min read

Overview 

This Document helps user to understand use of 'Unique' checkbox introduced on 'Column' tab of 'Table and Column' window. On save of data on any window, in case of database constraint system shows message like 'Could not save record - Require unique data: ORA-00001: unique constraint (VIENNADBC_ORDER_DOCUMENTNO) violated'. This feature will show name of unique column in message. 

Product Version and Dependency 

This feature is supported by 'Vienna Advantage Framework <4.2.18.0>'  

How to Use 

  1. Login with 'System Administrator' role. 

  2. Open 'Table and Column' window. 

  3. Search and select table, for example c_order. This table have unique constraint of on following three columns Document No, Business Partner and Target Doc Type. 

  4. Go to 'Column' tab 

  5. Tick 'Unique' checkbox on columns mentioned in step 3. 

  1. Now login with any role have 'Sales Order' window access. 

  2. Create two sales order against same Business Partner, Document No and Target Doc Type, on save following error message will show "Could not save record - Require unique data: Document No., Target Doc Type, Customer". 

 

If user create new table and used 'Unique' checkbox, system will create constraint in database. However, in case of existing table no constraint will add in database.