How to Update NULL value in VARCHAR2 Data Type of table field (Address3 of HZ_LOCATIONS) via a TCA Business Object API (HZ_LOCATION_BO_PUB) using REST Service (Doc ID 2939219.1)

Last updated on MARCH 31, 2023

Applies to:

Goal

Demonstrate how to update NULL value in VARCHAR2 data type of table field (Address3 of HZ_LOCATIONS) via a TCA Business Object API (HZ_LOCATION_BO_PUB) using REST service.

Whenever we are trying to update a null value in the address3 field, the field value is not getting updated, It remains same as previous value if we pass the value as NULL or '' (Blank). The address3 value can be updated to any other value, but unable to update to null.

Solution

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