Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Legal Entity Timezone Setup as Eastern (EST) Since the transaction data are stored in UTC in Databas

edited Oct 14, 2021 1:43AM in Costing 4 comments

Summary: Legal Entity Timezone Setup as Eastern (EST) Since the transaction data are stored in UTC in Oracle ERP Cloud Database


Content (required): We have the PO's and Receipt entered after 8.00 PM EST on the last day of the month, they are getting stored after 12.00 PM on the next day of the month

Example:-

PO/Receipt entered after 8.30 PM EST in Oracle is storing the transaction in database with UTC timezone (12.30 AM UTC time). Due to this, when the AP period end accrual (Accrue at = Period End)process is run by the user, the accrual for the PO receipt entered after 8.00 PM EST wasn't considered because it was stored in database at 12.30 AM UTC time.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!