My Oracle Support Banner

R12: AP: Supplier Merge Returning Error: MSG-07210: "SHIP_TO_LOCATION_ID is invalid" and/or "BILL_TO_LOCATION_ID is invalid" (Doc ID 3008928.1)

Last updated on MARCH 07, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to merge a Supplier and Site into another Supplier using the Supplier Merge form along with the Copy Site function, the following error is displayed in the log file:

ERROR
-----------------------
MSG-07200: Error after AP_VENDOR_PUB_PKG.Create_Vendor_Site...
MSG-07210: Error message... l_msg_data:SHIP_TO_LOCATION_ID is invalid
MSG-07210: Error message... l_msg_data:Ship to Location information is inconsistent
MSG-07210: Error message... l_msg_data:BILL_TO_LOCATION_ID is invalid
MSG-07210: Error message... l_msg_data:Bill to Location Info is inconsistent
MSG-07210: Error message... l_msg_data:Invalid Payee context values. Org parameters exist only with party site and supplier site.
MSG-07230: Error after create vendor site... Update process flag to N
MSG-07460: Error in function 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:


The issue can be reproduced at will with the following steps:
1. Payables Responsibility

2. Suppliers-> Supplier Merge

3. Enter the From and To Supplier information and submit the Merge.

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


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