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
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 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
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, 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 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, 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 basic question. There is a way to disable on a specific LU or VIEW option to paste over a template or copy. Thanks guys.
Already have an account? Login
No account yet? Create an account
Enter your 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.