My Oracle Support Banner

Getting Error 'Duplicate Values for Specific Values' Creating Data Filter on Multiple Tables (Doc ID 3035718.1)

Last updated on AUGUST 21, 2024

Applies to:

Oracle Financial Services Profitability Management Cloud Service - Version 24B and later
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service - Version 24B and later
Information in this document applies to any platform.
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service (PBSMCS)
Oracle Financial Services Profitability Management Cloud Server (PFTCS)

Symptoms

When creating a Data Element Filter with the condition below with multiple tables, an error appears on the screen.

FSI_D_ASSET.CREDIT_STATUS_CD IN ('2')
AND FSI_D_LIABILITY.CREDIT_STATUS_CD IN ('2')

After clicking add for the 2nd item, the following error appears:

Duplicate Values for Specific Values

As a result, the 2nd filter item is not saved.

Example:

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.