R12: AP: Supplier Merge Is Failing with "MSG-71632: Both The FROM And TO Suppliers Have Sites With The Same Address Name..." (Doc ID 1545227.1)

Last updated on MARCH 09, 2016

Applies to:

Oracle Payables - Version 12.0.1 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Goal

Supplier Merge fails with the following 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='13451'
P_SET_OF_BOOKS_ID='2023'
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:

 

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms