My Oracle Support Banner

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:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


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))


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

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