My Oracle Support Banner

Error In CASE Statement On Report (Doc ID 2530305.1)

Last updated on MAY 06, 2019

Applies to:

Oracle CRM On Demand - Version 031CS to 031CS [Release 31]
Information in this document applies to any platform.

Goal

Trying to create a report where it would only show data where the Order/Book Days is in the next 7 days. There's been applied CASE statement on the field but its giving the following error.

Error : Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. Please have your System Administrator look at the log for more details on this error. (HY000)
[nQSError: 43113] Message returned from OBIS. Please have your System Administrator look at the log for more details on this error. (HY000)
[nQSError: 27007] Ambiguous column: "DATE_30". Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: SELECT CASE WHEN "DATE_30" > CURRENT_DATE AND "DATE_30" <= TIMESTAMPADD(SQL_TSI_DAY,7,CURRENT_DATE) THEN 'Next 7 Days' WHEN "DATE_30" > CURRENT_DATE AND "DATE_30" <= TIMESTAMPADD(SQL_TSI_DAY,30,CURRENT_DATE) THEN 'Next 30 Days' ELSE 'Beyond Specified Range' END FROM "Opportunity Lists"
OK (Ignore Error)
 

Solution

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
Goal
Solution


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