ADM Validate Filter Failed With "Unsupported Binary Operator: '-' in query specification" (SBL-EAI-04179) When Using Today() Or Timestamp() With The "-" Or "+" Characters (Doc ID 2967288.1)

Last updated on OCTOBER 19, 2023

Applies to:

Symptoms

When validating a filter for an ADM Project with Deployment Filter using Today() or Timestamp() with the "-" or "+" characters, the validation failed with the error message below:

ObjMgrBusServiceLog InvokeMethod 4 0000265c64be0b8c:0 2023-08-10 09:03:13 Begin: Business Service 'EAI Query Spec Service' invoke method: 'QuerySpecToSiebelMsg' at 25f2daa0
EAIQrySpec EAIQrySpecParams 3 0000265c64be0b8c:0 2023-08-10 09:03:13 The Query Specified for Object Id '' of type 'Query List' is '[Admin Query List.Created] >= Timestamp () - 28 AND [Admin Query List.Private] = "N"'
EAIInfra EAIInfraOutputMsg 3 0000265c64be0b8c:0 2023-08-10 09:03:13 Output Message: IntObjType=Query List Format=Siebel Hierarchical
ObjMgrBusServiceLog Error 1 0000265c64be0b8c:0 2023-08-10 09:03:13 (eaiqryspec.cpp (614)) SBL-EAI-04179: Unsupported Binary Operator: '-' in query specification '[Admin Query List.Created] >= Timestamp () - 28 AND [Admin Query List.Private] = N'
ObjMgrBusServiceLog InvokeMethod 4 0000265c64be0b8c:0 2023-08-10 09:03:13 Business Service 'EAI Query Spec Service' invoke method 'QuerySpecToSiebelMsg' Execute Time: 0.002 seconds.
ObjMgrBusServiceLog InvokeMethod 4 0000265c64be0b8c:0 2023-08-10 09:03:13 End: Business Service 'EAI Query Spec Service' invoke method: 'QuerySpecToSiebelMsg' at 25f2daa0

Step to reproduce the issue:

1. On Administration - Application > Predefined Queries > Click Query and select a "New Query" using the information below:

[Created] >= Timestamp()-28 AND [Private]="N"

2. Click Query and select "Save Query As" with the name(MyPDQTest).

3. On ADM Project Screen > Project Items > Deployment Filter.

4. Pick my PQD(MyPDQTest) and showing the information below.

[Admin Query List.Created] >= Timestamp () - 28 AND [Admin Query List.Private] = "N"

5. Click on "Validate Filter", I am getting the following error message above.

Changes

Cause

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