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 DECEMBER 22, 2020
Applies to:Oracle Fusion CX Sales Cloud Service - Version 184.108.40.206.0 to 220.127.116.11.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document