Hi, I know this is an old one but couldn't find anything more recent.

I'm having the same problem trying input a value for a position key flex using the create position API. The segment has a validation type of table and returns an error when I try to pass a value via the API

Is there now a way round the table validation?

Hi Mr Corbon262, and welcome to the forum.

Can I ask, are you able to reproduce the details of the validation 'where' clause here? I take it that the values that you would load, are valid when entered via the form?

Could be you need a wrapper around the API, that first sets up the appropriate session info; then register that with DP.

Here's the where clause from the apps
"WHERE business_group_id = :$PROFILES$.per_business_group_id
AND internal_external_flag = 'INT'
AND (date_to is null OR date_to > sysdate)
ORDER BY name"

I'm using a wrapper with the following look up for organization_id

CURSOR Get_segment11_org IS
SELECT organization_id
FROM HR_ALL_ORGANIZATION_UNITS
WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND internal_external_flag = 'INT'
AND UPPER(name) = UPPER(l_org_name)
AND (date_to is null OR date_to > l_start_date)

but no joy

OK, just out of interest what's the error message that you're getting back from the API call?

I still think it's to do with the interpretation of that :$PROFILES$ thing... Just humour me for a minute, and try doing some sort of apps_initialise at the start of your wrapper script, e.g.

FND_GLOBAL.apps_initialise (user, responsibility etc);

Just one other thing: what's the rest of the definition of the valueset? Do you, for instance, have something in the 'ID column' such as ORGANIZATION_ID?

Cheers for the welcome

I added the FND_GLOBAL.APPS_INITIALIZE(-1, 53826, 800) and it all works a treat.

I can't thank you enough for this, I've been chasing my tail with this for days.

I guess you don't ask you don't get

Again thank you

No worries Mr Corbon262, delighted to have been able to help - I guess that's what forums like this are all about!