Custom Object Duplicate Name Restriction Not Working (Doc ID 2101806.1)

Last updated on FEBRUARY 08, 2016

Applies to:

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

Symptoms

The customer has a Custom Object.
The names of the records of this custom object are created automatically via a script, that concatenates multiple values from different fields of this object.
The fields for which the values are pulled to make the name are auto-populated upon creation from values of the Revenue Object.

This Custom Object has Out of The box Validation rule (Prevent duplicate values?) enabled.

Problem is that record names formed in this manner can be duplicated, meaning same name will be put for multiple records.

Cause

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