My Oracle Support Banner

Close Discrete Jobs Fails With Close Date Must Be Less Than or Equal (Doc ID 2264703.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to run close discrete jobs program from shell with entering "date '+%Y/%m/%d %T'" (AP server system date) to actual close date, the following error occurs very rarely.

Close date must be less than or equal to xx-xx-xx.

We do not set profile Enable Timezone Conversions to 'Y'. Also, in our environment, the system date of AP server and DB server are always synchronized.

Why did the issue occur rarely?


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.