Print Manager error message An item with the same key has already been added.

We are using IFSAPPS 10 Update 11,

This is the menu SQL

DECLARE 
result_key_ Number; 
pr_attr_ varchar2(2000); 
attr_ varchar2(2000);
report_id_ varchar2(2000);
job_id_ number; 
par_attr_ varchar2(2000);
XSO varchar(12):= &ORDER_NO;
XREL varchar(4):= &RELEASE_NO;
XSEQ varchar(4):= &SEQUENCE_NO;
site_ varchar2(5):= &CONTRACT;
BEGIN 
report_id_ := 'ARE_PART_ORDER_INFO_TAG_REP';
Client_SYS.Add_To_Attr('PRINTER_ID', 'DD1REARDOOR',pr_attr_);
Client_SYS.Add_To_Attr('EXPIRE_DATE',sysdate+30,pr_attr_);
Print_Job_API.New(job_id_,pr_attr_);
Client_SYS.Add_To_Attr('REPORT_ID',report_id_,pr_attr_);
Client_SYS.Add_To_Attr('LAYOUT_NAME', 'DD1_RearDoorLabel_2022.rpt', pr_attr_);
Client_SYS.Clear_Attr(par_attr_);
Client_SYS.Add_To_Attr('CONTRACT', site_,par_attr_);
Client_SYS.Add_To_Attr('ORDER_NO', XSO,par_attr_);
Client_SYS.Add_To_Attr('REL_NO', XREL,par_attr_);
Client_SYS.Add_To_Attr('LINE_NO', XSEQ, par_attr_);
Archive_API.New_Instance(result_key_,pr_attr_,par_attr_);
Client_SYS.Clear_Attr(attr_);
Client_SYS.Add_To_Attr('PRINT_JOB_ID', job_id_, attr_);
Client_SYS.Add_To_Attr('RESULT_KEY', result_key_, attr_);
Print_Job_Contents_API.New_Instance(attr_);
Print_Job_API.Print(job_id_);
commit;
END;

Hi Himasha,

The command line process did not resolve the issue.

Himasha,

Thank you but I don’t see how this script will help. It states- Purpose:    This script lists custom menus with action type 'Create Window with Transfer' where 'Source Key Name' of Key Translations are duplicated.

My custom menu is creating a Print job executing a SQL script not a 'Create Window with Transfer'. Will it still help to run the script?

Ok, I will run the script and post results if possible.

Hi @arebbeadle,

I have extracted the SQL query below from the attached script. Please run it and let us know the outcome.

SELECT t.menu_id,m.window,t.source_key_name, count(t.source_key_name)
      FROM custom_menu_key_trans_tab t,custom_menu_tab m
      WHERE t.menu_id = m.menu_id
      GROUP BY t.menu_id,m.window,t.source_key_name
      HAVING COUNT (t.source_key_name) > 1;