My Oracle Support Banner

R12: Supplier Merge Program Not Completing, Performance Issue (Doc ID 2469947.1)

Last updated on JULY 08, 2020

Applies to:

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

Symptoms

We began the Supplier Merge Program for Vendor_id = 3000 and it is not completing.
We had the kill the session twice and kicked it off again, but it is not completed yet and should take up to 15mins. I asked our DBA to have a look and this was his response:

The session in the database associated with that job is currently active but appears to be hung and DB process is consuming one CPU on the DB server.

The session is currently executing the following SQL :

select DISTINCT PO_DISTRIBUTION_ID FROM AP_INVOICE_DISTRIBUTIONS_ALL APD, AP_INVOICES_ALL A
WHERE A.VENDOR_ID = AND A.INVOICE_ID = APD.INVOICE_ID AND
APD.PROJECT_ID > 0 AND APD.PO_DISTRIBUTION_ID IS NOT NULL;

 - Unable to merge suppliers

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payables responsibility
2. Go to Suppliers > Supplier Merge
3. Enter the information and click on the Merge button



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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