Date Alias With Days Subtraction Returns Incorrect Or Invalid Dates Intermittently

(Doc ID 2324751.1)

Last updated on NOVEMBER 03, 2017

Applies to:

PeopleSoft Enterprise HCM Pension Administration - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

A Date Alias that adjusts a date by a negative number of days will not consistently calculate correctly, even occasionally calculating invalid dates. For example, the Date Alias for November 30, 2017 plus a negative 244 days should return a date of 3/31/2017 but returns 3/30/2017; the Date Alias for October 31, 2017 plus a negative 184 days should return a date of 4/30/2017 but returns 4/31/2017, which is not even a valid date.

STEPS
---------------------------
1. Create a Date Alias that adds negative days to a date (Navigation: Set Up HCM > Product Related > Pension > Variable Definitions).
2. Set up a Pension Calculation that uses that Date Alias, for example, as Event Date (Navigation: Pension > Calculations > Define Calculation).
3. Run the Pension Calculation (Navigation: Run This Calculation link).

Cause

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 hundreds of Community platforms