3752007 - Error 'Locale ID does not have all the required default date and number formats'

User Connector SF is failing with the following error:

        Error: Locale ID does not have all the required default date and number formats. French 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

SAP SuccessFactors Learning

1. Prepare a User Connector input file where DEFAULT_LOCALE is set to fr_FR.
2. Goto Learning Administration
3. User Connector SF and Run the User connector.
4. Observe the error: "Locale ID does not have all the required default date and number formats. French"

The Connector validates locale by Internal Locale ID, not by the language tag (for example, fr_FR). Using fr_FR prevents the connector from finding the locale, resulting in the error.

1] Identify the Internal Locale ID for the required language in Learning Administration 

• By opening the Locales entity and checking the Summary tab (for example, the Internal Locale ID for French is “French”).

2] Update the connector input DEFAULT_LOCALE as “French” instead of fr_FR.

3] Re-run the connector and verify that the error no longer occurs.

Note: This behavior is by design. Learning Management System(LMS) DataBase for the locales and their settings is storing the Internal Locale ID and NOT the Active Locale ID. Therefore, as the Help portal also says, Internal Locale ID is the value that should be used for all non-UI data creation/change action, including data import, connectors and API. This cannot be changed:

SAP SuccessFactors Learning Locales Summary

KBA 2625983 - Locale cannot be used

locale id error, default date and number formats, fr_FR, internal locale id, french, connectors, user connector, DEFAULT_LOCALE, locale mapping, import error, learning, lms connector, by design, active locale id, locale patterns,Internal Locale ID  , KBA , LOD-SF-LMS-CON , Connectors , Problem