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.
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
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
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