ApInvPoShipmentsVO Query taking too long to fetch results (Doc ID 2044093.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.2.3 and later
Information in this document applies to any platform.
ApInvPoShipmentsVO Query taking too long to fetch results

Symptoms

When inquiring by PO the iSupplier Portal is timing out searching for POs

SELECT * FROM (select Q.*,
      nvl(to_char(length(TRIM(TRANSLATE(q.po_number_display, '0123456789', '
')))), 'NUM') po_num_is_numeric,
      nvl(to_char(length(TRIM(TRANSLATE(q.line_num, '0123456789', ' ')))),
'NUM') po_linenum_is_numeric
 from
(
QRSLT  WHERE (PO_NUMBER LIKE :1 AND  ORG_ID = :2 AND SQL_TYPE = 'QUERY
WITHOUT RELEASE' AND NVL(PAY_ON_CODE, 'NULL')

call     count       cpu    elapsed       disk      query    current      rows
------- ------  -------- ---------- ---------- ---------- --------------------
Parse        1      0.00       0.00          0          0          0       0
Execute      1      0.00       0.00          0          0          0     0
Fetch        1   1526.68   22826.94    2613898   61594701          0        11
------- ------  -------- ---------- ---------- ---------- --------------------
total        3   1526.68   22826.95    2613898   61594701          0        11

Changes

 NONE

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