Not Able To Recognize The Sysdate Parameter When Running ESS Job - JBO-25009: Cannot create an object of type:java.sql.Timestamp
Last updated on OCTOBER 06, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Information in this document applies to any platform.
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.
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