0 Replies Latest reply on Sep 9, 2011 1:44 PM by 874471

    Error while creating SR using CS_ServiceRequest_PUB.Create_ServiceRequest

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

      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 and database version is 9i.

      Can you please help??