This discussion is archived
2 Replies Latest reply: Jul 18, 2013 10:17 AM by Hussein Sawwan-Oracle RSS

PO workflow error "ORA-06502: PL/SQL: numeric or value error

sokar Newbie
Currently Being Moderated

Hi Guys ,


MAIL_STATUS column of the WF_NOTIFICATIONS set to ERROR



SQL>select ERROR_MESSAGE from wf_item_activity_statuses_v WHERE NOTIFICATION_ID = 1320203



 

 

ERROR_MESSAGE                                                                  

--------------------------------------------------------------------------------

[WF_ERROR] ERROR_MESSAGE=3835: Error '-6502 - ORA-06502: PL/SQL: numeric or valu

e error: associative array shape is not consistent with session parameters' enco

untered during execution of Generate function 'WF_XML.Generate' for event 'oracl

e.apps.wf.notification.send'. ERROR_STACK=                                     

PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR(POAPPRV, 10150-25246, TEST_CTX)           

Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, POAPPRV, 1015

0-25246, TEST_CTX)                                                             

Wf_Engine_Util.Execute_Selector_Function(POAPPRV, 10150-25246, TEST_CTX)       

Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, POAPPRV, 1015

0-25246, TEST_CTX)                                                             

Wf_Engine_Util.Execute_Selector_Function(POAPPRV, 10150-25246, TEST_CTX)       

Wf_Engine.CB(TESTCTX, POAPPRV:10150-25246:208270, ::::)                        

Wf_Engine.oldCB(TESTCTX, POAPPRV:10150-25246:208270, ::::)                     

WF_MAIL.SetContext(1320203)                                                    

WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 1320203)                  

WF_XML.Generate(oracle.apps.wf.notification.send, 1320203)                     

WF_XML.Generate(oracle.apps.wf.notification.send, 1320203)                     

Wf_Event.setMessage(oracle.apps.wf.notification.send, 1320203, WF_XML.Generate)

Wf_Event.dispatch_internal()                                                   

                                                                               

1 row selected.





OS: RHEL5.7

Database : 10.2.0.3

Apps : R12.0.4

 

 

 

Please help me to resolve this error.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points