I'm trying to use the HR_POSITION_API.create_position API to mass load a number of new positions. I've created a custom wrapper to do look ups for a number of fields and got this working.

The problem comes when I try to add a value to one of the key flex segments in PER_POSITION_DEFINITIONS, I get the following error
ORA-20001: FLEX-DSQL EXCEPTION:
ORA-06512: at "APPS.HR_POSITION_API", line 2978
ORA-06512: at "APPS.CCC_WEB_ADI", line 315

I'm asuming this is because the segment has a value set validation of 'Table', where as the other segments which are working have 'Independant'

Does anybody know how I resolve this issue? I've checked oracle's metalink and been searching forums for hours but can not find anything.

Help please