to_char problem

[omegamark]

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 ???

[akkerend]

Data and Oracle version are also the same?
Maybe in production values of tsa.plus_id contain non-numeric characters.

[omegamark]

VERSION is one and the same in both.

both have numeric values only.