Qualifier Lookups With Where Condition Not Working (Doc ID 2236862.1)

Last updated on FEBRUARY 23, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Compensation Plans

ACTUAL BEHAVIOR
---------------
Qualifier lookups with Where condition not working

 1. When we create Valueset by passing Where Clause the data is being populating in Create Transaction Page (Incentive Compensation-->Credits & Earnings --->Create Transaction)
 2. In same case the data is not being populating in Manage Direct Rules while trying to add Qualifier values
(Incentive Compensation-->Participants & Assignments--> Manage Direct Credit Rules.

Where Clause which we are trying to use :-

Select SUBSTR(EXTN_ATTRIBUTE_CHAR007 ,1,20)
from hz_ref_entities
where attribute_category = 'RegionDCL_c'

The data is populating when we execute above query.

 

EXPECTED BEHAVIOR
-----------------------
The data should be populated when going to Manage Direct Credit Rules



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