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
Have you enabled both password authentication and public key authentication on the SFTP server? Only the public key authentication is enabled in the SFTP server
This implies that the SFTP reader requires both the known host file and the private key to be uploaded to the SFTP reader configuration to ensure its proper functionality. Yes it is :)
Here’s a sample SFTP reader configured with key file authentication. Key steps you need to follow areSet the Authentication method to Identity file Upload the private key file, and knownhost file Enter the passpharase for the private key file Hope it helps!Damith
Hi @maheshmuz We have successfully created SFTP reader with private key-public key in IFS Cloud. Have you managed to create the knownhost file properly? what’s the error you are getting? Cheers!Damith
Hi @durette, In order to remove the database objects connected to an entity, you need to add a cleanup script (.cdb) to remove the included objects in the entity.You can use Remove_XXX methods in DATABASE_SYS to remove different types of objects.Check a sample script in this topichow to obsolete files in Git Hub in IFS Cloud | IFS CommunityThis helps to solve the invalids in the topic env.I’m not sure what’s the right way to remove an entire module. Tagging @Tomas Ruderfelt 😉 Cheers!Damith
Hi @kacperifs For that, you need to do a customization development which typically involves a developer. I hope you are familiar with IFS Cloud lifecycle for customization development. Otherwise check below link for details.Customer Solution Development - ALE Documentation For IFS Cloud Hope it helps!Damith
Hi @romsar Check your method is listed with this query select * from dictionary_sys_method where package_name = 'YOUT_CUSTOM_API' If it’s not listed, then the method is not added to Dictionary.One of the common cause for not updating the dictionary cache is the method name is longer than 30 characters. Check if that’s the cause. Hope it helps!Damith
Hello @dsj Still, by selecting the no parameter element from the combobox, I can’t find my method, which is present in the following path : IFS applications > IFS Customer runtime configuration component > my custom package Should I select a component in first? EDIT : I selected the component (CONFIG), still no sucess... ahh, it’s a custom method :)Have you added the custom package and method according to IFS standards?Make sure you refreshed the dictionary cache. Hope these topics will guide you to achieve what you needIs there a way to run Custom APIs as scheduled database tasks ? | IFS CommunityCustom Package within Schedule DB Task | IFS Community Hope it helps!Damith
Hi @romsar,Methods without parameters can be added as database tasks. Argument type should be set to No Parameter. What’s the method you are trying to ad as a database task?
Hi @WilliamRun Hope below topic will help you, but I’m not sure if it’s the recommended way of adding a new language :)Adding Croatian language (hr-HR) translations to IFS Cloud | IFS Community
Hi @dsj Do you have any guide or tips how to make it? You can do it with providing an expression for Enabled condition of the command controlClient Control Properties List - Technical Documentation For IFS CloudHere’s a very simple example which will enabled a button based on state Hope it helps!Damith
Hi @kacperifs, Unfortunately it’s not possible with page designer yet in IFS Cloud. If you need to add the command as a customization if you need to conditionally enabled. Hope it helps!Damith
Hi @JannetteC According to your code, file_name_ should be the path for the file. SInce you are in Apps10, you can use Batch_Transfer_Handler_Api to copy the file to a folder in application server and use the path.Read this post on how to fetch documents to a server folder and attach in the email https://dsj23.me/2017/03/20/include-additional-attachments-in-ifs-e-mail-report/ But a more future proof solution would be to get the files from edm file storage and attached to the email itself.See below topic on a nice example on this approach.Need assistance for sending emails with attachments triggered by an event. (23R1) | IFS CommunityFollowing blog aims for IFS Cloud but it should work for IFS10 as wellhttps://dsj23.me/2023/04/10/how-to-include-additional-attachments-in-e-mail-reports-in-ifs-cloud/ Hope it helps!Damith
Hi @Sandun1997 , If can’t find the information in the documentation, I usually check the plsql code where the report is generating since the parameters are set in the code. I checked Payment_Proposal_API.Order_Proposal_Advice_Report which I ‘guess’ how the report is ordering and seems only PDF_PARAMETER_1 and PDF_PARAMETER_2 is set there, so other values are empty for this report. Hope it helps!Damith
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.
