Performance issue with R12 Encumbrance Health Check for the invoice(s) matched to the PO (Diagnostic) (Doc ID 2035295.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle E-Business Suite Diagnostics - Version 12.1.3 and later
Information in this document applies to any platform.
Performance issue with R12 Encumbrance Health Check for the invoice(s) matched to the PO (Diagnostic)

Symptoms

On : 12.1.3 version, Payables

ACTUAL BEHAVIOR
---------------
diagnostic from Note.975072.1 - R12 Encumbrance Health Check for the invoice(s) matched to the PO in question runs and never completes

SQLID: dzrwnuprm3z1c
SQL TEXT: SELECT a.invoice_id, a.invoice_num, event_type_code, ledger_id FROM xla.xla_transaction_entities xt, xla_events e, ap_invoices a WHERE a.invoice_id = xt.source_id_int_1 AND a.gl_date BETWEEN :1 AND :2 AND xt.application_id = 200 AND xt.entity_code = 'AP_INVOICES' AND e.process_status_code = 'P' AND e.event_status_code = 'P' AND e.entity_id = xt.entity_id AND e.budgetary_control_flag = 'Y' AND e.event_type_code <> 'MANUAL' AND NOT EXISTS (SELECT 1 FROM xla_ae_headers ah WHERE ah.application_id = 200 AND ah.balance_type_code = 'E' AND ah.event_id = e.event_id) AND ( EXISTS (SELECT 1 FROM ap_invoice_distributions aid WHERE aid.bc_event_id = e.event_id) OR EXISTS (SELECT 'exists' FROM ap_prepay_history aph WHERE aph.bc_event_id = e.event_id) OR EXISTS (SELECT 'exists' FROM ap_prepay_app_dists apd WHERE apd.bc_event_id = e.event_id) OR EXISTS (SELECT 'exists' FROM ap_self_assessed_tax_dist aps WHERE aps.bc_event_id = e.event_id)) ORDER BY a.invoice_id, event_type_code

Changes

 NONE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms