3 Replies Latest reply: Aug 11, 2012 2:31 AM by 814515 RSS

    XML Concurrent Program ends with error...

    814515
      Hi,

      I am using the below code in my package body to submit concurrent programs.

      declare
      l_request_id varchar2(240);
      l_phase varchar2(240);
      l_status varchar2(240);
      l_dev_phase varchar2(240);
      l_dev_status varchar2(240);
      l_message varchar2(240);
      l_request_id_status BOOLEAN;
      BEGIN
      Fnd_Global.apps_initialize(1532, 50269, 660);
      l_request_id := FND_REQUEST.SUBMIT_REQUEST(
      application => 'ONT',
      program => 'RENCETMO',
      start_time => TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS'), --- This program completes normal ---
      sub_request => FALSE,
      argument1 => '820003985',
      argument2 => NULL,
      argument3 => NULL,
      argument4 => NULL,
      argument5 => NULL,
      argument6 => NULL,
      argument7 => NULL,
      argument8 => NULL,
      argument9 => NULL,
      argument10 => NULL,
      argument11 => NULL,
      argument12 => NULL,
      argument13 => NULL,
      argument14 => NULL,
      argument15 => NULL,
      argument16 => NULL,
      argument17 => NULL,
      argument18 => NULL,
      argument19 => NULL);
      commit;
      DBMS_OUTPUT.put_line ( 'Bala~Request~' || l_request_id);
      IF (l_request_id != 0) THEN
      l_request_id_status := Fnd_Concurrent.WAIT_FOR_REQUEST(
      request_id => l_request_id,
      INTERVAL => 5,
      max_wait => 0,
      phase => l_phase,
      status => l_status,
      dev_phase => l_dev_phase,
      dev_status => l_dev_status,
      MESSAGE => l_message);
      Commit;
      ---- DBMS_OUTPUT.put_line ( 'Bala~Request~Status' || l_request_id_status);
      IF (UPPER(l_status) = 'NORMAL') THEN
      l_request_id := FND_REQUEST.SUBMIT_REQUEST(
      application => 'XDO',
      program => 'XDOREPPB',
      start_time => TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS'),
      sub_request => FALSE,
      argument1 => l_request_id,
      argument2 => 'ONT',
      argument3 => 'RENCETMO',
      argument4 => null,
      argument5 => 'N',
      argument6 => 'RTF',
      argument7 => 'PDF'
      );
      DBMS_OUTPUT.put_line ( 'Bala~Request~PDF' || l_request_id);
      commit;
      END IF;
      END IF;
      end;


      And at the end I am getting the following error message for the second request (i.e. XDOREPPB).

      Oracle XML Publisher 5.6.3
      java.lang.NumberFormatException: For input string: "ONT"
           at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
           at java.lang.Integer.parseInt(Integer.java:468)
           at java.lang.Integer.parseInt(Integer.java:518)
           at oracle.apps.xdo.oa.cp.JCP4XMLPublisher.runProgram(JCP4XMLPublisher.java:214)
           at oracle.apps.fnd.cp.request.Run.main(Run.java:148)


      Please someone help me to resolve the issue.

      Bala.
        • 1. Re: XML Concurrent Program ends with error...
          Helios-GunesEROL
          Hi;

          Similar issue mention at below notes, please review
          XDOREPPB When Generating FSG Report Using XML Format Errors With java.lang.NumberFormatException: For input string: "RGFSGXPB" [ID 549809.1]
          Planning Detail Report Completed With Error [ID 551338.1]


          Regard
          Helios
          • 2. Re: XML Concurrent Program ends with error...
            Vortex13
            If you look at the parameters for the XDOREPPB program, you will notice the first parameter is not displayed. For this first parameter the request does a SQL and passes in a value and the user doesn't see this parameter when it is run. Therefore the request_id is the 2nd parameter, but you are passing in 'ONT' (because the application should be the 3rd parameter).

            Try to update your parameters like this:
            argument1 => XDO_CP_DATA_SECURITY_PKG.GET_CONCURRENT_REQUEST_IDS
            argument2 => l_request_id,
            argument3 => 'ONT',
            argument4 => 'RENCETMO',
            argument5 => null,
            argument6 => 'N',
            argument7 => 'RTF',
            argument8 => 'PDF'
            HTH,
            --Johnnie                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
            • 3. Re: XML Concurrent Program ends with error...
              814515
              Thanks for your response.

              I shouldn't have pass 'ONT' for XDOREPPB program. It should be app_id (660).

              The issue got resolved now.

              Regards,
              Bala