Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

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

Comments

Hi @Venkat Thota - BIP- I have requirement to pull first Sunday of every month, trying below query but its not working as expected, can you help ? SELECT NEXT_DAY(TRUNC(SYSDATE,'MM') - 1,TO_CHAR(DATE '2025-04-15','DAY')) ,NEXT_DAY(TRUNC(SYSDATE,'MM') - 1,TO_CHAR(DATE '2025-04-15','DAY')) + 7 Next_Sunday FROM dual

in Cannot use NEXT_DAY function in Fusion BI Publisher Data model Comment by Manish_Chauhan Apr 15, 2025 12:28PM
Hi @Abhradeep Haldar Ext- I have a similar requirement, can you tell how did you fix this query ? SELECT TRUNC (NEXT_DAY (TRUNC (SYSDATE, 'IW'), 'SATURDAY')) FROM DUAL

in Cannot use NEXT_DAY function in Fusion BI Publisher Data model Comment by Manish_Chauhan Apr 15, 2025 12:25PM