Hi guys,I needed to keep two fields between two logical units with the same value at the same time so that the user can edit them in both logical units. I used an event on both fields that triggers when the field is changed. Both events is runnig like background job. Event1 triggering when value in object1 is modify in LU1 --> make copy value to object2 in LU2Event2 triggering when value in object2 is modify in LU2 --> make copy value to object1 in LU1 In 99% of the cases this works fine, but sometimes it happens that these two events get stuck and loop until I turn off one of the events. Anyone have any ideas on how to prevent this cycling? It's clear to me why this occurs, but I would need to be able to have the value of the fields interleave between logical units and at the same time be able to change it anywhere.If anyone has a better idea I would be grateful. Thanks
Hello,i have basic question. There is a way to disable on a specific LU or VIEW option to paste over a template or copy. Thanks guys.
Hello guys, i try set application server to send quickreport. My settings are standard.Queue:BATCH2Execute As: systemLocale: englishquickreport without parametrsemail, email subject, email body sets normal and name of document is soubor.xlsx In Schedule i fill in Application_message id and One_time_task like FALSE and i getting this error application server Entity instance not found. (QUICK_REPORT - QUICK_REPORT_ID=128961.0)or this Does anyone know where is the problem? Thanks you guys.
Hello, is there any way to always bypass the stop-event? Because I would need one form (namely PurchasePartSupplManuf in PurchasePartSupplier) to be completely locked for changes via stop-event. But in order to be able that when I make a change in PartManufacturer in Part_Catalog, it automatically takes me to PurchasePartSupplManuf and ignores the stop-event to PurchasePartSupplManuf. I know I can set exceptions, through #USER_ID# but it is not good for this. For example i need with for break my stop event and make changes in PurchasePartSupplier DECLARE attr_ VARCHAR2(32000); sql_msg_ VARCHAR2(32000); stmt_ VARCHAR2(32000);BEGIN stmt_ := 'DECLARE info_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000); p1_ VARCHAR2(32000) := ''''; p2_ VARCHAR2(32000) := ''''; row_key_ VARCHAR2(32000):=''&NEW:ROWKEY''; CURSOR get_objid IS SELECT * FROM PART_MANU_PART_NO WHERE OBJKEY =row_key_;BEGIN FOR part1_
Hello, I have a user request if IFS could automatically send different reports on certain days of the month. The only option I can think of to send them is by email, but I have no idea how to call them in the event so that they are created as attachments. If anyone has a better idea, I'd be grateful.
Hello, i have small problem. I want to combine sql statement with reference. Is there any way, how to create custom column in purchase order, where i need using SQL statement but i want use link possibility as well. Ideal result for me is a “String” from SQL statement and if user click on string will be transfer by link path. And another silly question. It is possible to create a reference outside the LU. For example: In purchase order i have PART_NO from PART_CATALOG on order line and i want create reference from this line to PART CATALOG. It is possible? Thanks you guys.
Hello, i trying create a event, where after save new record in “Vendor Purchase Item” form, i want modify record based on Part number. But i get ERROR about mutating table. Is there any change i can solved this? Event settings: runnig only for “new created object” and run “after” and LJ is PurchasePartSupplier and table is PURCHASE_PART_SUPPLIER_TAB.I read about solving by calling custom procedure and run it as a deferred call, but i dont beleave, that is only one solution. DECLARE -- pragma autonomous_transaction;--info_ varchar2(32000); info_ VARCHAR2(32000) := NULL;attr_ varchar2(32000);PART_NO_ varchar2(32000) :='&NEW:PART_NO';DES_ varchar2(32000);BEGIN FOR rec_ IN ( select pps.part_no, pps.objid, pps.objversion from PURCHASE_PART_SUPPLIER pps where pps.OBJKEY = '&NEW:ROWKEY') LOOPIF (REGEXP_LIKE(SUBSTR(PART_NO_ , 1, 1), '[[:alpha:]]') AND NOT REGEXP_LIKE(PART_NO_, '-E')) THEN Client_Sys.Clear_Attr(attr_); Client_Sys.Add_To_Attr('RECEIVE_CASE_DB', 'QAI
Hello guys. I try add fee for supplier by PL/SQL functions. But i get some errors and i dont know where is the problem. DECLARE info_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000); p1_ VARCHAR2(32000) := ''; p2_ VARCHAR2(32000) := ''; a_ NUMBER := 0; CURSOR get_data IS select p.SUPPLIER_ID from SUPPLIER_INFO_GENERAL p WHERE SUPPLIER_ID = '20040'; BEGINFOR rec_ IN get_data LOOP Client_Sys.Clear_Attr(attr_); Client_Sys.Add_To_Attr('VENDOR_NO', rec_.supplier_id, attr_); Client_Sys.Add_To_Attr('CONTRACT', 'RETIA', attr_); Client_Sys.Add_To_Attr('CHARGE_TYPE', 'DOPR + BAL', attr_); Client_Sys.Add_To_Attr('CHARGE_BY_SUPPLIER', rec_.supplier_id, attr_); IFSAPP.PURCHASE_CHARGE_SUPPLIER_API.NEW__(info_,p1_,p2_,attr_ ,'DO'); a_ := a_ + 1; END LOOP;END; ERROR what i get is
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.