R12: AP: The WHO Column on All Supplier Sites Were Updated While Updating One Site's Info Using API (Doc ID 1945384.1)

Last updated on MAY 28, 2015

Applies to:

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

Symptoms

When updating supplier site attributes (e.g. VAT_CODE) using API (AP_VENDOR_PUB_PKG.Update_Vendor_Site_Public), the WHO columns in AP_SUPPLIER_SITES_ALL table of other supplier sites associated with same address also gets updated, though none of the address attributes are modified.

Example:

Data in table ap_supplier_sits_all before update: LAST_UPDATE_DATE of two sites are different.

VENDOR_SITE_ID  LAST_UPDATE_DATE      LOCATION_ID  PARTY_SITE_ID  VAT_CODE
-------------------  -------------------------  ---------------  ----------------  ------------
24125                   2006/04/07 10:48:12  37285             39242              (null)
24127                   2006/04/12 09:27:22  37285             39242              (null) 

Data in table ap_supplier_sits_all after update the VAT_CODE of VENDOR_SITE_ID:24125 to "AP_5%":
LAST_UPDATE_DATE are updated to the same.

VENDOR_SITE_ID  LAST_UPDATE_DATE      LOCATION_ID  PARTY_SITE_ID  VAT_CODE
-------------------  -------------------------  ---------------  ----------------  ------------
24125                   2014/05/20 15:29:48  37285             39242              AP_5%
24127                   2014/05/20 15:29:48  37285             39242              (null) 

Expected Behavior:

Only intended supplier site WHO columns are modified.

 

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