Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF): ORA-20001: FLEX-NULL REQUIRED SEGMENT: N, SEGMENT_NAME, 'XX_SEGMENT_NAME' while creating Employee Contact hr_contact_rel_api.create

Tuesday, November 2, 2021

ORA-20001: FLEX-NULL REQUIRED SEGMENT: N, SEGMENT_NAME, 'XX_SEGMENT_NAME' while creating Employee Contact hr_contact_rel_api.create_contact

While creating relationship type contact for employee using hr_contact_rel_api.create_contact API, getting "ORA-20001: FLEX-NULL REQUIRED SEGMENT: N, SEGMENT_NAME, 'XX_SEGMENT_NAME'" error. When you face such error please validate "Further Contact R'ship Info" flex field has any mandatory values as shown in below screenshot.