Fusion Compensation: Code To Sort Date in Fast Formula
(Doc ID 2386658.1)
Last updated on JUNE 08, 2022
Applies to:
Oracle Fusion Workforce Compensation Cloud Service - Version 11.12.1.0.0 and laterInformation in this document applies to any platform.
Goal
PER_ASG_EIT_ALL_EFFECTIVE_START_DATE DBI is not give date in order wise it is giving random date in our fast formula. Same Date are assigned to multiple employees but it was not given correct dates in order for all the employees. it was picking random dates.
please see the below example what the issue we are facing.
DBI Expected Behavior is. considering example as below. category got changed manually as per the below.
Category 1 01/04/2017 to 30/06/3017
Category 2 01/07/2017 to 31/10/2017
Category 3 01/11/2017 to 31/12/2017
Category 4 01/01/2018 to 31/03/2018
Code is :
WHILE PER_ASG_EIT_ALL_EFFECTIVE_START_DATE.exists(l)
loop
(
Date2=PER_ASG_EIT_ALL_EFFECTIVE_START_DATE[l] ( expected date as per the example is 01/04/2017)
l_log_data = ess_log_write('Date : '||to_char(Date2))
i=i+1
)
Expected out is :
Date : 01/04/2017
Date : 01/07/2017
Date : 01/11/2017
Date : 01/01/2018
But we are not getting in same order as per the expected out put as per example. it is giving as below.
Date : 01/11/2017
Date : 01/07/2017
Date : 01/04/2017
Date : 01/01/2018
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 |
References |