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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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