Delete a column value using Customer FBDI

 

Scope: 

         This post will help you to know how to remove a column value which is already existing in the database using the Customer FBDI

Requirement:

        In many cases, we import or update the data into Oracle Fusion cloud ERP instances using the FBDI approach. So, here we may need to update the existing column value to NULL (means removing the column value) as per the requirement. This can be achieved using a particular process.

How To Do:

      The correct symbol in the column to be used when you want to update the value of a field to blank is "!".So, instead of #NULL please use "!" and it should work. The #NULL value is to be used in the WEBSERVICE input payload. #NULL will not work in cases of FBDI. Keep in mind that if you upload fresh data (creation step) the system will see "!" as a normal character and will upload it as is. It works as a nullifier when you have some data in that specific field. "!" cannot be used to update Date columns to NULL.

 I hope this helps.