Not Able To Recognize The Sysdate Parameter When Running ESS Job - JBO-25009: Cannot create an object of type:java.sql.Timestamp (Doc ID 2287026.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Goal

Scheduled a job "Revenue Territory Territory Based Assignment" with view criteria "OpenOpportunitiesByCreationDate" with Bind Values "BindOptyCreationDateFrom=sysdate-1"
This job is been errored out because of the following reason “JBO-25009: Cannot create an object of type:java.sql.Timestamp from type:java.lang.String with value:sysdate-1”

Is the system/application unable to recognize the sysdate parameter?

NOTE: Had input the bind value as "BindOptyCreationDateFrom=sysdate-1" to ensure that assignment runs only for the Opportunities that are created in last 24 hrs.
 

Solution

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