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." ************************************************************************************************************************************************************************