7 Replies Latest reply on Sep 19, 2014 2:38 PM by 874594

    How I can use SYSDATE for parameter as default value?

    Dmitriy-OC

      Hello.

       

      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.