Invalid Date In Function DateValue. (180,113) When New Hire Accessing Onboarding Activity Guide.

(Doc ID 2380492.1)

Last updated on MARCH 29, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.


When new hire are assigned a Onboarding template via SetupHCM>Common Definitions> Manage OnboardingEvent , getting the below error in trace file

The same template when assigned to an existing employee does not give any errors. Customer think issue could be with effective dates setup.

throw create PTAI_ACTION_ITEMS:Exception:SecurityException(&ex.ToString());
PSAPPSRV.1196 (2546) 1-727561 16.16.39 0.000000 Caught Exception: SecurityException: Invalid date in function DateValue. (180,113) AGC_PROCESS_AG.ActivityGuideCreation.OnExecute Name:SetStepDates PCPC:5535 Statement:74

Called from:AGC_PROCESS_AG.ActivityGuideCreation.OnExecute Name:InstanceCreation Statement:21

Called from:HR_OBD.OnBoardingProcessor.InstanceProcess.OnExecute Name:InstanceCreation Statement:15

Called from:PTAI_ACTION_ITEMS.List.OnExecute Name:createInstance Statement:597

The issue can be reproduced at will with the following steps:
SetupHCM>Common Definitions> Manage OnboardingEvent

The issue has the following business impact:
Due to this issue, new hires cannot complete the onboarding acivities that are critical to integrate new employees. Issue is critical since without this feature new emplyoees have no other method to complete thiese tasks.




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