Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to filter Scheduled Ship Date based on Pacific Time Zone (PST/PDT) in OTBI Reports.
I have an OTBI report that retrieves a list of orders with missed scheduled ship dates. The filtering criteria for the report is set as "Fulfillment Lines - Scheduling Details"."Schedule Ship Date Fline" < (current_date), and it's filtering based on the UTC timezone.
Is there a way to modify this report to filter results based on the specified criteria but in Pacific Time (PDT/PST) instead of UTC?
Answers
-
Hi Dharma
Database timezone in UTC hence data is filtering in UTC format.
Database timezone cannot be changed.
Thanks & Regards
Rajasekhar
0 -
Hi Dharma
Database timezone in UTC hence data is filtering in UTC format.
Database timezone cannot be changed.
Thanks & Regards
Rajasekhar
0 -
Hi Dharma
Database timezone in UTC hence data is filtering in UTC format.
Database timezone cannot be changed.
Thanks & Regards
Rajasekhar
0