How to Create a User Defined Queries ( UDQ ) Using Value Set for Expression ?
(Doc ID 2433998.1)
Last updated on APRIL 11, 2024
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.18.05.0 and laterInformation in this document applies to any platform.
Goal
This document will show how to use the new Release 13.18B feature of creating a function using value sets that replaces need for custom function sql code.
Sample Use Case :
User can create an expression to get the Participant's Detail attribute value.
However, currently, to use this expression, user will need to be associated a credit category to the performance measure.
This will cause unnecessary calculation processing time and increase measure results if the participant has a lot of transactions.
In order to improve performance, a custom function is recommend to get the participant's attribute value.
Solution
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
Goal |
Solution |