What's new in Customer Journeys?

Connect and learn more!
How to create custom function for Calculation where settlement date determines multiplier? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create custom function for Calculation where settlement date determines multiplier?

Accepted answer
33
Views
1
Comments
edited Jun 3, 2023 8:46PM in Incentive Compensation 1 comment

**This post was created as part of a How to Service Request (SR)

Release:

23B

Summary of the question:

How to create custom function for Incentive Compensation which gives the following data -

SELECT

EARN_TRX.OUTPUT_ACHIEVED * NVL((Select 0 from dual where Months_Between(TO_DATE(:2,'DD/MM/YYYY'),TO_DATE(BASE_TRX.ATTRIBUTE21,'DD/MM/YYYY')) > 18),nvl((Select .5 from dual where Months_Between(TO_DATE(:2,'DD/MM/YYYY'),TO_DATE(BASE_TRX.ATTRIBUTE21,'DD/MM/YYYY')) > 12 and Months_Between(TO_DATE(:2,'DD/MM/YYYY'),TO_DATE(BASE_TRX.ATTRIBUTE21,'DD/MM/YYYY')) <=18),nvl((Select 1 from dual where Months_Between(TO_DATE(:2,'DD/MM/YYYY'),TO_DATE(BASE_TRX.ATTRIBUTE21,'DD/MM/YYYY')) <= 12),0)))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!