1 Reply Latest reply: Feb 17, 2009 5:29 AM by 591513 RSS

    Creating the iStore User in Custom PL/SQL procedure

    shan@rbc
      Hi All,

      i wrote on PL/SQL procedure for creating the user and send an email to user as notification .
      well my procedure creating the User in FND user table but its not sending the mail notification ..
      then i manually called this procedure from toad
      *"ibe_workflow_pvt.notifyRegistration"* in output screen am getting error as like
      *" x_msg_data:=ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package IBE_WF_MSG_MAPPING_PVT Procedure Retrieve_Msg_Mapping "*

      is anybody having any idea about this , Thanks for advance .