EBS Customizations (MOSC)

MOSC Banner

strange output of SQL query in EBS

edited Apr 10, 2014 12:00PM in EBS Customizations (MOSC) 2 commentsAnswered

Hello ,

i have a report  retrieves data according to entered parameters criteria in Toad and Report builder environment

and does not retrieve any data when i run it from EBS environment !

in the where clause in the query there are 4 parameters as following :

  1. ORGANIZATION_ID=:org
  2. 2.and to_date(f_trx_dt(l.ORGANIZATION_ID,h.HEADER_ID),'dd/mm/yyyy') between nvl(to_date(:dt1,'dd/mm/yyyy'),to_date('1/1/2010','dd/mm/yyyy'))

            and nvl(to_date(:dt2,'dd/mm/yyyy'),to_date('1/1/2050','dd/mm/yyyy'))

  1. h.REQUEST_NUMBER = nvl(:mov_ord, h.REQUEST_NUMBER)
Tagged:

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