My Oracle Support Banner

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 FEBRUARY 03, 2019

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

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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