Interesting case.

You say it's getting stuck in the autocreate queue? Is there any error there? What is the status of the workflow item?


Regards,

Arian

Since it only happens from the HR-notifications, it seems as if the session information gets messed up.
You verified from the status monitor that there is no CREATEPO workflow? Or through the wf_ITEMS table?

I think you'll have to debug the workflow. You can enable the profile option: PO: Set Debug Workflow ON. This will start writing messages to the po_wf_debug table. Hopefully that will give a clue, where it goes wrong.

Regards,

Arian

.10: group_req_lines : c1_req_line_id = 964600 c2_req_line_id = 964600

.60: group_req_lines: result = ACTIVITY_PERFORMED

Hi,

so it fails at the grouping. That means that either there was no group_id. Or there is no data in the temp table.

Does de debug info have a line that says:

10:insert_cand_req_lines_into_tbl: inserting into temp table for req line = ......

And can you see if a group_id was created for both workflows:

select item_type, item_key, name, number_value
from wf_item_attribute_values
where item_type='CREATEPO'
and item_key = '&item_key'
and name='GROUP_ID';

Row#	ITEM_TYPE	ITEM_KEY	NAME	NUMBER_VALUE

1	CREATEPO	852244-871007	GROUP_ID	458096
2	CREATEPO	852245-871011	GROUP_ID	458097

Hi,

sorry for the late reply. I was down with a flu. But up and running again

Something that came to mind, was the hr_locations view. Do you use multiple Business Groups, or does the deliver-to location have a business group in hr_locations_all?

Regards,

Arian

Hi,

Well, at least we both got it over with. Hope it's the only flu for this year.

Ok. That makes sense then. So the HR responsibility can't see the buyer. Is there a possibility to include the buyer in the security profile?

Regards,

Arian

Hey,

busy times for all of us.
I was looking at the HR security profiles. The doco says that the custom security profile will be inserted into a query on PERSON and ASSIGNMENT. As in:

SELECT PERSON.person_id
FROM per_all_people_f PERSON,
     per_all_assignments_f ASSIGNMENT
WHERE PERSON.person_id=ASSIGNMENT.person_id
AND {your custom where clause fragment goes here}

In that case, you can add a person by including something like 1=1 or employee_number=xxxx. But I have a bad feeling that the code is a little more complex.
Once upon a time, I customized the security profiles for 11i HR. The docs on that customization would probably be helpful. I just need to find them again. Aaaaarrrrgggghhhhhhhh..........

Anyway, I'll look for them, and let you know.

Regards,

Arian