REST Service Not Able To Clear Date Fields

(Doc ID 2203433.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Accounts, Contacts, Households
REST service not able to clear date fields  
When we send REST service to clear the date it produces error.
Below are the REST and error details

Req. Body: {
   "PromotionDatingProjectedCollection_c": [
      "Id": 300000006862362,
      "TheatricalToDHDOffset_c": 120,
      "TheatricalToPhysicalOffset_c": 84,
      "TheatricalToVODOffset_c": 84,
      "SPVODReleaseDate_c": null

java.lang.NullPointerExceptionAn instance of type class java.sql.Date cannot be created from string null. The string value must be in format YYYY-MM-DD.: null

The issue can be reproduced at will with the following steps:
1. Simulate REST service using the message above to update date.
2. getting an error

The issue has the following business impact:
Due to this issue, users cannot nullify the date


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