Trying to Enter Data in the Date Drawn From Field on Find Samples Gives Date Format Error Message: FRM-50025: Date/time must be entered in a format like DD-MON-RRRR HH24:MI:SS (Doc ID 1950429.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Quality Management Samples

The Date Drawn From field on the Find Samples form does not respect the date format specified on Preferences on the EBS home page. If you select a date format other than DD-MON-RRRR, when you try to enter a date (or select a date from the LOV), you get the error:

FRM-50025: Date/time must be entered in a format like DD-MON-RRRR HH24:MI:SS

The problem occurs whether you do a Find on Item Samples, Monitoring Samples, or for a sample on the Quality Workbench.

Other forms, such as Create Batch, correctly accept the date format that was set on Preferences.

ERROR
-----------------------
FRM-50025: Date/time must be entered in a format like DD-MON-RRRR HH24:MI:SS


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On EBS home page Preferences (from the page that displays after entering username and password and from which you choose a responsibility, click on Preferences), select a different time format, yyyy/MM/dd (2014/11/12)
2. Log in and open Item Samples screen, click Find, select date from LOV for Date Drawn From field, get error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot query samples based on date.

Cause

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