R12 AP Update_Vendor_Site_public API Does Not Allow To Update Existing Values To NULL (Doc ID 1684400.1)

Last updated on JUNE 22, 2015

Applies to:

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

Symptoms

The API AP_VENDOR_PUB_PKG.Update_Vendor_Site_public is not updating a field if passed NULL or '', but will update if passed ' '.
File version is $Header: appvndrb.pls 120.78.12010000.143

Internal test case used the following script to pass variables. 

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