Register to the Data Intelligence Summit Mexico City Register today to the Oracle Analytics Data Intelligence Summit in Mexico City on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Welcome to the Oracle Analytics Community

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

Comments

Thanks YG. I think it because BIP is converting the date back to UTC. If I put to_char, both queries work. Thanks. SELECT TO_CHAR( FROM_TZ(CREATION_DATE, DBTIMEZONE) at time zone 'Australia/Sydney' ,'DD-MON-YYYY HH24:MI:SSxFF TZH:TZM') cr_dat_tz, CREATION_DATE creation_date FROM ap_invoices_all SELECT…

in Convert UTC to Local Time in Oracle BI Publisher Comment by Tiger Liu-55147 April 2018
Bursting is enabled for the DM using Account Analysis Report by CC layout 2 layouts Bursting enabled for the report: Run the job, but choose original layout and output to Excel Job still split and separate PDFs were sent to the users

in Report Bursting Comment by Tiger Liu-55147 May 2017