R12 AP: Invoices Entry form (APXINWKB) hangs when navigating to Invoice Lines region (Doc ID 1446994.1)

Last updated on DECEMBER 15, 2021

Applies to:

Symptoms

Invoices workbench (APXINWKB) hangs when navigating to Invoice Lines region of the form.

The SQL statement that is taking long time is the following:

SELECT event_status_code
FROM xla_events
WHERE event_date = NVL (:b7, event_date)
AND event_type_code = NVL (:b6, event_type_code)
AND event_status_code = NVL (:b5, event_status_code)
AND event_number = NVL (:b4, event_number)
AND event_id = NVL (:b3, event_id)
AND entity_id = :b2
AND application_id = :b1
AND event_type_code IN (
SELECT event_type_code
FROM xla_event_types_b
WHERE application_id = :b1
AND entity_code = :b9
AND event_class_code = NVL (:b8, event_class_code))

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.