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

(Doc ID 1446994.1)

Last updated on MARCH 16, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

OA release 12 - Invoices workbench
 
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

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