Home » Applications » Oracle Fusion Apps & E-Business Suite » Contract Approval Notification Completes with Error status
Contract Approval Notification Completes with Error status [message #219425] Wed, 14 February 2007 06:03
Rajkumar_mj
Messages: 18
Registered: July 2006
Location: Chenna
Junior Member
Guys

I have customized the Contract Approval workflow for our requirements. For this included PLsql document to display the HTML Table for Contract Lines and Sub lines.

And i call the plsql document procedure in this way.

wf_engine.setitemattrtext
(itemtype => itemtype,
itemkey => itemkey,
aname => 'LINE_TABLE',
avalue => 'PLSQL:okc_wf_k_approve.generate_contract_lines/'
|| l_contract_number
);

and tested the procedure

DECLARE
a VARCHAR2(100):='TSSG10078';
b VARCHAR2(100):='html';
c VARCHAR2(20000);
d VARCHAR2(100);
BEGIN
okc_wf_k_approve.generate_contract_lines (a,b,c,d);
DBMS_OUTPUT.PUT_LINE(d);
END;

Everything successful. But Contract worklfow is successful in sometimes and sometimes completed with error status with the following error.

Workflow Errors: OKCAUKAP, TSSG10078


Failed Activity Sign Contract please

Activity Type Notice

Error Name WF_ERROR

Error Message [WF_ERROR] ERROR_MESSAGE=3825: 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.OKC_WF_K_APPROVE" has been invalidated ORA-04065: not executed, altered or dropped package "APPS.OKC_WF_K_APPROVE" ORA-06508: PL/SQL: could not find program unit being called' encountered during execution of '' for event 'oracle.apps.wf.notification.send'. FUNCTION_NAME=WF_XML.Generate ERROR_STACK= Wf_Engine_Util.Function_Call(OKC_WF_K_APPROVE.SELECTOR, OKCAUKAP, TSSG10078, TEST_CTX) Wf_Engine_Util.Execute_Selector_Function(OKCAUKAP, TSSG10078, TEST_CTX) Wf_Engine_Util.Function_Call(OKC_WF_K_APPROVE.SELECTOR, OKCAUKAP, TSSG10078, TEST_CTX) Wf_Engine_Util.Execute_Selector_Function(OKCAUKAP, TSSG10078, TEST_CTX) Wf_Engine.CB(TESTCTX, OKCAUKAP:TSSG10078:85180, ::::) Wf_Engine.oldCB(TESTCTX, OKCAUKAP:TSSG10078:85180, ::::) WF_MAIL.SetContext(1572642) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 1572642) WF_XML.Generate(oracle.apps.wf.notification.send, 1572642) WF_XML.Generate(oracle.apps.wf.notification.send, 1572642) Wf_Event.setMessage(oracle.apps.wf.notification.send, 1572642, WF_XML.Generate) Wf_Event.dispatch_internal()



Need your advise and solution for this to fix.

Thanks in advance

Regards
Rajkumar
Previous Topic: Invoice Problem
Next Topic: GL
Goto Forum:
  


Current Time: Sun Dec 11 04:09:44 CST 2016

Total time taken to generate the page: 0.08893 seconds