7 Replies Latest reply: Sep 19, 2014 9:38 AM by 874594 RSS

    How I can use SYSDATE for parameter as default value?




      By now as workaround, I define SYSDATE value in parameters of  function from FORMs.

      But I would like to avoid it.


      I tried use in field "Formula" at define parameter in different variants: (SYSDATE, to_char(SYSDATE, 'yyyy-MM-dd HH:mm:ss'), select to_char(SYSDATE, 'yyyy-MM-dd HH:mm:ss') from dual), but get error:

      "Exception Name: oracle.apps.bne.exception.BneParameterException - Input date in format  yyyy-MM-dd HH:mm:ss"


      Regards, Dmitriy.