[oracleerp] Re: Problem with iExpense Workflow(APEXP)
- From: "Rohit Nanda" <rnanda@xxxxxxxxxxx>
- To: <oracleerp@xxxxxxxxxxxxx>
- Date: Wed, 22 Aug 2007 10:41:51 +0530
Hi Basa,
Thanks for the reply.
I have tried updating the email address in WF tables using the frontend
also by following below written steps instead of the direct update to
the table but the result is still the same.
Steps to update the email address in WF tables through frontend:
1. Update the email address on the employee(people) screen
2. Map the employee with the user on the System Administrator ->
User Form
3. Previously entered email address will be populated automatically
against the user/employee.
4. Save and it will automatically reflect in WF tables.
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
________________________________
From: oracleerp-bounce@xxxxxxxxxxxxx
[mailto:oracleerp-bounce@xxxxxxxxxxxxx] On Behalf Of Basavaraju Gangraju
Sent: Wednesday, August 22, 2007 10:29 AM
To: oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] Re: Problem with iExpense Workflow(APEXP)
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
Other related posts:
