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

Last updated on MAY 16, 2017

Applies to:

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

Goal

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?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms