My Oracle Support Banner

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

Last updated on JANUARY 16, 2018

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

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.