Requisition Form POXRQERQ Hangs When Entering Destination Org Field (Doc ID 2038672.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Performance issue observed as follows:

SELECT PASL.ASL_ID, PAA.USING_ORGANIZATION_ID, PASL.PRIMARY_VENDOR_ITEM,
  PAA.PURCHASING_UNIT_OF_MEASURE, PAA.CONSIGNED_FROM_SUPPLIER_FLAG,
  PAA.ENABLE_VMI_FLAG
FROM
 PO_APPROVED_SUPPLIER_LIS_VAL_V PASL, PO_ASL_ATTRIBUTES PAA,
  PO_ASL_STATUS_RULES_V PASR, PO_VENDOR_SITES_ALL PVS WHERE PASL.ITEM_ID =
  :B5 AND PASL.VENDOR_ID = :B2 AND PASL.USING_ORGANIZATION_ID IN (-1, :B4 )
  AND PASL.ASL_ID = PAA.ASL_ID AND PASR.BUSINESS_RULE = '2_SOURCING' AND
  PASR.ALLOW_ACTION_FLAG ='Y' AND PASR.STATUS_ID = PASL.ASL_STATUS_ID AND
  PAA.USING_ORGANIZATION_ID = :B4 AND NVL(PVS.ORG_ID,-99) = NVL(:B3 , -99)
  AND PVS.VENDOR_ID = :B2 AND ( (PASL.VENDOR_SITE_ID IS NULL AND :B1 IS NULL)
  OR ( PASL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID AND PVS.VENDOR_SITE_CODE =
  :B1 ) ) ORDER BY PASL.VENDOR_SITE_ID ASC


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 10 0.00 0.00 0 0 0 0
Fetch 10 243.21 403.16 0 105748598 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 21 243.21 403.16 0 105748598 0 2

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