[oracleerp] Re: Problem with iExpense Workflow(APEXP)

  • From: "Basavaraju Gangraju" <basavaraju.gangraju@xxxxxxxxxxxxx>
  • To: <oracleerp@xxxxxxxxxxxxx>
  • Date: Wed, 22 Aug 2007 10:28:33 +0530

Rohit,

After entering the email in the mentioned tabe, check if any concurrent
program needs to be run.

Basa

Work - 91-44-39112000 Ext 2032

Mobile - +91 988 499 3883

 

 

________________________________

From: oracleerp-bounce@xxxxxxxxxxxxx
[mailto:oracleerp-bounce@xxxxxxxxxxxxx] On Behalf Of Rakesh Chathli
Sent: Wednesday, August 22, 2007 9:31 AM
To: oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] Re: Problem with iExpense Workflow(APEXP)

 

Hey Guys

 

We need iExpense / Workflow Gurus to please help Rohit out on this. 

 

Regards

Rakesh

 

 

 

________________________________

From: oracleerp-bounce@xxxxxxxxxxxxx
[mailto:oracleerp-bounce@xxxxxxxxxxxxx] On Behalf Of Rohit Nanda
Sent: Tuesday, August 21, 2007 4:33 PM
To: oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] Problem with iExpense Workflow(APEXP)

 

Dear all,

 

I m Rohit Nanda, working with Juniper Oracle Apps Development Team -
Noida -III. I am facing an issue with iExpense Workflow.

 

Steps to reproduce the problems:-

 

1. Login and navigate to the iExpense Responsibility.

2. Create and submit an expense report.

3. Expense report goes to Manager for approval.

4. Manager is getting the notification to approve the expense report.

 

Problem Area: Manager is not getting the email against the notification
to approve the expense report as the working is throwing below pasted
error while sending email(Screenshots attached).

 

[WF_ERROR] ERROR_MESSAGE=3835: Error '-4061 - ORA-04061: existing state
of has been invalidated ORA-04061: existing state of has been
invalidated ORA-04061: existing state of package
"APPS.AP_WEB_EXPENSE_WF" has been invalidated ORA-04065: not executed,
altered or dropped package "APPS.AP_WEB_EXPENSE_WF" ORA-06508: PL/SQL:
could not find program unit being called' encountered during execution
of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'. ERROR_STACK=
Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.CALLBACKFUNCTION, APEXP,
166911, TEST_CTX) Wf_Engine_Util.Execute_Selector_Function(APEXP,
166911, TEST_CTX)
Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.CALLBACKFUNCTION, APEXP,
166911, TEST_CTX) Wf_Engine_Util.Execute_Selector_Function(APEXP,
166911, TEST_CTX) Wf_Engine.CB(TESTCTX, APEXP:166911:148930, ::::)
Wf_Engine.oldCB(TESTCTX, APEXP:166911:148930, ::::)
WF_MAIL.SetContext(1063936)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 1063936)
WF_XML.Generate(oracle.apps.wf.notification.send, 1063936)
WF_XML.Generate(oracle.apps.wf.notification.send, 1063936)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 1063936,
WF_XML.Generate) Wf_Event.dispatch_internal()

 

The error is talking about APPS.AP_WEB_EXPENSE_WF package being in
invalid state but the package is in valid state.

 

If I remove email address from WF_LOCAL_USERS table then workflow works
fine without sending email to the manager. But it errors out when the
email address is there in the table and the workflow tries to send the
email.

 

Please let me know if anybody has ever faced this kind of error and help
me out.

 

Regards

Rohit Nanda

Sr. Software Engineer

ESG (Enterprise Solutions Group) - Birlasoft

Cell: +91 9811414543 | Tel: +91 (120) 6629000 Ext. 9337 | IPLC: 4253

An SEI CMMI Level 5 on Continuous Representation and ISO 9001:2000
Company

************************************************************************
******************************************************
"This message and any attachments are solely for the intended recipient
and may contain Birlasoft confidential or privileged information. If you
are not the intended recipient,any disclosure,copying, use, or
distribution of the information included in this message and any
attachments is 
prohibited. If you have received this communication in error, please
notify us by reply e-mail(administrator@xxxxxxxxxxxxx) immediately and
permanently delete this message and any attachments. Thank you."
************************************************************************
************************************************************************
************************
******************************************************************************************************************************
"This message and any attachments are solely for the intended recipient and may 
contain Birlasoft confidential or privileged information. If you are not the 
intended recipient,any disclosure,copying, use, or distribution of the 
information included in this message and any attachments is 
prohibited. If you have received this communication in error, please notify us 
by reply e-mail(administrator@xxxxxxxxxxxxx) immediately and permanently delete 
this message and any attachments. Thank you."
************************************************************************************************************************************************************************

Other related posts: