Custom objects: Is it possible to have some kind of unique key made from X and Y custom fields, so it won't be possible to add, via import, two or more records with same combination of X and Y? (Doc ID 2138676.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

Customer has a custom object named "X" and on this, among others, two custom fields: "X" (type: Name) and "Y" (type: DCL).

The requirement is that to create some kind of unique key from the fields "X" and "Y", so it won't be possible to add two or more records with same combination of "X" and "Y".

Can this work for Import added records?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms