My Oracle Support Banner

Date Function Today() In Siebel Repeating Job Search Specification Error SBL-DAT-60236 (Doc ID 2769983.1)

Last updated on MARCH 28, 2023

Applies to:

Siebel CRM - Version 21.1 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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