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