| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
