I want to do the same thing and it is very frustrating because there is little documentation on how that formula works.
What do you mean by: "I define SYSDATE value in parameters of function from FORMs" ?
About the particular error message, minutes are identified by mi instead of mm:
select to_char(sysdate,'dd-MM-yyyy') from dual
but it always gives this message:
Exception Name: oracle.apps.bne.exception.BneParameterException - 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. Log File Bookmark: 362515
Try using a standard one:
Param Definition Application ID: 800 -- (PER)
Param Definition Code: 'HR_STANDARD_SESS_DATE'
Param Name: 'hr:sessionDate'
Attribute App Id: 800 -- (PER)
Attribute Code: 'HR_STANDARD_NO_SAVE'
We need to have the date parameter field populated by a value from sysdate.
I checked all HR related parameters list, and it seems all the dates there are blank.
Is there any existing example which have sysdate as the default value?
Also, how the parameter attributes are used?
The Dev Guide from Oracle only tell you how to create it which is alright, but I want to know what to put there and how it is going to be used. I wonder if there is any documentation on this.Cuauhtemoc Amox
I tried $env$.sysdate too but it is not accepted. From what I read on the dev guide $env$ only has appid, userid, language, respid and sessionid.
I am also facing the same issue,Session date is not getting defaulted in Content Parameters page in webadi,If Anyone got the solution.Plz share it.