ORA-01847: day of month must be between 1 and last day of month
select * from APPS.AR_RECEIVABLE_APPLICATIONS_ALL app
where app.creation_date BETWEEN NVL (TO_DATE ('&2','DD-MON-RRRR'),app.creation_date)
AND NVL (TO_DATE (&3','DD-MON-RRRR'),SYSDATE)
where &2 = 24-SEP-2009 and &3 = 25-SEP-2009
this is registered as an Concurrent Program in Oracle E Business Suite 11.5.10.2 version, but when ever i'm running the concurrent Program the Followin error crops up
AND NVL (TO_DATE ('00:00:00','DD-MON-RRRR'),SYSDATE )
*
ORA-01847: day of month must be between 1 and last day of month
Please guide me how to over come this issue.