Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How I can use SYSDATE for parameter as default value?

Dmitriy-OCJun 9 2014 — edited Sep 19 2014

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 17 2014
Added on Jun 9 2014
#applications-desktop-integrator
7 comments
2,788 views