Requisition Form POXRQERQ Hangs When Entering Destination Org Field and Reqimport Performance Is Slow (Doc ID 2038672.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Symptoms

Users have experienced performance issues on the forms and also importing requisitions when populating the destination_org_id fields in the PO_REQUISITIONS_INTERFACE_ALL table.
Performance with Reqimport is also slow at times

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.