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
Attachment:
Screenshot1.JPG
Description: Screenshot1.JPG
Attachment:
Screenshot2.JPG
Description: Screenshot2.JPG