Skip to main content
Question

Debug order report or RPI

  • January 4, 2023
  • 1 reply
  • 194 views

Forum|alt.badge.img+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

Chamaka Wimalarathne
Hero (Partner)
Forum|alt.badge.img+15

https://community.ifs.com/ifs-general-topics-employees-partners-only-79/debugging-reports-in-slow-app-75-or-lower-versions-2753

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings