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