Regarding e-text template used in HCM extracts — Cloud Customer Connect
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

Regarding e-text template used in HCM extracts

edited May 30, 2019 5:12AM in Reporting and Analytics for HCM 1 comment

Summary

Regarding transformation on e-text template

Content

Hi,

We need to transform the date on the text template used in an extract.What we need is to add + 1 day in the termination date extracted using DBI from the extract.

When I check the documentation for etect templates I see there is a increase date function i.e. increase_date(Person_Work_Term_Date, 1) which achieves this functionality.

But this fails when Person_Work_Term_Date, is NULL giving the following error on template viewer:

 

<Line 2167, Column 135>: XML-22044: (Error) Extension function error: Error invoking 'increase_date':'java.lang.NullPointerException'
@Line 2167 ==> <xsl:variable name="v333" select="xdoxslt:increase_date(xdoxslt:normalize_string($_XDOCTX, (.//Person_Work_Term_Date)[1]), 2)"/>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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