Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Change the SalesOrder report's RequestShipDate format of the seeded XML to a timestamp format
Mikee Tamonan
Rank 1 - Community Starter
The Requested Date in the Sales Order report within Order Management does not align with the date displayed in Fusion. This discrepancy occurs because the report uses the UTC time zone, while the UI adjusts dates based on the user’s time zone preferences.
To ensure the report output matches the UI, the time zone needs to be accounted for in the report logic. Specifically, the RequestShipDate field in the seeded data model should include a timestamp format. This would allow query-level adjustments (e.g., time zone conversion) so that the reported dates align correctly with the user’s local time zone.
Tagged:
6