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
Skip to content
  • 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

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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