You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

INCREATE_DATE function not working when date variable is blank.

edited Apr 24, 2020 8:19AM in HCM Integrations 2 comments

Summary

INCREATE_DATE function not working when date variable is blank.

Content

Hi All,

ActualEndDate is returning date with time from HCM extract and i want to add 1 day in etext Template. I am using INCREASE_DATE function but it is not working when ActualEndDate is blank.
Example value in ActualEndDate = 2020-01-19T00:00:00.000Z OR BLANK

Error message - oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo11g.xpath.XPathException: Extension function error: Error invoking 'increase_date':'java.lang.NullPointerException'

Not working for Below options-->
Option1 -
IF ActualEndDate <> ‘’ Then

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!