R12 AP: Invoices Entry form (APXINWKB) hangs when navigating to Invoice Lines region
(Doc ID 1446994.1)
Last updated on MAY 01, 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:
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!
In this Document