72 ORA-20001: HR_FLEX_VALUE_MISSING: N, COLUMN, SEGMENT3, N, PROMPT, GOSI Annuities

While loading the HR employees for Saudi region or while updating the HR employees, there is a possibility for this error.

If the below API is used for updating the employee details, there is a soft coded KFF. Search in the KFF screen with %Soft% and check the mapping for "GOSI Annunities".

HR_ASSIGNMENT_API.UPDATE_EMP_ASG

Add the P_SEGMENT3 in the parameter, example is shown as below.

         HR_ASSIGNMENT_API.UPDATE_EMP_ASG
                                (p_effective_date              => l_effective_date
                                ,p_datetrack_update_mode       => 'CORRECTION',
                                p_assignment_id               => i.assignment_id  ,
                                p_object_version_number       => l_asg_ovn,
                P_SEGMENT1 => 201,
                P_SEGMENT3 => i.people_group_value,-- GOSI Annunities
                P_SEGMENT5 => i.people_group_value,-- GOSI hazards
                                p_comment_id                  => ln_EMP_comment_id,
                                p_soft_coding_keyflex_id      => ln_EMP_soft_coding_keyflex_id,
                                p_effective_start_date        => ln_EMP_effective_start_date,
                                p_effective_end_date          => ln_EMP_effective_end_date,
                                p_concatenated_segments       => ln_EMP_conc_segments,
                                p_no_managers_warning         => ln_EMP_no_managers_warning,
                                p_other_manager_warning       => ln_EMP_other_manager_warning
                                );



I have used this and worked for me.