Supplier Merge Program Taking Long To Complete (Doc ID 2044051.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Supplier Merge Program taking long to complete

Symptoms

On : 12.1.3 version, Other-MiscIss & KeyIndReport

The client has observed that the Supplier merge program is running for very long time because of which the suppliers are not merged. Due to this many invoices are pending for payment.

SQL ID: 2p3yqszsmcasa Plan Hash: 691589044

UPDATE RCV_TRANSACTIONS SET VENDOR_ID = :B5 , VENDOR_SITE_ID = :B4 ,
LAST_UPDATED_BY = :B3 , LAST_UPDATE_DATE = SYSDATE
WHERE
SOURCE_DOCUMENT_CODE = 'PO' AND VENDOR_ID = :B2 AND VENDOR_SITE_ID = :B1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1     80.41     366.13     320569     441217          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2     80.41     366.14     320569     441217          0           0

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