Hi Guys,

Quick question as have been pulling my Hair out about this one!!

I have written a Procedure to utilise the API: hr_perf_review_api.create_perf_review.

This works great when I do not try to add in data to the DFF. I have enabled Attribute2 to hold some comments. However, everytime I call my Proc with text to be stored into Attribute2, I get the error:

ORA-20001: A value has been provided for a non-enabled or non-existent descriptive flexfield segment.
ORA-06512: at "APPS.HR_PERF_REVIEW_API", line 526
ORA-06512: at "APPS.VBAP_PERF_REVIEW_UPLOAD", line 109
ORA-06512: at line 2

I know this is probably something VERY simple that I have missed, but any hints would be great!!!

Here is the API Call that I am using:

hr_perf_review_api.create_perf_review
(
p_validate => FALSE,
p_performance_review_id => ln_performance_review_id,
p_person_id => ln_person_id,
p_performance_rating => p_rating,
p_review_date => p_effective_date,
p_attribute_category => 'Global Data Elements',
p_attribute2 => p_comments,
p_object_version_number => ln_object_version_num,
p_next_review_date_warning => lb_date_warning
);

Thank you for any help!!
Gav

Gav

Try making p_attribute_category => NULL...

Good shout... Will test it again in the morning. Sure it didn't work out previously, but well worth a try!

Cheers Clive!

Gav
That might be a red herring, as I have just tried a test on a (different) API here with and without p_attribute_category => 'Global Data Elements' and they both work.

So I would therefore ask the following :
1. Is attribute2 available to Global Data Elements context? ie not used on some specific context
2. Is the DFF compiled etc
3. Is the segment enabled?
4. Can you enter the same info via the screen?
(with due apologies if you have already checked all this)

Hay Clive,

Just tried again this AM and bag all working... Hmm. I wonder if (and this is not too big a supprise!) I was executing my code in Dev1 when Logged into Dev2...

I said it would be simple!

Thank you for the help, and sorry for being an idiot! ;o)

Gavin

No apologies needed mate, so long as you're off and running now. I think we need more idiots on here anyway : what you did there is not so bad, we've all done that - I once waited 20 mins for a SQL query to do something, only to realised I'd copied it in a Notepad window by mistake! Now that is the hallmark of a card-carrying idiot!