Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Cannot use NEXT_DAY function in Fusion BI Publisher Data model

Received Response
107
Views
7
Comments
Rank 2 - Community Beginner
edited Apr 15, 2025 12:28PM in Oracle Analytics Publisher

Summary

Cannot use NEXT_DAY function in Fusion BI Publisher Data model

Content

Hi All,

I am trying to run the below query to get the next Saturday in a BI Publisher Data model.

SELECT TRUNC (NEXT_DAY (TRUNC (SYSDATE, 'IW'), 'SATURDAY')) FROM DUAL

However it keeps giving me the below error.

oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLDataException: ORA-01846: not a valid day of the week

Is there a technical limitation here? The query in question works perfectly when I run it in SQL Developer.

How do I calculate the next SATURDAY from today in BI Publisher.

Regards,

Abhradeep

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.