My Oracle Support Banner

Fusion Global HR: Default SQL Value Is Not Working For PER_PPS_DF (Doc ID 2798838.1)

Last updated on AUGUST 11, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Default SQL Value is not working for PER_PPS_DF

When trying to return a default value on a flexfield during a Termination, it is not defaulting the date from the attribute.


EXPECTED BEHAVIOR
-----------------------
The expected result is to have a default value on the flexfield as a result of the SQL, when we are performing a Termination.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Edit Descriptive Flexfiled: Work Relationship Attributes

PER_PPS_DF

Global Segments
 110 Start date (attribute_date4)
 120 Ending Date (attribute_date5)


Select substr(start_date,1,10) from ANC_PER_ABS_ENTRIES
where Start_date > Sysdate and
ABSENCE_STATUS_CD = 'SUBMITTED' and
APPROVAL_STATUS_CD = 'APPROVED' and
PERSON_ID = :{PARAMETER.PERSON_ID} and
ROWNUM <=1
ORDER BY PER_ABSENCE_ENTRY_ID

or

Select TRUNC(end_date) from ANC_PER_ABS_ENTRIES
where Start_date > Sysdate and
ABSENCE_STATUS_CD = 'SUBMITTED' and
APPROVAL_STATUS_CD = 'APPROVED' and
PERSON_ID = :{PARAMETER.PERIOD_OF_SERVICE_ID} and
ROWNUM <=1
ORDER BY PER_ABSENCE_ENTRY_ID



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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