My Oracle Support Banner

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

Last updated on JANUARY 16, 2018

Applies to:

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


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


To view full details, 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 a vibrant support community of peers and Oracle experts.