My Oracle Support Banner

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 to [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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.