My Oracle Support Banner

FRM-40212 Invalid Value For Field User_Name When Trying to add User Name to Resource Record (Doc ID 2378101.1)

Last updated on DECEMBER 19, 2022

Applies to:

Oracle Common Applications - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Production, Define Resources Form

When trying to add a user_name to a resource in the Define Resources form (JTFRSDEF), we are getting an error message.


ERROR

FRM-40212: Invalid Value for Field User_Name


STEPS

The issue can be reproduced at will with the following steps:
1. Navigate to CRM Resource Manager > Maintain Resources > Resources
2. Query for user 'xxxxx '
3. In the 'User Name' field, we try to input the User name  (which exists in fnd_user table), we receive an error message that it is invalid value
  If we try to invoke the LOV [...], it gives a message that the LOV has no values


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.