Hi @Dulan1987 You should find it in the Database Task window. Then schedule it to run for the entire schema. Hope it helps!Damith
Hi @bartlomiej.pobocha We have successfully implemented ORDERS (inbound/outbound) and DESADV (inbound) and the steps taken were similar to what you’ve described, so your approach is correct :)One thing to note that is we developed own java transformers instead of using standard IFS transformers since we found problems with the mappings and it was easier to do our own. Hope it helps!Damith
Hi @FIHENRICA,You are correct about the validation when entering the payment address. I wonder how you skip this check and able to enter longer or shorter account numbers. Could it be a basic data setup problem?/Damith
We are trying to avoid customizing the rdf files and rely on custom fields as much as possible to bring additional data into the reports.Process for modifying the report layouts is exactly as @Marcel.Ausan mentioned and something worth to follow is, not to modify the IFS standard layout. Instead, create a copy of the standard layout you need to modify and do the changes on that :) Hope it helps!Damith
Hi @Sarfraz Hussain IFS has a limitation where the object names should be less to 30 characters. In the IFS development tools, this is safeguarded via the developer studio where you can’t mention a Entity name longer than 26 characters. Check your database to see what table is causing thisselect * from ALL_TABLESwhere owner = 'IFSAPP' --or APPOWNER if it differes from IFSAPPAND length(TABLE_NAME) > 30AND TABLE_NAME LIKE '%TAB' Then you could find which table causing this. Hope it helps!Damith
Thanks @dsj for the response. That helped me as well. However, I have a similar situation where you can help. I agreed to a concept of implementing an integration between IFS and our support ticket system to automate the user management (creation, grant and revoke permissions, company, site, user group manipulation, etc.). But, the user IFSCONNECT doesn’t have enough privileges to manage the users. In this case, the solution is to grant IFSCONNECT with ADMINISTRATOR or individual roles (ugly, dirty and also is not recommended). If not, another approach is to make the inbound files to update an internal custom table, and execute a scheduled task (by appowner) to read values and execute separately (won’t be the perfect solution). Do you have any suggestion for me? Thank you. Hi bro,What about user impersonation, Is there any limitations you can’t use it?Otherwise, I vote for creating a background job and execute as appowner since it could be useful for logging the information on what
If it’s not solved by Sahan’s suggestion, try reinstalling IFS development tools (F1 tools) for APF developments and see if it works.To make sure you have the IFS plugin correctly installed for VS, you can go to Tools and check if IFS Data Set Toolbox is there ;) Cheers!Damith
Hi @hhy38 I suppose if you use PRAGMA AUTONOMOUS_TRANSACTION; in the function, then you could avoid this error. However, I think monitoring the http logs as @david.harmer suggested would be a better approach for such a requirement. Cheers!Damith
Hi @Ashni Nayanthara Is this related to Avalara integration?You may check the outbound routing rules related to Avalara and make sure they are enabled. Regards,Damith
Thanks a lot @Charith Epitawatta for the answer. Has this been fixed in IFS Cloud as well? In which versions? /Damith
Hi @RobMagruderLantronix It’s sometimes need to grant company/site access to IFSCONNECT since the integrations through IFS Connect runs as this user.One use case for this explained below thread.Change Initiated By user in Outbound Async Message | IFS CommunityInstead of granting IFSCONNECT the access, we took the approach to impersonate user within our code. However it’s not recommend to use IFSCONNECT as the user to authenticate IFS integrations since it’s a internal super user. You may create a new user and grant sufficient permission to invoke the integrations. Cheers!Damith
Hi @ZTC ZTC JGOTA How are you ordering the report?Is it from a custom menu or from the quick report window /Damith
Hi @hhy38 Probably it could be a bug in your version 😔I have done a test in cloud 23R1 and it worked fine for meCreated a routing address with parameterized URL created a routing rule Used your code block. Found out that the document name doesn’t matter Captured the request from the backend with parameter
Hi @hhy38 @flestephs Try below :)url_ := PLSQLAP_DOCUMENT_API.New_Document('URL_PARAMETERS');PLSQLAP_DOCUMENT_API.Add_Attribute(url_,'parameter1','/posts'); As I remember, the URL_PARAMETERS is the correct way to declare, not as url_params Cheers!Damith
Hi @rkurfman.vib Custom fields are saved after the main record and therefore you won’t see the values in the custom fields in your event.Therefore you need to create the event on the CUSTOMER_ORDER_CHARGE_CFT to validate the custom fields. Then the problem is accessing values in the main table since it will cause a mutation error.You could use PRAGMA AUTONOMOUS_TRANSACTION in the event action to avoid this ;) As a alternative approach, If your requirement is to make fields mandatory based on other fields, it can be also done via user/base profile using Conditional Fields.Hope it helps :)Damith
Hi @ronhu, If your report can be printed using the print dialog, then it’s possible to choose the local printers in the PC.I hope your requirement for printing to a logical printer bypassing the print dialog?It’s possible to install the print agent in the local PC and map the zebra printer to a logical printer as the same way you do it in a server :) Hope it helps!Damith
Hi @Mikael Nilsson If you are using the browser based authentication, then it should be able to authenticate instead of going to the login page again?I also noticed that IFS sets some cookies with the response to authorization end point.Keycloak cookies : KEYCLOAK_SESSION,Oauth_token_request_state, KEYCLOAK_IDENTITY - Stack Overflow maybe you could use them to make the SSO working?Confidential client from backend-API: then it will be authenticated as service user attached to the IAM client and I’m not sure if any impersonation is possible with this scenario. I’m also pretty much interested in this topic and please keep posted with your findings :) Cheers!Damith
Hi @Mikael Nilsson If your IFS is setup with same AzureAD, then you could create a public IAM client and then you could use the same authentication for your API call. Is that what you want to achieve? /Damith
Hi Sachini, IN_DIRECTORY is the SFTP directory where the external system is putting the files, which IFS should picked up from.To read files using SFTP and process in IFS, you need first identify what’s the BizAPI or PL/SQL method needed to be executed and create a routing address using that destination.Then you need to setup Inbound routing rule to identify the file (based on file content or location) and route to routing address created above.IFS documentation: https://docs.ifs.com/techdocs/Foundation1/040_administration/240_integration/300_ifs_connect/030_routing_rules_addresses/default.htm#Understanding_Inbound_routing i.e.If you are setting up a standard integration flow like receive invoice, receive bank payments ...etc, you could find example routing address and routing rules already defined by IFS. You can duplicate and create your own. Hope it helps!Damith
Check if the user you are using to authenticate is granted FND_CONNECT permission set.Cheers!Damith
Thanks @Trewon. That’s exactly what I was looking for.It was enough to add the DEBUGGER system privilege. SQL trace was not needed to get the trace. btw, if anyone is wondering how to read the IFS trace in postman, have a look in the postman visualizer script I’ve built ! https://github.com/damithsj/IFSCloud-Postman-Trace-Visualizer Cheers!Damith
Hi Udanee 👋 Seems that this error is due to restrictions in the firewall. Talk to your network team and ask them to whitelist the boomi platform and postman IPs.Probably below links will help to find the IPs to be whitelisted.boomi: https://help.boomi.com/bundle/atomsphere_platform/page/c-boo-Hostnames_and_IP_Addresses_for_Connecting.html Postman web: https://support.postman.com/hc/en-us/articles/10667371814679-What-IP-ranges-does-Postman-use-to-send-requests- Internal user IPs should be whitelisted in order to allow access to IFS Cloud .That’s why it’s possible to make the call using an installed Postman client on their PCs :)Cheers!Damith
@y.veerabrahmam Does your certificate has a certificate chain?If yes, can you try to add all certificates to the keystore and see if it makes a difference? Regards,Damith
Hi @y.veerabrahmam Sorry for the late reply. Here are the steps I followed to make the ssl works with routing address * generate pfx file using opensslopenssl pkcs12 -export -in cert.pem -inkey "privateKey.pem" -certfile cert.pem -out myProject_keyAndCertBundle.p12Give a password* Create a new keystore (Import keystore file), provide same password as you added above In the routing address, add the additional parameters pointing to the keystoressl:KeyStoreId=testssl:KeyStoreType=PKCS12 Hope it will help to go through your setup and identify any missing steps. Cheers!Damith
Have you tried the Oracle REPLACE functionEg:select REPLACE ('My text with "doublequotes"', '"', '\"') from dual Haven’t tested below but hope it works :) json_ := '{"tasknr" :"&OLD:TASK_SEQ", "descr" : "' || REPLACE(&NEW:DESCRIPTION, '"', '\"') || '"}'; /Damith
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.
