Payables and Cash Management - EBS (MOSC)

MOSC Banner

Performance tuning a query

Hello Experts
I have this query which has performance issues. mv_p2p_employee_data is a materialized view
Any guidance on how to fine tune this or enhance this part ?

select 'x' from mv_p2p_employee_data p2p
where p2p.employee_number = tt.emplid
and (
nvl(p2p.address_line1,' ') != nvl(upper(trim(tt.address1)),' ')
or nvl(p2p.address_line2,' ') != nvl((case when tt.address2 is null then null else upper(tt.address2) end),' ')
or nvl(p2p.city,' ') != nvl(upper(trim(tt.city)),' ')

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