I have a method that accept company and the system date as in Parameters. But when I specified ${TRUNC(SYSDATE)} when map the values to parameter it gives the error saying “Sorry, there was an unexpected server error.”
How to use SYSDATE as in parameter to a method call in Aurena ?
Userlevel 2
+5
This topic has been closed for comments
Userlevel 5
+9
I have a method that accept company and the system date as in Parameters. But when I specified ${TRUNC(SYSDATE)} when map the values to parameter it gives the error saying “Sorry, there was an unexpected server error.”
Hi
Could you please try removing the trunc?
Also are you trying to pass the parameters from a command? Hope I understood this correctly.
Thanks,
Regards,
Userlevel 2
+5
Hello Nadeesha,
Thank you for the reply.
I have changed the in parameter to ${SYSDATE}, but the error is still there.
Parameters defined as follows.
the error message is as follows.
Thank you and best regards,
Chinthaka
Userlevel 5
+9
Hello Nadeesha,
Thank you for the reply.
I have changed the in parameter to ${SYSDATE}, but the error is still there.
Parameters defined as follows.
the error message is as follows.
Thank you and best regards,
Chinthaka
Hi Chinthaka,
I tried this out myself and it worked fine.
You have added the Company parameter correctly. same way it should work for the SYSDATE too.
try passing your SYSDATE as $[sysdate].
Adding the documentation link for future references.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.