R12:AP:Performance Issue While Running Supplier Merge Program. (Doc ID 2553528.1)

Last updated on JULY 08, 2020

Applies to:

Symptoms

Supplier merge program having poor performance while processing invoices related to projects.
This is the top rpc call that appear to be taking time.

PROCEDURE APPS.PA_AP_INTEGRATION.UPD_PA_DETAILS_SUPPLIER_MERGE(
P_OLD_VENDOR_ID IN PO_VENDORS.VENDOR_ID%TYPE, P_NEW_VENDOR_ID IN
PO_VENDORS.VENDOR_ID%TYPE,
P_PAID_INV_FLAG IN AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE,
P_INVOICE_ID IN AP_INVOICES_ALL.INVOICE_ID%TYPE
, X_STAGE OUT VARCHAR2, X_STATUS OUT VARCHAR2);

The binds captured in latest trace for this API are as follows. For all of
the (10k +) API executions, the same set of binds are being used.

bind 0: dty=6 bfp=7fe7b4e98ce8 flg=00 avl=03 mxl=22 val=8512
bind 1: dty=6 bfp=7fe7b4e98d20 flg=00 avl=04 mxl=22 val=640624
bind 2: dty=1 bfp=7fe7b4e98d68 flg=08 avl=01 mxl=01 val="Y"
bind 3: dty=6 bfp=7fe7b4e98d90 flg=02 avl=00 mxl=22 val=00
bind 4: dty=1 bfp=7fe7b4e98dd8 flg=0a avl=00 mxl=500 val=""
bind 5: dty=1 bfp=7fe7b4e99000 flg=0a avl=00 mxl=01 val=""

Changes

Cause

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