My Oracle Support Banner

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

Last updated on JANUARY 16, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.