-
In my Integeration unit one of the view like
where rt.id = tsa.plus_id
and t.party_id = p.party_id
and t.party_id = st.party_id(+)
/
is working fine .
when moved to production it is not working.
but when sufficed like to_char it works fine
where rt.id =to_char( tsa.plus_id)
and t.party_id = p.party_id
and t.party_id = st.party_id(+)
/
all the base tables have the same datatypes .
any idea why ???
-
Data and Oracle version are also the same?
Maybe in production values of tsa.plus_id contain non-numeric characters.
-
VERSION is one and the same in both.
both have numeric values only.