Fusion Compensation: Code To Sort Date in Fast Formula (Doc ID 2386658.1)

Last updated on JUNE 08, 2022

Applies to:

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

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