My Oracle Support Banner

R12:AP:APXINUPD: Supplier Merge Request Does Not Appear in View My Request Window Due to Trigger Error in JAI_AP_DVA_ARIUD_T1 (Doc ID 3062541.1)

Last updated on DECEMBER 13, 2024

Applies to:

Oracle Financials for India - Version 12.2 and later
Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

The supplier merge request does not appear in the View - My Requests Window.

Users are able to navigate to Supplier Merge form and click on the Merge button.
A pop up message appears with the request id, however, when checking the request is not found and the merge does not happen.  The request ID is shown but the actual request is not submitted.

 

Steps to reproduce:

1. Responsibility: Payables Manager

2. Navigation: Suppliers-Supplier Merge

3. Enter to and from supplier information, then click the Merge button

4. A message appears with the Request ID, however, no request can be found in the View-My Requests window

 

FND Log shows the following error:

Encountered an error in JAI_AP_DVA_TRIGGER_PKG.ARI_T1 ORA-00001: unique constraint (JA.JAI_CMN_VENDOR_SITES_PK) violated

 

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.