FRM-50011 Not A Valid Month Name Error When Attaching Documents From Document Catalog (Doc ID 561090.1)

Last updated on JUNE 21, 2016

Applies to:

Oracle Application Object Library - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Your are using Oracle applications release 12.0.3 and you are receiving an error  "FRM-50011: Not a valid month name" when trying to attach documents from document catalog on purchase order entry screen in forms.

You are receiving this error when the date format set in user's preferences  MM/dd/yyy (02/27/2008).
If you change the date format into dd_mmm_yyyy then it is working fine.

Since the database is running Oracle 10 you check that ORA_NLS10 is correctly set when starting the instance.

The following is visible when reproducing the error with FRD trace active.

'...
Executing NAME_IN Built-in:
In Argument 0 - Type: String   Value: GLOBAL.FND_FLEX_FNDSQF_DEBUG
Out Argument 0 - Type: String   Value: OFF
FNDATTCH, 31, Prog Unit, Exit, -843248248, /FNDATTCH-7/P61_26_DEC_200722_14_17
   
FNDATTCH, 30, Trigger, Exit, -842407248, WHEN-VALIDATE-ITEM
    
    
Error Message: FRM-50011: Not a valid month name.
   
ON-ERROR Trigger Fired:
Form: FNDATTCH
    
State Delta:
FNDATTCH, 30, Trigger, Entry, -841351248, ON-ERROR
    
FNDATTCH, 31, Prog Unit, Entry, -840749248, /FNDATTCH-7/P48_26_DEC_200722_14_17
...'

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