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 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.1.11.1.0 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

PATCH https://cbhs-test.crm.us2.oraclecloud.com/salesApi/resources/latest/__ORACO__PromotionProgram_c/300000006862361
Req. Body: {
   "PromotionDatingProjectedCollection_c": [
    {
      "Id": 300000006862362,
      "TheatricalToDHDOffset_c": 120,
      "TheatricalToPhysicalOffset_c": 84,
      "TheatricalToVODOffset_c": 84,
      "SPVODReleaseDate_c": null
    }
  ]
}

ERROR
-----------------------
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

STEPS
-----------------------
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

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

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