@NickPorter Thanks, Nick. We are running on UPD17 which I believe was the last one for APPs9. I still need to check in more detail what is happening in the background but it becomes difficult as if it's not caught in time the system becomes almost unusable and SQL queries take forever. Normal RAM consumption is about 60% of the total ram. Thanks for the tip, I will trawl the app logs and see if I can spot anything else @NadeeshHerath I have noticed but will have a look. How can I check for blocking sessions?
@paul harland Thanks for that works perfectly for the sending address! Would you be able to help with an example of how I could add an attachment stored in the EDM repo (File based)? @cwright yep, that’s going to be a lot harder! IFS uses a format &PDF_FILE when printing reports etc. So you could start by trying that. Obviously though, your file may not be a PDF, among other issues. You say it’s file based - that makes it harder still (compared to database storage). Honestly even an experienced analyst would need to spend several hours exploring how that might be done. A path to the file is going to be somewhat easier because that’s just text that could be generated somehow inside a parameter. Hi @paul harland thanks for the information, is that to say it can only really be achieved using custom PL/SQL packages? If so you would have an example?
@paul harland Thanks for that works perfectly for the sending address! Would you be able to help with an example of how I could add an attachment stored in the EDM repo (File based)?
Hi @paul harland Due to my limited knowledge I find it difficult to work with more complex PL/SQL and have tried such and event action. If it is possible using routing rules that would be useful for me to see. If you can provide an example of using both routing and PL/SQL that would be massively helpful though.
@dsj Thanks for that information, do you have any recommendations for handling column names, eg my API is expecting employeeId and the application message includes NEW_EMP_NO, also the application message includes fields I don’t want , anyway to exclude them?
@GPIE I tried to use custom attributes but they only accept IFS PL/SQL APIs with parameter fields from the IFS Database. I need to insert a ‘hard-coded’ API key supplied by a 3rd party to send with the post to the 3rd Party’s API.
Hi @cwright , Here’s a simple example on how to route event response to IFS Connect 1. Event: Fires when any change to Description field 2. Event Action: Type = Application message 3. Create New Outbound Routing Rule Route From: APPLICATION_MESSAGE Queue: NOTIFICATIONS Routing Condition: MESSAGE_FUNCTION = [EVENT_ID] Routing Address : In this example I use File Connector. Output XML for this example looks like this Note that it contains the Fields we selected in the Event What you have to do Create a Routing Address of type HTTP to send to your API Create a transformer if necessary. Cheers! @dsj I have been able to start implementing and testing this. I am having to use an XML to JSON transformer which seems to work when I output to a file and review the contents. However what I am struggling to do is include additional parameters as I need to send an APIKey and an action with the post . I have tried using the additional headers but that doesn’t seem to work. Can you anyone
I resolved this issue, I wasnt selecting from the drop down and typing application message which caused my issue
Hi @cwright , Apps 9 built in HTTP sender is capable of sending HTTP POST with headers. Is this OK with your API? It would be nice to know what kind of input your API expects. @dsj thanks yes i think so, but I was hoping for a working example with screenshots, is that anything you could share?
We have recently upgraded to IFS v9. I do not have the greatest of expertise when it comes to building PL/SQL packages and want to avoid using external consultancy for help with that, so IFS connect seemed like the obvious choice.
Hi Subash, Thanks for getting back to me . Yes I am using and MDM solution, Airwatch via Vodafone and linked to VPP.
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.