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.”
Question
How to use SYSDATE as in parameter to a method call in Aurena ?
This topic has been closed for replies.
+10PlaChintW wrote:
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,
+5Hello 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
+10PlaChintW wrote:
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.
Nadeesha Liyanage - https://www.linkedin.com/in/nadeeshaliyanage/
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.