I am using the following code
#prompt('fiscal','integer','year(getdate())')# for making the current year as default selection in value prompt
but i am getting the below error..
RQP-DEF-0177
An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-00904: "YEAR": invalid identifier
it urgent , please clarify
...looks like you are using Microsoft syntax to talk to an Oracle database..
try this instead:
your: year(getdate())
...will need to be something more like:
to_integer(to_char(sysdate(),'yyyy'))
(sorry, i don't have an oracle db to test against, but hopefully you get the idea)