Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to compare dates using TRUNC in DISPLAY CONDITION in eText templates
Summary:
How to compare dates using TRUNC in DISPLAY CONDITION in eText templates
Content (please ensure you mask any confidential information):
Currently we have a requirement, where we have created an inbound interface type of HCM extract.
On the basis of data in HCM extract, we need to display records in HDL file using eText templates.
In HCM Extract, I am fetching Assignment Effective End Date. This date needs to be compared with SYSDATE in eText and only then the records needs to be printed in the text file (later on converted into HDL .dat file).
The condition is (ASSIGNMENT_EFFECTIVE_END_DATE >= SYSDATE).
Tagged:
0