Supplier Site Open Interface Import Error: 'Inconsistent data entered as compared to TCA records' (Doc ID 1357098.1)

Last updated on OCTOBER 08, 2014

Applies to:

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

Symptoms

Supplier Site Contact import fails when vendor_site_id is  not provided in the interface table(vendor_id,vendor_site_code and org_id are provided).
This is because the procedure  Check_Org_Id_Name_Site_Code() did not make use of the vendor_id to determine the vendor_site_id.
Query :
SELECT vendor_site_code, vendor_site_id
INTO l_vendor_site_code,p_vendor_site_id
FROM PO_VENDOR_SITES_ALL
WHERE org_id = p_org_id
AND vendor_site_code=p_vendor_site_code

returned multiple rows for several vendors, since a filter on vendor_id is missing.

This issue has been identified in  <Bug:12747925>

Changes

Supplier Site Contact import successfully imports vendors  after the following change
 
Code has been changed as below:

PROCEDURE Check_org_id_name_site_code
(p_org_id IN NUMBER,
p_org_name IN VARCHAR2,
p_vendor_site_id IN OUT NOCOPY
NUMBER,
p_vendor_site_code IN VARCHAR2,
p_vendor_id IN VARCHAR2,
/* Bug 9844445 */
p_int_table IN VARCHAR2,
p_int_key IN VARCHAR2,
x_valid OUT NOCOPY
BOOLEAN) IS

...................
if(p_vendor_site_id is not null) then
...................................
else

SELECT vendor_site_code, vendor_site_id
INTO l_vendor_site_code,p_vendor_site_id
FROM PO_VENDOR_SITES_ALL
WHERE org_id = p_org_id
AND vendor_site_code= p_vendor_site_code
AND vendor_id=p_vendor_id;

Supplier Site Contact import successfully imports Contact.

Cause

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