0 Replies Latest reply: Sep 9, 2011 8:44 AM by 874471 RSS

    Error while creating SR using CS_ServiceRequest_PUB.Create_ServiceRequest

    874471
      Hi All,
      I am getting below error while creating an SR from the backend using API 'CS_ServiceRequest_PUB'.

      Error:
      "
      API Programming Error (CS_ServiceRequest_PUB.Create_ServiceRequest): An error occurred when validating the descriptive flexfield.
      Additional information:Program error: Please inform your support representative that:

      FLEXFIELDS SERVER-SIDE VALIDATION package reports error:

      validate_desccols() exception: ORA-20005: DVLB.get_default_context() failed. SQLERRM: ORA-01403: no data found
      ORA-06512: at "APPS.FND_FLEX_DESCVAL", line 931
      ORA-01403: no data found
      Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      "

      I have intialised the context as below while running the stand alone procedure in SQL Developer.

      Fnd_Global.apps_initialize (user_id => 1368347,
      resp_id => 21739
      resp_appl_id => 514 );


      We are on 11.5.10.2 and database version is 9i.

      Can you please help??

      TIA,
      S