You can make fields blank in Oracle by using the [BLANK] functionality in Event Wizard.
When you are changing an existing record, if you leave a field blank by default, the current value will not be changed as the Oracle API’s do not treat null values as updates. However, in some circumstances you actually want to force the field to be changed to Blank (no value).
Therefore, if you want to override a field in Oracle with a null you must enter [BLANK] in the cell before you upload. You can key this directly into the spreadsheet or enter it into the form.
On upload the value will be changed to have no value.
Note - You should not use this functionality on any mandatory field values.
