URGENT URGENT Completeactivity and defer functions
Ranjit Singh Gill
We are facing two major problems, and they need to be resolved
immediately.
Problem1: We are using the wf_standard_defer function. Once the order
gets submitted thru istore, Wf background engine pick it up, but the
order gets stuck at the wf_standard_defer function. The only way to
work around that is to click on the expedite button and choose the
'Retry' Option. Once we do that, then the order moves along fine. The
concurrent job is running with the min set to 1, max set to 1000,
deferred set to yes and notif... set to yes. How do we fix this
problem?
Problem2: We also have an external function that calls the
completeactivity function of work flow to release the hold. But when we
do that, it errors out. After looking at wf_item_activity_statuses
table, I see the following error messages:
ErrorName:WFSQL_INTERNAL
ErrorMessage: 3002: Internal: Unexpected error. ITEMTYPE=OEOH
ITEMKEY=1501 CHILDPROCESS=28771 FUNCTION=Activity_Parent_Process
ActivityResultCode: #EXCEPTION
Errorstack:
Wf_Engine_Util.Activity_Parent_Process(28771)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28771, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28765, AUTHORIZATION
DECLINED)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28765, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28765, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28781, N)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28781, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28781, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28755, COMPLETE)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28755, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28755, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28763, Y)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28763, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28763, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28757, PENDING
AUTHORIZATION)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28757, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28757, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28761, #NULL)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28761, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28761, 50)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28809, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28810, CPP_NO_REAPPROVAL)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28789, #NULL)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28789, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28789, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28783, N)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28783, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28783, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28793, N)
Wf_Engine_Util.Execute_Activity(OEOH, 1501, 28793, RUN)
Wf_Engine_Util.Process_Activity(OEOH, 1501, 28793, 50)
Wf_Engine_Util.Complete_Activity(OEOH, 1501, 28797)
Wf_Engine.HandleError(OEOH, 1501,
CPP_MERCHANT_REVIEW:HOLD_FOR_MERCHANT_REVIEW, SKIP).
--
Regards,
Ranjit Gill
Oracle Corporation
Senior Consultant
301-529-6831
mark.craig
Problem 1
When you defer the workflow, did you change the activity cost? Before
running the Background Engine, run the wfbkgchk.sql admin scrip
($FND_TOP/admin/sql) to confirm that your work item is on the deferred
queue. Then run background engine from SQL*Plus as follows:
wf_engine.background(itemtype=>'<your item type>'), and rerun the
wfbkgchk.sql. If you still have problems, go through support/get a bug
logged if they agree.
Problem 2:
On the face of it looks like a problem in the workflow code, but I see the
error is related to the OEOH itemtype - is it possible you are trying to
complete a Header level(master) workflow when there are still Line
level(detail) workflows that are not yet complete? Again, based on your
urgency, you should go through support.
Cheers
Mark
Ranjit Singh Gill <ranji...@oracle.com> wrote in message
news:3A6FAB49...@oracle.com...