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
Abhradeep Haldar Ext
Abhradeep Haldar Ext 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

Answers