Use Custom Field As Unique Identifier When The Field Is Populated (Doc ID 2278177.1)

Last updated on JUNE 19, 2017

Applies to:

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

Goal

Customer has created a custom field for Accounts, called "BP Number".
Is there a way to make this field unique to an Account.

The field must hold a unique value only if the user is passing a value for the field.

User should be able to create a record without providing the value for the field at creation time.
 

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