When we are running Concurrent Programs Executable Type is PL/Sql Procedure with Date Parameter using FND_STANDARD_DATE as a Value set , That time might be we will get the following error.
to_date(p_end_date,'RRRR/MM/DD HH24:MI:SS')
Note: Define Datatype of Parameter is Varchar2.
ORA-01861: literal does not match format string
To avoid this error , Convert the date format as per the below format.to_date(p_end_date,'RRRR/MM/DD HH24:MI:SS')
Note: Define Datatype of Parameter is Varchar2.
No comments:
Post a Comment