Hi @GLEEMMANUELP , Please check the forum post https://community.ifs.com/technology-all-about-the-nuts-and-bolts-that-make-it-work-50/create-new-document-with-empty-file-865#post3426 It has a complete script to create document revision, check-in and attach to Inventory Part. Hopefully it could work for you.. Requirement in that thread to create an empty document. You need to uncomment EDM_FILE_STORAGE_API.Write_Blob_Data (objversion_,objid_ ,file_data_ ); to get the fully functional script. Good Luck!
Hi DSJ, Thanks very much for your reply. That code is helpful, but what modification should I make to load a real document like a “.PDF” and not an empty one. I assume that, the document is empty because the BLOB variable “FILE_DATA_” is empty. So which function/API should I use to get it from a given file on my desktop for example? Thanks again in advance. Hi @GLEEMMANUELP , Yes, you need to have the file as as BLOB into FILE_DATA_. There are many options to load the file to oracle database and the best approach depends on your requirement. If you want the file to load from user PC, and need to have a user interface, then you can use create a .NET or Java application to load the file and use Access Provider to execute IFS code. Otherwise there are several options in Oracle on how to load a file. See the below document to get an idea. https://blogs.oracle.com/searchtech/loading-documents-and-other-file-data-into-the-oracle-database Cheers! Damith
I need to know which users have permission to create a new Master Part. One way to see which users has grants is the Presentation Object Grants window. Form there you can output the results. BR, Damith
Hi @Pardeep Saini , As André already mentioned, you can use already existing oracle verification function or create your own one. Your requirements closely match with ora12c_verify_function except for uppercase. Password requirements of this function as follows. Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dbseg/configuring-authentication.html#GUID-F09749BF-2881-4EE5-B59D-041E4796BAC4 Following steps need to set this up in IFS Oracle Profile, create a new Oracle profile or modify existing and add the verify function. System parameters, set the Default profile for new Oracle users to the above. If you need to change the password complexity of existing users, you can do that in Oracle Users window. There are several other oracle built-in functions as well as you can create your own one. Read more on oracle documentation in previous reply. Hope it helps! Damith
I have created a simple integration with Clickatell SMS platform .It was done in Apps 10 using REST connector. I hope similar configuration should be possible in Apps9 as well. Pls read my blog post for more details on how to configure the SMS integration https://dsj23.me/2020/04/06/clickatell-sms-integration-with-ifs/ Hope it will be useful. Cheers!
Hi Suni, Nice to see you around 🙂 One reason you are getting the # is could be due because those labels has any font properties (Bold, Italic) set. As far as I know SimHei does not support font properties. Why font mapping are not required for Arabic: It’s because Arial font supports Arabic characters. See the full list of supported character codes here https://docs.microsoft.com/en-gb/typography/font-list/arial Hope it helps. Cheers! Damith
I can connect using SFTP_Reader and FileZilla works both directions. Wireshark does not show any activity so nothing in the SFTP server logs. There is nothing in the connectserver logs - from the documentation I gather that the connectserver is for incoming. yes, you are correct. connectserver logs is for incoming. You should look in the j2ee for sender logs. Check ifsapplog-*.log and ifsalert-*.log to see if you ind any interesting information there. I once got stuck with the SFTP sender setup and created attached java code to simulate the IFS sftp sender connection. Hope it could guide you also to solve the issue. Change the SFTP parameters in getClient() to your sftp details, compile and run from the application server machine. at least it will give the ‘real’ error message which then can investigate further. below is how to compile and run the java code Cheers! Damith
Hi @Alan Gillespie , Yes, there ‘s a high possibility of this error correlated to the SFTP sender error, and hopefully someone from IFS Technology will provide a proper explanation or you could log a case to IFS support. Have you tested SFTP sender with a integration scenario than the Routing Address Test option? Maybe it works after all? If not, interesting to check the error message in the application message. Regards, Damith
I have created a IFS connector for WSO2 ESB and you can find more information on https://github.com/knakit/wso2-esb-connector-ifs. Please check the github repository of pm me if you like to hear more. /Damith
Hi @savasciftci , Check your mail sender if it’s setup with content type text/html That could be the reason behind yo are not getting the html formatted mail body
We also have the same problem and figured out that it happens when a Load balancer (SSL passthrough) is in place. There seems to be a issue with HTTP sender when connecting to ssl endpoint and our finding is below. If there’s a WORK_TIMEOUT is not defined or value is > 30 (default connection timeout), I get error java.net.ConnectException: Connection timed out: connect If WORK_TIMEOUT < 30, get the error STUCK thread while executing native sender: 'HTTP_SENDER2' but there’s no stuck threads created! weird thing is application message (might) successfully processed in a retry. Has this been noticed by others? We are in a serious situation due to this error since our integration worked fine in Dev environment where there’s no loadbalancer and in TEST it fails consistently. Any feedback would be really appreciated. App version: APP10 UPD6 BR, Damith
We also have the same problem and figured out that it happens when a Load balancer (SSL passthrough) is in place. There seems to be a issue with HTTP sender when connecting to ssl endpoint and our finding is below. If there’s a WORK_TIMEOUT is not defined or value is > 30 (default connection timeout), I get error java.net.ConnectException: Connection timed out: connect If WORK_TIMEOUT < 30, get the error STUCK thread while executing native sender: 'HTTP_SENDER2' but there’s no stuck threads created! weird thing is application message (might) successfully processed in a retry. Has this been noticed by others? We are in a serious situation due to this error since our integration worked fine in Dev environment where there’s no loadbalancer and in TEST it fails consistently. Any feedback would be really appreciated. App version: APP10 UPD6 BR, Damith =====Update about this issue:======= Connection timed out exception was found to be an issue with our network where it blocked
Hi, I’m on IFS 9 and I would like to send a post request to a routing address. IFS 9 doesn’t support destination type REST, so I need to use HTTP. I know the endpoint, and from postman I have copied this HTTP request: When I try to call this endpoint from IFS using a routing address I get “Internal server error” back. I know the headers and the message are correct, but IFS doesn’t seam to read them correct. How could this be done? Any help is very much appreciated. Hi @krestensb, Can you change your application to accept requests with Content-Type: text/plain header? Seems IFS HTTP sender tags request with Content-Type: text/plain header by default. /Damith
Seems your application accepts only Content-Type: Application/json Usually, a HTTP request has only one Content-Type header parameter and it depends your application how it’s used. What I think is your application accepts only the first header field. I just tried your api with text/plain content type header in postman and got the same response getting from IFS. /Damith
Hi Artha, I also had troubles with RSET sender provided authentication types but you can always add the http headers from plsql code. It works handy and what I usually do is copy the http headers from postman and add in the code below example is to clickatell SMS REST api. plsql_rest_sender_API.Call_Rest_EndPoint(rest_service_ => 'SMS', xml_ => bxml_, callback_func_ => 'P_L_S_Q_L_Rest_Test_API.REST_callback_Test', http_method_ => 'POST', http_req_headers_ =>'Content-Type: application/xml,Accept: application/xml,Authorization: YOURAPIKEY'); Complete example can be found in https://dsj23.me/2020/04/06/clickatell-sms-integration-with-ifs/ Hope it helps!
Elaborating the answer by @Tomas Ruderfelt , here’s what I have done in a similar scenario where I had to process the reply from an external web service in Apps9 without doing any code modification In my scenario, I’m getting the currency rates from an external API and update IFS currencies. 1: Create an event on FNDCN_APPLICATION_MESSAGE_TAB based on STATE field Event Action: remember to add proper conditions just to trigger the action only for your integration, and state = Finished This calls another event in a background job. Reason for taking this approach is the message reply is not commit at this time so we can’t access it directly from the event action on FNDCN_APPLICATION_MESSAGE_TAB Code: declare event_enabled_ BOOLEAN := Event_SYS.Event_Enabled('Event','CURRENCY_UPD_EXECUTE'); parameters_ VARCHAR2(32000); event_msg_ VARCHAR2(32000); id_ NUMBER;begin IF event_enabled_ THEN Fnd_Session_API.Impersonate_Fnd_User(fnd_session_api.get_app_owner
Thanks, I have been looking for this solution for a very long time. My pleasure to help!. In Apps 10, there’s a new feature to call a PLSQL method directly to process the response so you don’t need this workaround :) /Damith
Hi @krestensb , That option is to select HTTP sender defined in IFS Connect > Setup IFS Connect > Connector Senders. You can have multiple HTTP Senders with different configurations But it will have the same implementation. As far as I know, HTTP sender by default sends with POST method. I’m also glad to see if this supports GET. As an alternate, you can write your own sender implementation. Please refer IFS F1 documentation for transport sender development https://wit.ifsworld.com/f1docs/apps9/Foundation1/050_development/024_integration/015_connect/060_transport_connector_development/010_connector_sender/default.htm Cheers! Damith
Hi @balu_sms , IFS supports Gmail out of the box for both sending and receiving emails. As @Tharindu mentioned, MFA should be disabled in the Google account level to start with. Here’s a short guide to setup Gmail as the mail reader/sender in IFS in Apps10 Enable POP/IMAP forwarding in Gmail Mail sender requires POP download and Reader requires IMAP access enabled. More information can be found here https://support.google.com/mail/answer/7126229?hl=en IFS Mail Sender configurations IFS Mail Sender configurations IFS Mail Reader configurations IFS Mail Sender configurations Hope it helps! Damith
Hi @chrisplant , That depends on how the error is triggered. If the error is triggered from PLSQL or inside an event action, then answer is No, If it’s triggering from a from a Custom Menu of PL/SQL Block type, then you can use the option refresh window after execution to force refresh data in the screen. Cheers!
Hi @henfri , There are set of methods in batch_transfer_handler_api to download set of documents from IFS Document repository to a shared file location. Below script will do the work for you :) change the where condition to filter your documents. Here, F:\fileshare\temp\ is a folder located in IFS Middleware Server. If you are need to download file to a shared folder, make sure IFS middleware server has full access to that location. -- Created on 2019-07-03 by DSJdeclare -- Local variables here error_msg_ VARCHAR2(32000); file_name_ varchar2(32000); CURSOR get_rec is SELECT * FROM edm_file_storage where doc_class = '109';begin -- Test statements here FOR rec_ IN get_rec LOOP file_name_ := edm_file_api.get_file_name(rec_.doc_class, rec_.doc_no, rec_.doc_sheet, rec_.doc_rev, rec_.doc_type);
Hi @eqbstal, It’s a nice hack you have done If it does’t work, you can always go for a xsl transformer where you don’t need developer studio. This transformer in stackoverflow worked for me in App9. https://stackoverflow.com/questions/24122921/xsl-to-convert-xml-to-json Duplicate any xsl transformer and create a new one attached is the xsl copied from above thread, nothing else ;) Then in the routing address add the transformer. Here I used the file out but HTTP should work. Give a try and let me know the feedback. Cheers!
Thanks for taking some of the magic out of this process! I was not aware that the .xls file is just a XLST script to format XML into somthing else. w3schools.com has a tutorial, and I’ll go home and read it and see where that brings me. It don’t seem to complicated. https://www.w3schools.com/xml/xsl_intro.asp I don’t think there will a need for any java code. Yeah, it’s not hard at all to play with xslt transformer. For the record, java transformer ‘really’ don’t need the developer studio also. I’ll try to find an example and post it soon
Hi @krestensb , Try to define additional header parameters in KEY=VALUE format. Eg: Content-Type=application/json
Hi Damith, I’m trying to test calling a custom API with a SOAP message. As I’m therefore not using a BizAPi or Handler, how would I go about testing this? This is a new area to me so any advice would be brilliant!! Hi @RyanIbbitson , Can you please explain what you meant by custom API? Is it a PL SQL method which you intended to call via a routing address (valid for App10) or any other business flow? /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.
