R12: AP: Supplier Merge Fails With "MSG-71632: Both the FROM and TO Suppliers with the same Address Name, but different addresses"
(Doc ID 2915385.1)
Last updated on DECEMBER 14, 2022
Applies to:
Oracle Payables - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
The Supplier Merge concurrent request is failing with the following excerpt in the Log file:
+---------------------------------------------------------------------------+
Payables: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
APXINUPD module: Supplier Merge Program
+---------------------------------------------------------------------------+
Current system time is 09-APR-2013 13:51:43
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_LAST_UPDATED_BY='XXXXX'
P_SET_OF_BOOKS_ID='XXXX'
P_FA_INSTALLED_FLAG='Y'
P_PO_INSTALLED_FLAG='Y'
P_PA_INSTALLED_FLAG='Y'
P_INV_INSTALLED_FLAG='Y'
P_PN_INSTALLED_FLAG='N'
P_DUP_VENDOR_ID='XXXX'
P_DUP_VENDOR_SITE_ID='YYYY'
------------
...
...
...
MSG-07161: Checking for the existing party sites which is having the different location_id
MSG-07162: with different address name but same address details
MSG-71631: ***************************************** Error Message **************************************
MSG-71632: Both the FROM and TO Suppliers have sites with the same Address name, but different addresses.
MSG-71633: Please correct it and run the supplier merge again.
MSG-71634: **********************************************************************************************
MSG-03050: Failure after duplicate_sites.
MSG-03060: Failure in function BeforeReport
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
Payables: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
APXINUPD module: Supplier Merge Program
+---------------------------------------------------------------------------+
Current system time is 09-APR-2013 13:51:43
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_LAST_UPDATED_BY='XXXXX'
P_SET_OF_BOOKS_ID='XXXX'
P_FA_INSTALLED_FLAG='Y'
P_PO_INSTALLED_FLAG='Y'
P_PA_INSTALLED_FLAG='Y'
P_INV_INSTALLED_FLAG='Y'
P_PN_INSTALLED_FLAG='N'
P_DUP_VENDOR_ID='XXXX'
P_DUP_VENDOR_SITE_ID='YYYY'
------------
...
...
...
MSG-07161: Checking for the existing party sites which is having the different location_id
MSG-07162: with different address name but same address details
MSG-71631: ***************************************** Error Message **************************************
MSG-71632: Both the FROM and TO Suppliers have sites with the same Address name, but different addresses.
MSG-71633: Please correct it and run the supplier merge again.
MSG-71634: **********************************************************************************************
MSG-03050: Failure after duplicate_sites.
MSG-03060: Failure in function BeforeReport
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
Steps to Reproduce
------------------------------------------------------------
1) Open the Supplier Merge form (Suppliers > Supplier Merge)
2) Enter a merge between two suppliers with the Copy Site box checked.
3) Submit the Merge
Changes
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 |
| Changes |
| Cause |
| Solution |