Hi @dsj , Thanks for you comment, however I am unable to access this link as it is for selected users. Need assistance for sending emails with attachments triggered by an event. (23R1) | IFS Community I have written the code and it appears to mostly work, however if a PO does not have a document to be attached it adds what was on the previous email. Is there a way to clear the attachments array after the email have been produced and sent ? Thanks in advance Hi @JannetteC If you are sending mails for different POs inside a loop, you need to clear the attachment array first. Can you share your code, so it could be easy to find what’s wrong :)
@Mathias Dahl I managed to create a BPA WF to set the CopyFile to false. I followed the excellent instructions created by @dsj on his blogpost: IFS Workflows – Think Big… Start Small… – DSJ's Blog (dsj23.me) Glad that my blog post helped you straight away 😎
@dsj you’re dangerously inventive 🤣! sometimes you can’t wait until IFS solves everything and need to cheat a little 😁
Hi @Marcel.Ausan and @mukesh.a I think you would get table mutate error with trigger in either table since the data is saved in the same transaction in both _TAB and _CFT If your endpoint doesn't use OAuth2 authentication, My suggestion is to use a workflow for such a scenario and use the projection action trigger.You can easily send to a REST endpoint using IFS REST Call (IFS REST Call - Technical Documentation For IFS Cloud) Hope it helps!Damith
@dfsjmarchant as far as I know it’s not possible to schedule a BPA. BPAs are triggered by event actions / projection calls / user interaction. What you could do is: make sure the Auto Close PO option is set to False at supplier level create an event action → simple PL/SQL block that should fetch POs in Received status which have been received more than 24 hrs ago → close the POs create a DB task to schedule that event In the below post you can see how to create a DB task through which you can execute an event. Then you can create a schedule on top of that task. Schedule event action in IFS Cloud 21Rx | IFS Community Hi @Marcel.Ausan ,You ‘can’ schedule a workflow using a custom LU and good old migration jobs ;)Check my reply on below ideaTimer start event in workflow | IFS Community This idea was created to have the possibility of using Timer start event in Camunda, so it’s possible to schedule a workflow by it’s own. I wish IFS has already added in their roadmap. Hope it helps!Dam
Hi @GaSoGB, You can set the query parameters and api key as inline scrips and add them to the URL.A good example can be found in the IFS provided workflow finCurrencyTypeUpdate where it added the URL and the API Key as parameters.‘ Hope it helps!Damith
Hi @dsj , Many Thanks for your reply. As suggested in your idea, I have tried the below routing rule with JSON attribute, but it didn't work. Can you pls check and let me know if I have missed something. BR/ Manisha Hi @AccManisC, The notation mentioned in the idea is still not implemented in IFS as I’m aware, so it’s not possible to use it in routing rules yet.Instead, you can check if the value exists, as you you have done in other conditions.Search path: trygnoOperation: ex
Hi @AccManisC Evaluating JSON path is still not possible in IFS Cloud routing rules but I have already created an idea for this and it’s accepted by RnD.Please upvote this and comment with your business criticality to get the IFS attention.JSON support in Routing rules | IFS Community Best Regards,Damith
If you need to validate the scheduler formula, you can use below simple script which will output next 10 run date/timesDECLARE start_date TIMESTAMP; return_date_after TIMESTAMP; next_run TIMESTAMP;BEGIN start_date := SYSTIMESTAMP; return_date_after := start_date; FOR i IN 1 .. 10 LOOP DBMS_SCHEDULER.EVALUATE_CALENDAR_STRING('FREQ=DAILY; BYTIME=063000,120000,171500; BYDAY=MON,TUE,WED,THU,FRI', start_date, return_date_after, next_run); DBMS_OUTPUT.PUT_LINE('Next Run: ' || next_run); return_date_after := next_run; END LOOP;END;
Hi @NickPorter we have about 7 companies worldwide and if everybody needs 3 iterations at different times, we will have 21 jobs. 😀 Then I will try to standardise the scheduled times. Thank you a lot. 👍🏼 I think you don’t need to schedule 21 jobs ;)This formula should work for your need to schedule it on 6:30, 12:00 and 17:15 every weekdayFREQ=DAILY; BYTIME=063000,120000,171500; BYDAY=MON,TUE,WED,THU,FRI For more info, refer https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_SCHEDULER.html#GUID-A24DEB5D-2EAF-4C0B-8715-30DC947B3F87Hope it helps!Damith
@dsj fantastic, thank you. I had the encoded filename, but not the “filename=” tag. @heibde i saw that, but i’m not entirely sure how to get the etag, its not supplied as a response payload in any of the first 3 steps. I am using a * as a wildcard match, which seems to work. Me too. I also wasn’t unsure how to get the Etag and used If-Match = * worked for me too!(Later referred to the documentation and bit surprised by that 😁)
Hi @Link You can choose a custom schedule in the Schedule database task and give the DBMS Scheduler expression for your requirement.I think this expression would work for you :)FREQ=DAILY;BYHOUR=6,12,17;BYMINUTE=0;BYDAY=MON,TUE,WED,THU,FRI Check this topic for some good discussion on custom expressions in scheduled tasksScheduled Database Task between certain times | IFS Community Hope it helps!Damith
Hi @mdezzi Set the X-IFS-Content-Disposition header value as filename=<BASE_64_Encoded_file_name> and try. Hope it helps!Damith
Hi @hrdilshan. In addition to the solution by @Marcel.Ausan, try setting the layout in the Archive Property in the report rule. Haven’t tried myself it but it might work ;)
Hi @PamithK RIGHT_TRIM function removes the right-most characters defined in the set If you need to pick the first 100 characters, use SUB_STRING function.Function arguments:COLUMN_REF(TRANSACTION_INFO1),1,100 Hope it helps!Damith
Hi @bdoucette, We had the same problem in a different projection and had a hard time tracking the changes.Here are some tips on my lessons learned from the troubleshooting.buildplace logs is one way to check the breaking projection changes before it makes any impact on customer solution._projection_changes.log contains the information about what projections has been changed in the update. I checked one of our customer 23R1 log and noted your problem Since 23R1 introduced entity projections, new projection list is so long and it’s hard to ‘guess’ what’s the replacement.One suggestion is to compare the projection calls in debug console for the business flow in both versions to identify which projection is called in 23R1. Other than that, I don’t know if there’s an easy way to identify the changes. Regards,Damith
Hi @savasciftci You can transfer generated report to FTP using a report rule with action type Route To ConnectRead more here:Report Rules (ifs.com) Hope it helps!Damith
Hi @MWitczak You can Export/Import external file templates using the filetype ExtFileExpImp.Choose the parameter set according to your need. Hope it helps!Damith
Hello Hani, Glad to hear from you 😊 There were several good topics previously on this and I think this one will interest you more. Authentication error when connecting Excel to IFS via OData feed | IFS Community I tested that and seems it’s working. But only problem is you only can get data from one projection. I have done some research on this and found that using Azure API, you can build a proxy to perform the authentication and then you can directly call IFS projections from Excel or PowerBI. Check my blog post on how to set it up. https://dsj23.me/2023/11/06/creating-an-api-proxy-for-ifs-cloud-using-azure-apim/ Hope it helps! Damith Hi again @Hani I think I have missed the most important part of your question. Both above mentioned topics discuss to connect using client credential flow, not the authorization code flow with PKCE. Sorry for that. Regards,Damith
Hello Hani, Glad to hear from you 😊There were several good topics previously on this and I think this one will interest you more.Authentication error when connecting Excel to IFS via OData feed | IFS Community I tested that and seems it’s working. But only problem is you only can get data from one projection.I have done some research on this and found that using Azure API, you can build a proxy to perform the authentication and then you can directly call IFS projections from Excel or PowerBI. Check my blog post on how to set it up.https://dsj23.me/2023/11/06/creating-an-api-proxy-for-ifs-cloud-using-azure-apim/ Hope it helps!Damith
Hi @hhy38 It seems FND_NAVIGATOR stores navigator entries for Aurena client, not the IEE. I don’t have an exact answer, but I hope below queries will help you to build something Query to get the windows (Presobjects) granted for a permission setselect * from pres_object_grantwhere role = 'YOUR_PERMISSION_SET_ID' Query to get the window names and translationsselect * from language_text_translation a, pres_object bwhere a.name = b.po_idand a.lang_code = 'sv' -- Use your language code hereand b.pres_object_type_db = 'WIN' Hope it helps!Damith
It definitely helps @dsj! I managed to implement the code that I needed with the code error handling that was necessary. The only thing is that I didn’t want to handle all the exceptions using the same logic, that is what I initially wanted to avoid using WHEN OTHERS THEN for all the exceptions and use a WHEN [EXCEPTION_TYPE] instead. I managed to selectively use a different approach but I ended up using the SQLCODE function like this WHEN OTHERS THEN err_code := SQLCODE; err_msg := SUBSTR(SQLERRM, 1, 200); IF err_code = -20110 THEN [CODE_LOGIC THAT IS SPECIFIC TO -20110] ELSE -- Simple raise Other exceptions that are NOT -20110 RAISE; END IF; Would you say this is the best practice? Thanks! Hi @msurasky-price ORA-20110 is IFS defined exception. All IFS defined exceptions are defined in ERROR_SYS.A simpler way to do this isDECLAREBEGIN...WHEN Error_SYS.Err_Appl_Gen
Hi @msurasky-price Here you have declared your own exception. Exception block only will hit if you raise your declared exception. Since you are calling standard IFS method, only system/IFS defined exceptions may occur here.Use WHEN OTHERS since there can be different exceptions can occur during execution -- In this block we perform the actual change.DECLARE-- PARTTYPEERROR EXCEPTION; no need to declare exception [SOME_OTHER_VARIABLES]BEGIN FOR sale_part_to_update_rec IN ( [SOME_SQL_TO_PERFORM_LOOP] ) LOOP p0_ := NULL; p1_ := sale_part_to_update_rec.OBJID; p2_ := sale_part_to_update_rec.OBJVERSION; client_sys.add_to_attr(name_ => 'SOURCING_OPTION', value_ => sale_part_to_update_rec.SOURCING_OPTION, attr_ => p3_); client_sys.add_to_attr(name_ => 'RULE_ID', value_ => '', attr_ => p3_); p4_ := 'DO'; BEGIN IFSAPP.SALES_PART_API.MODIFY__( p0_ , p1_ , p2_ , p3_ , p4_ ); COMMIT; EXCEPTION
I have investigated the issue with the SFTP server and determined that we need to add the "PubkeyAcceptedAlgorithms" in the sshd_config file to establish a connection with the SFTP server from the IFS Cloud application using the private key. By doing this, we won't need to enable known host authentication. PubkeyAcceptedAlgorithms ssh-rsa,rsa-sha2-512 Glad that it worked. One thing to note that is, ssh-rsa is deprecated and that’s why the most probable cause for the failing before you change the sshd_config.Instead of changing the sshd_config, my suggestion is to use SSH2 RSA key pair which is more secure and compatible with later versions of openssh. Cheers!Damith
how did you generate the known host file using the below query if you disabled password authentication on the SFTP server? java -cp \ifs-fnd-connect.jar;\jsch-0.1.55.jar ifs.fnd.connect.ftp.SftpClient -CreateKnownHosts=KNOWNHOSTS -hostname=SFTPHOST -username=USERNAME -password=PASSWORD No, For public key enabled sftp servers, you can’t use this method to generate the knownhost fileIt took some time for me to find a way, but found out it can be simply done by using the ssh-keyscan tool in windows.On the application server, or any server which is whitelisted to access SFTP, use below command to generate the knownhost file. ssh-keyscan is included with windows 10 and above or or any OS with openssh installed. ssh-keyscan SFTP_HOST > known_hosts.txt I have added an idea to autogenerate the knownhost file automatically since it is hard with ip restricted SFTP servers to create the knownhost file from outside and it’s been a real pain in IFS managed cloud instances since we don’t have a
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.
