E-SQR: SFS2001, SFS2003 SFS2004 SQR's Are Failing With Error "(SQR 1921) Bad date mask starting at: '_AM'." (Doc ID 2287092.1)

Last updated on JULY 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the delivered SQR Reports SFS2001, SFS2003 and SFS2004, the following error occurs.

Error
-------
"(SQR 1921) Bad date mask starting at: '_AM'."


Steps
--------
The issue can be reproduced at will with the following steps:
1. Login to PIA with French language
2. Navigate to Contrôle de la Production > Définir production > Ordres/programmes fabrication > Gestion ordres de fabrication
3. Create a new PID, and fill it with those data
4. The new order was created:
Entité: FRA01
Type production: Prdn
Ordre fabrication: PRD00236
5. Navigate to Contrôle de la production > Clore & analyser production > Etat ruptures


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