Hi,thanks for your response, but I don't know if I'm understanding this right, but it seems like it's not gonna solve anything and I'm gonna get the noose again.If I understand correctly, I'll create a modify event on the first field, where I'll create a new record in the newly created LU. I will do the same for the second field.And over the newly created LU I will create an event when a new record is added to the LU. And that will ensure that I synchronize the two fields. But this seems like a pure loop to me, because once the event over the new LU triggers a modify over a field, it will automatically write itself. The only possibility I can think of is that the event on the new LU wouldn't use the modify function, but would directly use the SQL update event and it wouldn't run the modify event on those fields.If I misunderstood that, I apologize. And thanks again for the reply.
For now i tried this
Good morning, thank you for the advice, but unfortunately this is set up well. Second error what i get from application serve is Insufficient privileges to export the quick report to Excel. Caused by: ifs.fnd.base.SystemException: Insufficient privileges to export the quick report to Excel.
In short, I would need to be able to say that an event where I change something in part_catalog is always triggered by the IFSAPP user and then I am able to make an exception in the stop-event.
Yes its good solution. Thank
onprem
Onprem I have similiar problem, but another error message. I create event, where user create new purchase order. Ofcouse triggering on create and running after. LU: PurchaseOrder And after saving order IFS show me error, that order_no doesnt exist, but in detail of message, he tells me number of order DECLARE info_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000); p1_ VARCHAR2(32000) := ''; p2_ VARCHAR2(32000) := ''; ORDER_NO_ :='&NEW:ORDER_NO'; COUNT_LINE_PART NUMBER; COUNT_LINE_PART_NOPART NUMBER;BEGINSELECT COUNT(*) INTO COUNT_LINE_PART FROM PURCHASE_ORDER_LINE_PART a WHERE ORDER_NO= ORDER_NO_;SELECT COUNT(*) INTO COUNT_LINE_PART_NOPART FROM PURCHASE_ORDER_LINE_NOPART a WHERE ORDER_NO= ORDER_NO_;IF COUNT_LINE_PART >= 1 AND COUNT_LINE_PART_NOPART = 0 THEN Client_Sys.Clear_Attr(attr_); Client_Sys.Add_To_Attr('ORDER_NO', ORDER_NO_,attr_); Client_Sys.Add_To_Attr('CONTRACT', 'RETIA', attr_); Client_Sys.Add_To_Attr('CHARGE_TYPE', '
Thanks guys, both version is good and it works.
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.