Morning Mathias, I followed the excellent example on: https://dsj23.me/2021/08/27/tips-to-avoid-mutating-table-error-in-ifs-event-actions/Which I think was wrote by someone in the community.To resolve this problem I did as follows:Created a package to handle the removal, utilising the IFS remove API (package in my question above) Created a custom event that would trigger once a rejection was complete on a specific approval description. (Event in my question above) Created a custom event action that implements a defered background job which calls my package to handle the removal. (Statement below)DECLARE attr_ VARCHAR2(32000); sql_msg_ VARCHAR2(32000); stmt_ VARCHAR2(32000); job_id_ NUMBER; error_text_ VARCHAR2(2000); BEGINstmt_ := 'DECLARE BEGIN rk_contract_mgmt_api.Remove_Supplier_Approvals(''&NEW:KEY_REF'');END;';sql_msg_ := Message_SYS.Construct('UPD'); Message_SYS.Add_Attribute(sql_msg_, 'SQL'
Checked the code again, and found this: IF lu_name_ = 'DocIssue' THEN Get_Receiver_And_Admins___(receiver_, admin_list_, key_ref_, include_admins_); ELSE receiver_ := 'NO RECEIVER DEFINED'; END IF; As you can see and which is perhaps the reason you ask, when an approval routing is connected to other business objects than documents, there is really no receiver for this event, and the code just sets ‘NO RECEIVER DEFINED’ then. The only way we could have one would be to store whoever added the approval step, and use that as the receiver here. We don’t do that though. Or, we could of course enhance this functionality and make it configurable per object type how to determine the receiver. So, there is room for improvement here… What you probably can do is to use another event action type, Execute Online SQL. There you can run and SQL or PL/SQL you need to determine the receiver. Once you have it you can send an e-mail using the Command_SYS package. If you
You need an event action like this to notify the originator. Event is out of the box. Took me a while to find this one as well, but once set up, it has worked fine for me. Hi Shawn Thanks for the information again. I’ve managed to get most of the event to work however, when I use the ‘RECEIVER’ field it either returns as just the field name &RECEIVER or has the text ‘NO RECEIVER DEFINED’. Do you have any idea why this could be? Thanks
You need an event action like this to notify the originator. Event is out of the box. Took me a while to find this one as well, but once set up, it has worked fine for me. Hi Shawn, I’ll give this a test today and let you know if it works as expected. It does look very promising.Thanks for the information. Regards,Ryan
@Minoshini Fonseka Good Afternoon, Sorry for the delayed response. I’ve been investigating this and have noticed if the user clicks ‘Reprint Modified option on Customer Invoice’ and then clicks the output (below). It doesn’t seem to email the invoice with the invoice number?Example imageEmail output:This is the Reporting rule I’ve setup (I think this is correct) Regards,Ryan
Hi @PD.Ryan.Kerr , You can do this easily by configuring a report rule. Although it’s a crystal report, it’s added under CUSTOMER_ORDER_IVC_REP. You can try this. 1. Add a report Rule for CUSTOMER_ORDER_IVC_REP report and add a Send Email action. 2.Then Edit Action properties If you click the three dots after the filed in the AttachmentName, Set Expression dialog opens and there you can select Invoice No. 3.Now, I will print this report. Following is the preview. - Invoice No is CR979920052 Now you can receive the mail with the Invoice ID Here, I just mentioned the attachment name, but you can further make changes to the mail format accordingly. For further clarifications, you can check Report Rules Guidelines in F1 docs. The document are based on APP 10 track. Hi Minoshini, Will this also work without including a To address? as I’d like this to fire to specific customers with the invoice Number on the attachment.Regards,Ryan
Hi Fiamsko, We’ve had a similar issue in the past, instead of sticking with report designer we instead transferred a lot of the reports within report definitions in to Crystal Reports instead.This then allowed us to include either sub reports to handle this or what we’ve done is include formulas to handle the different companies. We have around 25 companies on once instance of IFS therefore, our T&C’s which are located in the footer are different depending on the company. Personally, I don’t like updating the IFS Reports and if we have issues with the inbuilt IFS reports. I instead rebuild them in crystal reports using the same Ifs VIEW (INSTANT_INVOICE_REP etc.)Regards,R
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.
