Some tips for IFS Cloud integration development and troubleshooting...
Quick Tips for IFS Cloud Integration Development and Troubleshooting
How to Include additional attachments in e-mail reports in IFS Cloud
Include additional attachments in IFS e-mail report is one of the top posts in my blog and received many good comments. One of the questions was that the methods used here are not compatible in IFS Cloud. Script used in above post was developed for Apps8. By that time, Command_SYS.mail has limited capability of handling attachments.... Continue Reading →
Automate IFS Printing via PL/SQL
Automatically printing an IFS report during a business transaction is one of the most common questions asked by customers. In this post I've described the basic PL/SQL logic which needs to be written to automate report printing without popping up the print dialog.
Import Media Files with IFS Connect
IFS Connect is a simple integration framework yet you can do pretty nice things around it. This blog post explains such a trick done with IFS Connect for adding Media items into IFS and attach to a work order.
Using Functions in Oracle SQL
Oracle subquery using WITH clause is a popular choice among the developers. From Oracle 12C it's possible to define PLSQL function inside WITH clause. It's a handy feature which is really useful when making complex queries
Tips to avoid mutating table error in IFS event actions
Tips to avoid mutating table error in IFS event actions
Scheduling a Custom PLSQL Script in IFS
One of the common question we get around IFS tech stuff is How to schedule something in IFS? Well, if the process you need to schedule can be trigger by calling already existing PLSQL procedure, then you are in luck. You can define a new Database Task and schedule the execution of that task. But... Continue Reading →
Clickatell SMS Integration with IFS
This post is a reply to the IFS forum discussion which questioned about SMS integration with IFS. I did a simple POC for this and surprisingly it worked so I thought it will be a good post to return to my blog after some time. Clickatell is world leading SMS platform and supported in many... Continue Reading →
How to use DBMS_XMLDOM to create XML from PL SQL
This example shows how to create an Oracle XML object using DBMS_XMLDOM package. It includes XML declaration (Version and Charset)XML namespaceLooping through a cursor to add recursive nodes PART_CATALOG table consists of records in below structure Part_NoDescriptionUOMTEST1test1pcsTEST11Test 1pcsTEST111111VIAL DECLARE L_XMLTYPE XMLTYPE; L_DOMDOC DBMS_XMLDOM.DOMDOCUMENT; L_ROOT_NODE DBMS_XMLDOM.DOMNODE; PARTS_ELEMENT DBMS_XMLDOM.DOMELEMENT; PARTS_NODE DBMS_XMLDOM.DOMNODE; PART_ELEMENT DBMS_XMLDOM.DOMELEMENT; PART_NODE DBMS_XMLDOM.DOMNODE; PART_NO_ELEMENT DBMS_XMLDOM.DOMELEMENT;... Continue Reading →
Include additional attachments in IFS e-mail report
If you are in IFS Apps10 or in IFS Cloud, please check the new and improved version of this here: https://dsj23.me/2023/04/10/how-to-include-additional-attachments-in-e-mail-reports-in-ifs-cloud/ One of our customers came up with a bit of a challenging requirement. Upon emailing a report to their clients, they need to attach documents connected to that record instance along with the mail. To... Continue Reading →
DSJ's Blog 