2 Replies Latest reply: Jul 18, 2013 12:17 PM by Hussein Sawwan-Oracle RSS

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

    sokar

      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.