R12: AP: Invoice Workbench (APXINWKB) Hangs While Trying To Enter A New Invoice and Invoice Lines (Doc ID 2110375.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.
Invoice Workbench (APXINWKB) Hangs While Trying To Enter A New Invoice and Invoice Lines

Symptoms

While trying to enter invoice lines the system hangs.

The trace shows significant elapsed time for the following query:

SELECT COUNT (1)
FROM
AP_INVOICE_DISTRIBUTIONS_ALL AID   WHERE AID.INVOICE_ID =  :b1  AND
 AID.ORG_ID =  :b2  AND AID.POSTED_FLAG =  'Y'  AND ROWNUM  =  1  


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1    284.72    2449.27    4127336    4164066          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2    284.72    2449.27    4127336    4164066          0           0

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