My Oracle Support Banner

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

Last updated on APRIL 29, 2018

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.12.1.0.0 and later
Information 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!


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