Question

Debug order report or RPI

  • 4 January 2023
  • 1 reply
  • 90 views

Userlevel 1
Badge +3

How can we debug order report ?

I ran the report, data is populating to RPT table, but not writing to XML.

I want to check the step by step execution of RPI.

 

Please suggest

 


1 reply

Userlevel 7
Badge +14

You can use the same mechanism for other versions as well 

Create a similar script like this 

 

-- IFS Report Debugger Script



-- This script has been created automatically. Please do not change it!



DECLARE

  result_key_     NUMBER;
   report_attr_       VARCHAR2(32767) ;



   parameter_attr_    VARCHAR2(32767) := 'RMA_NO200002';

BEGIN

  Report_SYS.Get_Result_Key__(result_key_);

   Client_SYS.Add_To_Attr('RESULT_KEY', result_key_, report_attr_);
   EXECUTE IMMEDIATE 'BEGIN ' || Report_Definition_API.Get_Method('RETURN_MATERIAL_REP') || '(:report_attr, :parameter_attr); END;'



   USING             report_attr_, parameter_attr_;



END;

and execute it on PLSQL using a test window

Reply