1 Reply Latest reply: Nov 22, 2011 11:46 PM by 901700 RSS

    OLEDB not able to access

    560669
      I am executing the below function using

      fnd_request.submit_request using the Oracle DataProvider for .NET connection
      ending up with the error

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small
      ORA-06512: at "APPS.FND_DATE", line 32
      ORA-06512: at "APPS.FND_DATE", line 43
      ORA-06512: at line 1
      ORA-06512: at "APPS.FND_GLOBAL", line 413
      ORA-06512: at "APPS.FND_GLOBAL", line 2272
      ORA-06512: at "APPS.FND_GLOBAL", line 2546
      ORA-06512: at "APPS.FND_GLOBAL", line 2699
      ORA-06512: at "APPS.FND_GLOBAL", line 2636

      the code in the function is as below

      begin

      APPS.FND_GLOBAL.APPS_INITIALIZE(p_user, p_resp_id, p_resp_appl_id);
      APPS.MO_GLOBAL.SET_POLICY_CONTEXT('M', 148);

      v_request_id := APPS.fnd_request.submit_request(
      'INV', 'INCTCW', 'Inventory Transaction Worker',
      NULL, FALSE, v_id_val, 3, '','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','');

      dbms_output.put_line('Request Id: '||v_request_id);


      IF v_request_id = 0 THEN
      x_mast_status := 'E';
      --x_mast_err_msg := SUBSTR(x_mast_err_msg ||' '||'Error submitting request.', 1, 240);
      x_mast_err_msg := SUBSTR(x_mast_err_msg ||' '||'Error on Insert. '||sqlerrm, 1, 240);
      dbms_output.put_line( x_mast_err_msg);
      end if;

      end;

      any suggestion will help me out.

      Regards
      Yram