Remove Duplicate Additional Keys

When you migrate the semantic model from Data Modeler, Semantic Modeler imports any duplicate keys contained in the model's physical tables.

When you run Check Consistency, it flags duplicate additional keys as error 40112 "The object physical table name has duplicate additional keys".

Oracle advises that it's best practice to remove all duplicate additional keys from the migrated model.

1. On the Home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Check Consistency to run check consistency on the semantic model.
4. In the Global tab, locate the first 40112 error in the error list. Click the error's physical table link.
5. In the physical table, click the General tab and scroll to Additional Keys.
6. Hover over a duplicate key and click Delete to delete the key. Repeat to remove all duplicated keys, making sure to leave one instance of the additional key in the list. For example, if there are four ORDER_KEY additional keys listed, then remove three keys and leave one in the Additional Keys list.
   Note that clicking the X next to the duplicate key doesn't delete it. You must click the Delete icon .
7. Click Check Consistency to re-run check consistency.
8. Locate each 40112 error in the error list and repeat the above steps for each.