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!

WEBADI - How I can use SYSDATE for parameter as default value?

User_V9S4YJun 9 2019 — edited Jun 26 2019

Hello,

I want to use SYSDATE for parameter as default value but I don't know how to set.

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 "Please enter a date in format dd-MM-yyyy Cause: A date was entered in the wrong format. Action: Use the correct format for entering dates."

Could you please help?

Thanks,

Added on Jun 9 2019

#applications-desktop-integrator, #parameter

1 comment

367 views