SQL Language (MOSC)

MOSC Banner

ORA-01847: day of month must be between 1 and last day of month

edited Feb 18, 2010 5:19AM in SQL Language (MOSC) 13 commentsAnswered
 This is the Query,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center