My Oracle Support Banner

Can't Submit Close Discrete Jobs Program When Using Non-Default Date Format Mask (Doc ID 2246187.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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


Problem Statement
If user set profile option ICX: Date Format Mask to something other than the default "31-DEC-1999", when trying to submit Close Discrete Jobs with a From Job Start Date field entered, below error will pop up and preventing the submission of the program.

Please enter date value 01-JAN-99 in correct format: MM/DD/RRRR

Steps to Reproduce

  1. Change profile "ICX: Date Format Mask" to "12/31/1999" for current user, save, log out then log back in.
  2. Go to Submit Request form, pick Close Discrete Jobs program
  3. In the parameters dialog, enter "08/21/2014" for From Job Start Date, observe the To Job Start Date is automatically populated as "21-AUG-2014", which is in incorrect format.
  4. Manually correct To Job Start Date from "21-AUG-14" to "08/21/2014", click OK.
  5. Click Submit button, observe an error dialog pops up with message: "Please enter date value 21-AUG-14 in correct format: MM/DD/RRRR." even though there is no "21-AUG-14" in our input


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.