Oracle Transactional Business Intelligence

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

How do you convert UTC time to EST for transaction reporting

Received Response
671
Views
1
Comments

Summary:


Content (required):

We are experiencing having issues with Oracle time zones defaulting to UTC vs EST for transaction reporting. Our client business operations are held in EST for transaction reports, however when transactions are processed to the Oracle base tables they are being converted to UTC. For example, if a receipt is processed on 11/30/2022 at 10:30 PM EST, when accounted its being accounted for 12/1/2022 and falls under December accounting vs November since the base table is converted to UTC. 

Is there a process of changing the UTC time zone to EST in the base tables in order to accurately reflect the correct time zone transactions are being posted? 

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Answers

  • Timezone at the Table/DB level cannot be changed, however, you can convert the time back to a timezone of your choosing in BI.

    Have a look at these documents : BI Publisher - Fusion Apps - Working with Time Zones in Oracle Business Intelligence Publisher (Doc ID 1910385.1)

    How To Set Date As Per User Preference Time zone in Fusion Applications BI Publisher Report (Doc ID 2864734.1)