is it possible to execute a Rpi package from backend in so that its result key generated.
execute a rpi frombackend?
Hi Pardeep,
You should be able to do that in a test window with a commit, pass the relevant parameters to the method. I think probably an ‘ATTR’.
Hi Pradeep,
Check below forum post regarding creating and executing a report from backend.
Batch print Work Instructions for Shop Orders, IFS9 | IFS Community
Cheers!
Damith
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hi Pardeep,
You should be able to do that in a test window with a commit, pass the relevant parameters to the method. I think probably an ‘ATTR’.
Hello Infaz
can you please send me an example i want to run CUSTOMER_ORDER_DELIV_NOTE_RPI report from backend. note i don't have any result key of this. i have delivery no for which i want to run report
Thanks In Advance
Regards
Pardeep Saini
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hi Pardeep,
Please refer this
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/edf73422-674f-4771-bcef-ed0b0946a977.png)
Hi Infaz,
I try but got error
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/9b0c1fa5-95f2-4943-a595-160178f6fcfd.png)
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hi Pardeep,
Please refer this
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/edf73422-674f-4771-bcef-ed0b0946a977.png)
Hi Infaz,
I try but got error
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/9b0c1fa5-95f2-4943-a595-160178f6fcfd.png)
I am working with IFS 7
Rewrite your code like this and retry.
declare
distribution_list_ VARCHAR2(100) := 'IFSAPP';
result_key_ varchar2(100) := null;
print_attr_ varchar2(100) := null;
report_attr_ varchar2(2000);
parameter_attr_ varchar2(2000);
begin
-- Call the procedure
Client_SYS.Clear_Attr(report_attr_);
Client_SYS.Clear_Attr(parameter_attr_);
client_sys.clear_attr(print_attr_);
client_sys.add_to_attr('REPORT_ID','CUSTOMER_ORDER_DELIV_NOTE_REP', report_attr_);
client_sys.add_to_attr('DELNOTE_NO',10035, parameter_attr_);
client_sys.add_to_attr('DELNOTE_COPY_NO',0, parameter_attr_);
Archive_API.New_Client_Report(result_key_,
report_attr_,
parameter_attr_ ,
distribution_list_,
print_attr_);
end;
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Rewrite your code like this and retry.
declare
distribution_list_ VARCHAR2(100) := 'IFSAPP';
result_key_ varchar2(100) := null;
print_attr_ varchar2(100) := null;
report_attr_ varchar2(2000);
parameter_attr_ varchar2(2000);
begin
-- Call the procedure
Client_SYS.Clear_Attr(report_attr_);
Client_SYS.Clear_Attr(parameter_attr_);
client_sys.clear_attr(print_attr_);
client_sys.add_to_attr('REPORT_ID','CUSTOMER_ORDER_DELIV_NOTE_REP', report_attr_);
client_sys.add_to_attr('DELNOTE_NO',10035, parameter_attr_);
client_sys.add_to_attr('DELNOTE_COPY_NO',0, parameter_attr_);
Archive_API.New_Client_Report(result_key_,
report_attr_,
parameter_attr_ ,
distribution_list_,
print_attr_);
end;
try above code but no luck
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/764a818c-efde-42f3-9a07-5edd970571e2.png)
Hi Pardeep,
Please encapsulate deliv_no & and the other number via strings.
client_sys.add_to_attr('DELNOTE_NO','10037', parameter_attr_);
client_sys.add_to_attr('DELNOTE_COPY_NO','0', parameter_attr_);
I don’t have IFAPP V7 so please debug and check the error, this is the base and you should be able to create a result key.
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Rewrite your code like this and retry.
declare
distribution_list_ VARCHAR2(100) := 'IFSAPP';
result_key_ varchar2(100) := null;
print_attr_ varchar2(100) := null;
report_attr_ varchar2(2000);
parameter_attr_ varchar2(2000);
begin
-- Call the procedure
Client_SYS.Clear_Attr(report_attr_);
Client_SYS.Clear_Attr(parameter_attr_);
client_sys.clear_attr(print_attr_);
client_sys.add_to_attr('REPORT_ID','CUSTOMER_ORDER_DELIV_NOTE_REP', report_attr_);
client_sys.add_to_attr('DELNOTE_NO',10035, parameter_attr_);
client_sys.add_to_attr('DELNOTE_COPY_NO',0, parameter_attr_);
Archive_API.New_Client_Report(result_key_,
report_attr_,
parameter_attr_ ,
distribution_list_,
print_attr_);
end;
try above code but no luck
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/764a818c-efde-42f3-9a07-5edd970571e2.png)
still having same error after converting to string
Rewrite your code like this and retry.
declare
distribution_list_ VARCHAR2(100) := 'IFSAPP';
result_key_ varchar2(100) := null;
print_attr_ varchar2(100) := null;
report_attr_ varchar2(2000);
parameter_attr_ varchar2(2000);
begin
-- Call the procedure
Client_SYS.Clear_Attr(report_attr_);
Client_SYS.Clear_Attr(parameter_attr_);
client_sys.clear_attr(print_attr_);
client_sys.add_to_attr('REPORT_ID','CUSTOMER_ORDER_DELIV_NOTE_REP', report_attr_);
client_sys.add_to_attr('DELNOTE_NO',10035, parameter_attr_);
client_sys.add_to_attr('DELNOTE_COPY_NO',0, parameter_attr_);
Archive_API.New_Client_Report(result_key_,
report_attr_,
parameter_attr_ ,
distribution_list_,
print_attr_);
end;
try above code but no luck
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/764a818c-efde-42f3-9a07-5edd970571e2.png)
still having same error after converting to string
Hi Pradeep, please check whether you have the Customer_Order_Deliv_Note_RPI package, also can you debug the code from PL/SQL developer, line by line, and find where the error occurs. When you get the error Report Definition does not exist means this particular report doesn’t exist or you have a typo on the report name.
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hello Dumeesha,
i got below error
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/b4afefb6-d0d4-44db-ad26-6662a81cd121.png)
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Rewrite your code like this and retry.
declare
distribution_list_ VARCHAR2(100) := 'IFSAPP';
result_key_ varchar2(100) := null;
print_attr_ varchar2(100) := null;
report_attr_ varchar2(2000);
parameter_attr_ varchar2(2000);
begin
-- Call the procedure
Client_SYS.Clear_Attr(report_attr_);
Client_SYS.Clear_Attr(parameter_attr_);
client_sys.clear_attr(print_attr_);
client_sys.add_to_attr('REPORT_ID','CUSTOMER_ORDER_DELIV_NOTE_REP', report_attr_);
client_sys.add_to_attr('DELNOTE_NO',10035, parameter_attr_);
client_sys.add_to_attr('DELNOTE_COPY_NO',0, parameter_attr_);
Archive_API.New_Client_Report(result_key_,
report_attr_,
parameter_attr_ ,
distribution_list_,
print_attr_);
end;
try above code but no luck
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/764a818c-efde-42f3-9a07-5edd970571e2.png)
still having same error after converting to string
Hi Pradeep, please check whether you have the Customer_Order_Deliv_Note_RPI package, also can you debug the code from PL/SQL developer, line by line, and find where the error occurs. When you get the error Report Definition does not exist means this particular report doesn’t exist or you have a typo on the report name.
Hi
all parameter are correct and report id also correct
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hello,
I tried below and got the result key created.
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/554b5619-3d8c-4976-b8dc-e83da7d9a25b.png)
/Dumeesha
Hi Dumeesha
got below error. i am using ifs v7
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/a5545dd1-9e9e-4d3a-836b-c37bb6173e88.png)
report defination object exists but is is showing not exists
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/0fe6d006-0f7f-4c36-bae0-78354807e2f0.png)
thanks in advance
Hello,
Try accessing the Customer_Order_Deliv_Note_RPI in PL SQL for your login user ?
Then try removing the distribution list parameter value and check ?
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hello,
Try accessing the Customer_Order_Deliv_Note_RPI in PL SQL for your login user ?
Then try removing the distribution list parameter value and check ?
please correct attached code
Hi Dumeesha
got below error. i am using ifs v7
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/a5545dd1-9e9e-4d3a-836b-c37bb6173e88.png)
report defination object exists but is is showing not exists
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/0fe6d006-0f7f-4c36-bae0-78354807e2f0.png)
I wanted to mention that remove the user id - CINC1APP from the distribution list in above. I got an error that user is not defined in the distribution list and after removing the value the result key was created. In your scenario it seems that you do not have the access to Customer_Order_Deliv_Note_RPI . Anyway you can try what I did after confirming the access to report method. There’s nothing to correct in the attached file
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hi Dumeesha
got below error. i am using ifs v7
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/a5545dd1-9e9e-4d3a-836b-c37bb6173e88.png)
report defination object exists but is is showing not exists
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/0fe6d006-0f7f-4c36-bae0-78354807e2f0.png)
I wanted to mention that remove the user id - CINC1APP from the distribution list in above. I got an error that user is not defined in the distribution list and after removing the value the result key was created. In your scenario it seems that you do not have the access to Customer_Order_Deliv_Note_RPI . Anyway you can try what I did after confirming the access to report method. There’s nothing to correct in the attached file
Got same error after removing Cinc1app
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/c7eb0e2d-fc8c-4006-bee0-6a161841d1e4.png)
![1 Year Member Badge](https://uploads-eu-west-1.insided.com/ifs-en/attachment/32be2c32-660b-402b-8ee6-89eda72d532a_thumb.png)
Hi,
Check the report id in REPORT_SYS_TAB
Hi,
Report Id is available in report_sys_tab
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.