Date Function Today() In Siebel Repeating Job Search Specification Error SBL-DAT-60236
(Doc ID 2769983.1)
Last updated on APRIL 27, 2021
Applies to:Siebel CRM - Version 21.1 and later
Information in this document applies to any platform.
Date math using Date function Today() in Siebel Repeating Job Search Specification is causing error.
The issue can be reproduced at will with the following steps:
1. Configure a Repeating Asynchronous Job to call Workflow Process Batch Manager
2. Define search specification parameter for the Job using expression: [Id]='1-2V-680' AND [XXX Fiscal Full Year Date] = (Today() - 1)
3. Job Fail with Error
Same error is also seen when executing query from UI and using same search specification.
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