Hi I am trying to calculate the US Fiscal year for three parameters 1) The start date of the course 2) the end date of the course 3) the date of the request submisson. I have successfully created a Oracle DB procedure which has these three values as the input values and outputs the fiscal year based on these into hidden data labels on the view. However whenever I go to create my SMO method I get the following error :
I presumed that this was due to the face that I already have a create procedure referencing this 'REQUEST_DATE' field. Therefore I then took a copy of this SMO renamed and deleted all SMOs bar the one I currently need but I am still getting the same error as above. I would be grateful for any help or assistance.