ApInvPoShipmentsVO Query taking too long to fetch results
Last updated on JANUARY 16, 2018
Applies to:
Oracle Payables - Version 12.2.3 and laterInformation 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