Error Message REP-0613: Value does not match mask 'DD-MON-RR'
Hi, I am trying to set a concurrent request to run periodically and increment the date parameters. I have the report running as a stand alone but the date parameter was set for Char. When I changed the value set to FND_DATE_STANDARD I got the following error messages:
REP-0613: Value does not match mask 'DD-MON-RR'.
ORA-01861: literal does not match format string
REP-0091: Invalid value for parameter 'P_DATE'.
I understand that the date comes in the following format: P_DATE='2018/09/03 00:00:00' and searched for solutions. I tried all the solutions that I found which was to change the parameter in the report builder to a char and then convert it in the sql. Nothing seems to change the error. I am on EBS 12.2.4 and Report builder 10.1.2.3.0. Anyone have any other solutions I can try? Thank you.