Payables and Cash Management - EBS (MOSC)

MOSC Banner

Query taking long time to execute not sure why?

edited Sep 30, 2014 6:14AM in Payables and Cash Management - EBS (MOSC) 3 comments

Hi ,

Facing some issue with the following query. It is taking days to execute. Please suggest.(Perfomance tuning issue

Need your immediate support on the same.

SELECT (SELECT haou.NAME

                  FROM apps.hr_all_organization_units haou

                 WHERE haou.organization_id = ai.org_id) circle,

               ai.invoice_num, TRUNC (ai.invoice_date) invoice_date,

               (SELECT TRUNC (MIN (ac.check_date))

                  FROM apps.ap_checks_all ac,

                       apps.ap_invoice_payments_all aip

                 WHERE aip.check_id = ac.check_id

                   AND aip.invoice_id = ai.invoice_id) payment_date,

               ass.vendor_name supplier_name, ass.segment1 supplier_number,

               ass.vendor_type_lookup_code supplier_type,

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