My Oracle Support Banner

E1: ORCH: Orchestration Dates Are Off By One Day (Doc ID 2816144.1)

Last updated on MARCH 22, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


When running an Orchestration, the values in the Date fields returned are incorrect. All of the dates are off by one day. For example Sales Order 270251 it's Order Date = 28/07/2021, however the value returned in the Orchestration is 27/07/2021. The same applied to the Schedule Pick Date and Request Date.

JSON Response show the dates are off by one day:

All the servers (HTML, DB, AIS) have the same timezone and daylight saving time setup.
Changing the user profile settings in P0092 from blank Universal Time and Daylight Savings Rule to same as the servers did not help.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.