1 Reply Latest reply on Mar 25, 2014 6:42 PM by User506064-OC

    ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.WF_NOTIFICATION", line 5838 ORA-06512: at line 6

    User506064-OC

      Hi All,

       

           There is a requirement to attache new OAF region to show supplier details on the Award approval notification. I created the oaf region and attached it to the standard notification page and it works fine worklist notification page, But the region is not getting reflected in notification sent via email.

       

         Then  i changed the logic and added the OAF stack layout region to workflow message, when notification is opened it gives below error:

      ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.WF_NOTIFICATION", line 5838 ORA-06512: at line 6


      Below are the steps which i followed for this:


      1. Created stack layout region.

      2. Created a new attribute in workflow, XXACT_SUPPLIER_DETAILS and set

          Value: "OA.jsp?page=JSP:/OA_HTML/OA.jsp?OAFunc=XXACT_SUPPLIER_DETAILS"

          Type:  Document

          Frame Target: Full Window

          Type: Constant

      3. created the message in workflow and called the same message in message body.

          Message Attribute Properties:


          Type: Document

          Source: Send

          Frame Target: Full Window

      Default

          Type: Item Attribute

          Frame Target: Full Window

          Type: Constant

          Value:Supplier Details



      Please help me in resolving this issue it is urgent. Please reply ASAP.


      Thanks in advance


      Regards,

      AGS.