0 Replies Latest reply on Jun 10, 2020 2:32 PM by Cindy.yuan

    REP-1415: 'AfterPform': Unknown user exit 'FND'.

    Cindy.yuan

      Hi

      I'm facing an issue while opening a custom report from report builder 10g.

      the report has been compiled normally.

      Then when i click output > xml,then enter buyer, got the below error:

      REP-1415: 'AfterPform': Unknown user exit 'FND'.

      had p_concurrent_id

       

      AfterPform code is as below:

      < 1)we need to call the user exit srw.user_exit('FND SRWINIT') here and remove it from the before report
          trigger as we want the  value of userenv'(clientinfo') before querying on the striped table
          po_system_parameters.
        2)Setting the value of the parameter :P_single_po_print 
      */
         SRW.user_exit('FND SRWINIT');
         begin
             SELECT  psp.manual_po_num_type        manual_po_num_type
             into    :P_po_num_type
             FROM    po_system_parameters psp;

         exception
              when no_data_found then
                   :P_po_num_type := 'ALPHANUMERIC';
              when others then
                  :p_po_num_type := 'NUMERIC';    
         end;>

      After  commend out  <SRW.user_exit('FND SRWINIT');>,got the REP-1415 error in <before report function> next time.

       

      The code of beforereport is as below:


        < If :P_po_num_from = :P_po_num_to THEN
      :P_single_po_print := 1;
        END IF;


        srw.user_exit('FND INSTALLATION OUTPUT_TYPE="STATUS"
                       OUTPUT_FIELD=":P_EC_STATUS"
                       APPS="EC"');

        srw.message ('010', :P_ec_status);

        SRW.USER_EXIT('FND FLEXSQL CODE           ="MSTK"
                                   OUTPUT         =":P_FLEX_ITEM"
                                   APPL_SHORT_NAME="INV"
                                   MODE           ="SELECT"
                                   DISPLAY        ="ALL"
                                   NUM            ="101"
                                   TABLEALIAS     ="MSI"');

      /* Check for multilingual installation and take appropriate action. */
      /* See Reports PL/SQL for more details. */
        if (MLS_INSTALLED) then
           POPULATE_MLS_LEXICALS;
        end if;

        RETURN TRUE;
      END;  return (TRUE);
      end;>

       

      If i commend out this, the output completed successfully, however, i didn't get required PO header data and line data.

       

      The program is working from application.

       

      How to solve the issue?

      Please advice.

       

      Best Regards