Receiving error when trying to create a scheduled offering through scheduled offering connector
SuccessFactors Learning Management System - Scheduled Offering Connector
Reproducing the Issue
1. Prepare the Scheduled Offering Connector feed file.
2. Place it in the SFTP
3. Schedule the schedule offering connector.
4. Receiving the error in the connector log, as "Error Creating Scheduled Offering; ORA-02291: integrity constraint violated - parent key not found".
The reason for the error is, custom column number 99(Legacy ID)was not created which was causing the connector to fail.
Create Custom Column 99(Label as "Legacy ID" & un-referenced), under LMS Admin > System Admin > Custom Column > Scheduled Offering and then run the connector which will resolve the issue.
Please note that the Custom Column 99 is used as an unique identifier for the scheduled offering and it is mandatory. It means that if you use the same value for this custom column twice, LMS will understand that you are trying to update an existing scheduled offering.
A best practice would be to use the Scheduled Offering ID on this custom column. If you are updating a Scheduled Offering, you should check its custom column 99 to match, otherwise it will create a new scheduled offering.
Error Creating Scheduled Offering SQLIntegrityConstraintViolationException ORA-02291 integrity constraint violated - parent key not found Custom Column 99 COL_NUM_99 , KBA , LOD-SF-LMS-CON , Connectors , Problem