My Oracle Support Banner

The Expression That Created Using Value Set Is Becoming Invalid (Doc ID 2564718.1)

Last updated on SEPTEMBER 15, 2020

Applies to:

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

Symptoms

On : 11.13.19.04.0 version, Compensation Plans

ACTUAL BEHAVIOR
---------------
While creating an expression with a summarized valueset, it becomes invalid.
Should the user run the expression in a data model, the query is working as expected.

SQL Query:


From clause : cn_tp_credits_all
Value Column Name :TRX_ATTRIBUTE_NUMBER3
where clause :(1=1
  and SOURCE_EVENT_DATE=:1
  and TRX_ATTRIBUTE_NUMBER6=:2
  and TRX_ATTRIBUTE_NUMBER8=:3
  and TRX_ATTRIBUTE_NUMBER9=:4
  and CREDITED_PARTICIPANT_ID=:5)

EXPECTED BEHAVIOR
-----------------------
The expectancy is to be able to create a valid expression using the above SQL query.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. login in Fusion Application - > create expression
2. go to Edit Expression - > status is Invalid.

d expression.

Changes

 

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
Changes
Cause
Solution
References


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