Replies posted by arebbeadle
If you have the IFS extensibilty module you can add a custom field to the Print Pick List screen that can reference the shipment notes field. Once that is done the field will now be available to add to your pick list report using Report designer if you want it to print out.
Callum,It is working now, like you suggested, I unselected the ‘Print Order Confirmation’ on the customer saving the record and then reselected it / save the record and create a customer order again? This customer record was created 20 years ago and 4 upgrades since.Thank you
Thank you for responding,I have created multiple orders from scratch for this customer using different Order types, different part numbers, different address Ids and with different credit block settings but the ‘Print Order Confirmation’ option is still greyed out and not available to select. Something else must be needed?
We are using Oracle Enterprise 19c. I think our main concern is in two areas offsite backup and a reporting server which is updated at least once a day. I agree our TEST and DEV servers don’t need updated as frequently, we currently use RMAN for these. We basically run 20 hours a day 6 days per week. We do full backups on Sunday and incrementals nightly. Database is about 1.05TB. So I guess I am looking for ways to keep a second database server up todate for reporting purposes? Thank you,
I attached the log but it has errors. We are running APPS10 UPD 11. FROM custom_menu_key_trans_tab t,custom_menu_tab m *ERROR at line 4:ORA-06550: line 4, column 40: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 3, column 7: PL/SQL: SQL Statement ignored ORA-06550: line 18, column 42: PLS-00364: loop index variable 'REC' use is invalid ORA-06550: line 18, column 7: PL/SQL: Statement ignored
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?
If I make the change to EXECUTION_MODE = ‘InSequence’ and THREAD_COUNT = 1, I assume it will affect all printers in the Batch2 Queue? Should I create a new Print Task Template with a different Batch queue and move only the printers that I need to print InSquence? Currently all printers are in the same batch. Thanks,
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_SY
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.