Not able to create more than one time card elements through HDL load.
Summary:
Not able to create more than one time card elements through HDL load.
Content (required):
I am trying to load time card elements via HDL. When there are more than one elements in the file only one element gets created, other fails with below error:
JBO-26048: Constraint "PAY_GI_MAPPINGS_U1" is violated during post operation "Insert" using SQL statement "INSERT INTO PAY_GI_MAPPINGS(MAPPING_ID,PRIMARY_ENTITY_ID,SECONDARY_ENTITY_ID,ENTITY_TYPE,ENTERPRISE_ID,MODULE_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11)".
Note: Load goes through for all elements. Only one element gets created successfully, all other go in failed status with the given error.