2 Replies Latest reply: Aug 28, 2012 4:47 PM by Hussein Sawwan-Oracle RSS

    Statement Generation Program fails when submitted through API

    907823
      Hi All,

      I am trying to submit standard concurrent program 'Statement Generation Program' using API
      But facing below error in log.


      ---------------------------------------------------------------------------
      Receivables: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      XXARXSGP module: CCL Statement Generation Program
      ---------------------------------------------------------------------------

      Current system time is 28-AUG-2012 09:36:04

      ---------------------------------------------------------------------------

      AR_USE_STATEMENTS_AND_DUNNING_SITE_PROFILE = N

      arxsgp (CPG) : Statement Generation Program
      arxsgp: 43 args
      arxsgp: Argument 0 XXARXSGP
      arxsgp: Argument 1 PRINT
      arxsgp: Argument 2 1000
      arxsgp: Argument 3 2681
      arxsgp: Argument 4
      arxsgp: Argument 5 30-APR-2009
      arxsgp: Argument 6
      arxsgp: Argument 7
      arxsgp: Argument 8
      arxsgp: Argument 9 3
      arxsgp: Argument 10
      arxsgp: Argument 11
      arxsgp: Argument 12
      arxsgp: Argument 13
      arxsgp: Argument 14
      arxsgp: Argument 15
      arxsgp: Argument 16
      arxsgp: Argument 17
      arxsgp: Argument 18
      arxsgp: Argument 19
      arxsgp: Argument 20
      arxsgp: Argument 21
      arxsgp: Argument 22
      arxsgp: Argument 23
      arxsgp: Argument 24
      arxsgp: Argument 25
      arxsgp: Argument 26
      arxsgp: Argument 27 N
      arxsgp: Argument 28
      arxsgp: Argument 29
      arxsgp: Argument 30
      arxsgp: Argument 31
      arxsgp: Argument 32
      arxsgp: Argument 33
      arxsgp: Argument 34
      arxsgp: Argument 35
      arxsgp: Argument 36
      arxsgp: Argument 37 103
      arxsgp: Argument 38 N
      arxsgp: Argument 39 Bima Clearing & Forwarding Ltd
      arxsgp: Argument 40 Bima Clearing & Forwarding Ltd
      arxsgp: Argument 41
      arxsgp: Argument 42
      arxsgp: AR_USE_STATEMENTS_AND_DUNNING_SITE_PROFILE = N
      arxsgp: AR_ENABLE_DEBUG_OUTPUT = Y
      Current system time is 28-AUG-2012 09:36:04
      REQUEST ID = 8340981
      arxsgp : Calling get_statement_date.
      Current system time is 28-AUG-2012 09:36:04
      arxsgp: No corresponding statement_date      for statement_cycle_date_id.
      arxsgp: Error from get_statement_date.
      arxsgp: Error in main.
      0 ORA-01403: no data found

      arxsgp(errexit): Delete Rows from interim table - AR_STATEMENT_HEADERS
      Current system time is 28-AUG-2012 09:36:04
      arxsgp(errexit): Delete Rows from interim table - AR_STATEMENT_LINE_CLUSTERS
      Current system time is 28-AUG-2012 09:36:04
      arxsgp(errexit): Deleted work successfully
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...

      Output file size:
      0


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 28-AUG-2012 09:36:04

      ---------------------------------------------------------------------------

      ----
      ----
      ----
      Action taken:
      Used statement_cycle_date_id which gave successful result when 'Statement Generation Program' is submitted through SRS.
      Have set AR_USE_STATEMENTS_AND_DUNNING_SITE_PROFILE ==> 'Y' at site level, but still it is shown as 'N' in log.

      Please do suggest


      Thanks and Regards,
      Sudbun.
        • 1. Re: Statement Generation Program fails when submitted through API
          907823
          Below is the PL/SQL code:



          declare
          v_request_id varchar2(100);

          begin
          fnd_global.APPS_INITIALIZE(user_id=>0,
          resp_id=>50239,
          resp_appl_id=>222);
          v_request_id := FND_REQUEST.SUBMIT_REQUEST(
          application => 'AR',
          program => 'ARXSGP',
          description => 'Statement Generation Program',
          start_time => SYSDATE,
          sub_request => FALSE,
          argument1 => 'PRINT',
          argument2 => 1000,
          argument3 => 2681,
          argument4 => NULL,
          argument5 => '30-APR-2009',
          argument6 => NULL,--'28-FEB-2009',
          argument7 => NULL,
          argument8 => NULL,
          argument9 => 3 ,
          argument10 => NULL,
          argument11 => NULL,
          argument12 => NULL,
          argument13 => NULL,
          argument14 => NULL,
          argument15 => NULL,
          argument16 => NULL,
          argument17 => NULL,
          argument18 => NULL,
          argument19 => NULL,
          argument20 => NULL,
          argument21 => NULL,
          argument22 => NULL,
          argument23 => NULL,
          argument24 => NULL,
          argument25 => NULL,
          argument26 => NULL,
          argument27 => 'N',
          argument28 => NULL,
          argument29 => NULL,
          argument30 => NULL,
          argument31 => NULL,
          argument32 => NULL,
          argument33 => NULL,
          argument34 => NULL,
          argument35 => NULL,
          argument36 => NULL,
          argument37 => 103,
          argument38 => 'N',
          argument39 => 'Bima Clearing & Forwarding Ltd',
          argument40 => 'Bima Clearing & Forwarding Ltd',
          argument41 => NULL,
          argument42 => NULL

          );

          dbms_output.put_line('Error Msg....'||SQLERRM );
          commit;

          if v_request_id > 0 then

          dbms_output.put_line('Successfully submitted');

          else

          dbms_output.put_line(v_request_id||'Not Submitted');
          end if;

          end;




          Thanks
          sudbun
          • 2. Re: Statement Generation Program fails when submitted through API
            Hussein Sawwan-Oracle
            Please see these docs.

            Sample PLSQL Script to Call Autoinvoice Import Program RAXTRX Using FND_REQUEST.SUBMIT_REQUEST in Release 12 [ID 1127399.1]
            fnd_request.submit_request Returning 0 Using pl/sql block [ID 812879.1]
            Oracle Applications Multiple Organizations Access Control for Custom Code [ID 420787.1]
            SQL Queries and Multi-Org Architecture in Release 12 [ID 462383.1]

            Thanks,
            Hussein