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:
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 (
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!