[oracleerp] Re: Problem with iExpense Workflow(APEXP)
- From: "Rakesh Singh" <rakesh.singh@xxxxxxxxxxxxx>
- To: <oracleerp@xxxxxxxxxxxxx>, <oracleerp@xxxxxxxxxxxxx>
- Date: Tue, 28 Aug 2007 01:51:26 +0530
Hi,
The below solution has been implemented and has resolved the issue.
Thanks,
Rakesh Singh
________________________________
From: oracleerp-bounce@xxxxxxxxxxxxx on behalf of Rakesh Chathli
Sent: Mon 8/27/2007 9:26 AM
To: oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] Re: Problem with iExpense Workflow(APEXP)
Rakesh Singh............. Thanks for your help on this.
Rohit ............ please update the forum with the results after doing what
Rakesh suggests here for the benefit of all.
Regards
Rakesh
________________________________
From: oracleerp-bounce@xxxxxxxxxxxxx [mailto:oracleerp-bounce@xxxxxxxxxxxxx] On
Behalf Of Rakesh Singh
Sent: Saturday, August 25, 2007 11:49 AM
To: oracleerp@xxxxxxxxxxxxx; oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] Re: Problem with iExpense Workflow(APEXP)
Hello All,
This particular issue with workflow happens when the workflow related packages
become invalid. The solution to this is compile the invalid objects. But only
compiling the objects is not going to solve the problem. The new compiled code
is not yet called as the old code still reamains in the sharedpool. To stop the
workflow system to read the old version of package stored in the memory, please
follow the below steps.
1. Bring down the concurrent managers, forms server, apache server, etc....on
the middle tier using adstpall.sh script
2. Enter adadmin and Recompile the APPS schema - take note of invalid objects
prior and then thereafter to ensure no new invalid objects are created.
3. Bring up the instance and ensure the notification mailer is bounced
completely when restarting the instance
Thanks,
Rakesh Singh
________________________________
From: oracleerp-bounce@xxxxxxxxxxxxx on behalf of Rohit Nanda
Sent: Wed 8/22/2007 10:41 AM
To: oracleerp@xxxxxxxxxxxxx
Subject: [oracleerp] Re: Problem with iExpense Workflow(APEXP)
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
******************************************************************************************************************************
"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."
************************************************************************************************************************************************************************
******************************************************************************************************************************
"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:
