2381010 - Connector rejecting records with error : ORA-02291: integrity constraint FK_USR_PRF_DTE__ALOC_DTE_PTRN violated - parent key not found

When trying to run the user connector, the connector fails with error :

ORA-02291: integrity

constraint (CUSTOMER_STAGE/PROD_TMS.FK_USR_PRF_DTE__ALOC_DTE_PTRN) violated -

parent key not found

SuccessFactors Learning

Learning Management System

Run the user connector in LMS, the rcords will be rejected with ORA-02291 error

No date format added for the locale for that user

• Login as admin
• Navigate to System Admin>Connectors>User Connector/USer Connector - SF
• Click on View results to identify the records rejected by the connector.
• Click on 'Show archived input files' and download the feed file.From the feed file, check the locale for the user which is being rejected by the connector.
• Check the locale (References>Geography>Locales) in that instance, there will be no date format added to the locale as seen in below screenshot.This is the reason for this failure.Please add a date format for the locale and save the changes.This should solve the issue.

ALOC_DTE_PTRN,rejecting user recors,connector,locale,preferences , KBA , LOD-SF-LMS , Learning Management System , Problem

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611 ; SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SuccessFactors Learning 1207 ; SuccessFactors Learning 1210 ; SuccessFactors Learning 1302 ; SuccessFactors Learning 1305 ; SuccessFactors Learning 1308 ; SuccessFactors Learning 1311 ; SuccessFactors Learning 1402 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408 ; SuccessFactors Learning 1411 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508