Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Hi All you lovely helpful folk, I’m trying to create a RMB menu from the shop order operation tool to the Quick Report In Work page in the service and maintenance module. All our manufacturing tools have a one to one relationship with a serial object and are named exactly the same, therefore the TOOL_ID always equals the MCH_CODE - so the user see’s no difference.However when I’ve created the below custom menu I get the following error message when trying to use it - is this just not possible in our Apps9 update 17 IFS or do I need to do something else?    

For a couple recent projects, we have made Projections to interact with IFS through REST calls.  In other words we don’t have to connect to the database to call their APIs.  At the moment it has been very basic.  However, I could see in the future where we want to have logic on some of these projections.  What options do we have when it comes to the “IFS Customization layer”? At one point I thought it was going to be IFS Developer Studio that would allow you access to integrate with the APIs since they have the “Core” logic.  If that is not going to be a choice, we will want to learn what best practice is when it comes to needing custom database logic to use these Projections.  This could become extremely important as we start converting programs to be used with Aurena. 

Hello,Our current version is Apps 10 Upd 9.I recently created two custom projections to be able to utilize REST to load data.  One of them worked flawlessly with no extra interaction.  The second one threw a ORA-6550 error.  Upon looking into this error I found this in the odp-default-log.log file:com.ifsworld.fnd.common.exceptions.DatabaseException: Failed to execute the generated database statement …. more stacktrace not displayed …..Caused by: java.sql.SQLException: ORA-06550: line 1, column 35:PLS-00302: component 'NEW__' must be declaredORA-06512: at "CHIE1APP.PROJECTION_CONFIG_UTIL_API", line 174ORA-06550: line 1, column 7:PL/SQL: Statement ignoredORA-06512: at "CHIE1APP.PROJECTION_CONFIG_UTIL_API", line 156ORA-06512: at "CHIE1APP.PROJECTION_CONFIG_UTIL_API", line 179.Investigating that API it is trying to call my logical unit _CLP.New__ method.  I have confirmed that the _CLP package is created and has the .New__ method.  There are no compile errors on the _CLP package or BODY. 

I am trying to see the total records remaining to count subtracting the records that have been received this year. below is the SQL i am using and i get the same number of  records with out excluding the records that were received this yearexample what i am seeing using my current SQL 21 records 6 received this year column should read 15 records but it is still reading 21 records SUM(CASE WHEN RECEIPT_DATE > to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' ) and LAST_COUNT_DATE > trunc(to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' )) + ( 1 - 1/ ( 60*60*24 ) )THEN '0' ELSE '1' END) Thank you for any help

Ok I have been working with this UD17 since June and here is what I am experiencing.I have a 3rd party wildcard SSL that supports TLS1.1 & TLS1.2I have verified the certificate is not expired.When I apply the UD17 to our current UD14 environment and uncheck SSL - the update applies fine.When I check SSL and use either a self-signed cert or apply our wildcard cert, I get an error. Finalize process IFS Middleware Server 90.23.0web-config-weblogicUpdate middleware serversError in Ant-script: server\install_fndmws.xmlReported error is: The following error occurred while executing this line:D:\ifs\extsvr\SANITY\repository\server\install_fndmws.xml:457: Java returned: 1 I have verified the Oracle Inventory is clean. I have set the following SSL:Cipher Suite = ALLProtocol = ALL -TLSV1.2 Does anyone know why the SSL wont apply to UD17?Were there any significant changes to SSL in UD15 or UD16? Truly appreciate any feedback.Marjie

Hi Expert,We can’t access login to IFS Application 10 after installed application on oracle linux server.Could you help or suggestion how to solve the error, please.Please see the error in the attachment file.

Is there a way to automatically get the current version on a a given FSM TESTinstance for a Managed Cloud customer? By automatic I mean, by an http request (eg api) that could be run by a script?

Hi all, We experience a slower performance on our Test Environment, and when looking into what could have caused this, we ran into below query: SELECT 1FROM (SELECT M.APPLICATION_MESSAGE_ID,XMLCAST(XMLQUERY('$mb/*:Envelope/*:Body/REPLICATION/SENDER_MESSAGE_ID' PASSING XMLTYPE(B.MESSAGE_VALUE, NLS_CHARSET_ID('AL32UTF8')) AS "mb" RETURNING CONTENT) AS NUMBER)SENDER_MESSAGE_ID FROM FNDCN_APPLICATION_MESSAGE_TAB M, FNDCN_MESSAGE_BODY_TAB B, FNDCN_APPLICATION_MESSAGE_TAB QWHERE M.STATE = :B2AND M.APPLICATION_MESSAGE_ID = B.APPLICATION_MESSAGE_IDAND Q.QUEUE = M.QUEUE AND Q.APPLICATION_MESSAGE_ID = :B1AND B.SEQ_NO = 1ORDER BY M.APPLICATION_MESSAGE_ID DESC FETCH FIRST 100 ROWS ONLY)WHERE SENDER_MESSAGE_ID = :B3 Anyone having any idea what this query is doing? We see this query on our two environments that have UPD9 installed, not on the environments that are still on UPD7. 

Hi, I used Application Server Task for mail Quick report and use reoccurring schedule patterns but it sent mail only once but Application Server Task status is still Waiting but not working. Please guide me for this issue.   Regards Shekhar

Hi, We created an Email type Custom Event Action using PDF_REPORT_CREATED Event to send out Customer Invoices. We are using the standard IFS report in Apps 10. While the Custom Event is firing, we aren’t receiving the correct invoice PDF. Instead the following email with a corrupt looking PDF is getting sent out:The file cant be opened and gives the following error message: The invoice PDF inside the IFS report archive looks right and can be opened. Also, the above attachment come across correctly when we sent it manually using the Email option in the Print Dialogue:Notice the subject, message and email sender name look differentHas anyone come across this issue before?Does this anything to do with how the Custom Event Action creation?TIA,Srikanth

Hi all,Is there a way to receive multiple tables in one command ?E.g.sql=”select...  ;select...;  “dt = cmd.ExecuteReader();dt.NextResult();dt = cmd.ExecuteReader(); 

When we have a delivery note produced with several lines and it goes on to the second page, I can’t seem to prevent the bottom line on the first page being split. Half the line could be on page one and the other part of the line could be on page two. In report designer the table that is being split is SOURCE_LINE. Is there a way of preventing this table/line being split between pages

Hello, Has anyone come across and resolved this issue?  Our user reported the following: I am creating a Custom Navigation Link to go from a Business Opportunity to the Customer - CRM page passing the Customer ID Parameter.  In UPD7, i had no issues with this because both sides of the equation were using the Aurena Field names Source and Destination parameters:  In UPD9, I am having an issue with it because on the destination side they are using the Oracle Field which does not pass correctly into Aurena. Unfortunately, when you leave the field like this, the search doesn't work for the new page.  Thank you,Joann

HiI hope everyone must be enjoying good health. following are my two questions which is not clear to me: 1- Is CxBP is mandatory to purchase by customer? if yes then Why?2- Can CxBP use CxBP without the involvement of IFS Partners? 

We are trying to update our wildcard certificate that expires next week to our IFS 10 Update 10 instances. I have tried multiple formats of the certificate including: .pem, .crt, .pfx, .p12 and more. I also have tried with just the certificate and also the certificate with the whole certificate chain included in the file. Every time I try to reconfigure the middleware server with the new certificate it always comes back with: “Unable to initialize SSL environment, returned 28845” and “Client SSL handshake error, Handshake returned 29005”

Hello to all,I wanted to know if (like in custom menus) we are limited to a number of characters in the SQL query in the creation of a Quick Report?I know that in the custom menus we are limited to 4000 characters. Thanks in advance!  

We are currently looking at crossing over to single sign on.the current windows sign on users the users email account but ifs uses initial and surname. to convert to single sign on will i need to recreate all the user accounts so that they use the active directory account name  or can i go in on mass and script the change?

Hi, is there a working POC or example of how to get Postman working to query the REST API endpoints with OAUTH 2 authentication?It looks like Postman doesnt support the response_type oauth parameter that IFS seems to expect.When doing an OAUTH token request, it comes back as “not supported”.I’ve seen a few others with this issue but no answers.The entire documentation system for the IFS REST API’s is very difficult to navigate and extremely bare on examples and pre-requisites. Seems to assume a lot of pre-req knowledge. 

 Hi,there is a post regarding FTP transition to Secure File Transfer Protocol (FTPS).   Since I cannot post my question there, I ask my question here.Does this change mean only has impact to access IFS file transfer server(ftp://ftpeu.ifsworld.com/[customer-id]?OrIt has impact to all ftp access from IFS Application, i.e., all ftp-server have secure ftp? If it applies to no. 2, what is the impact if we cannot provide no.2 by the deadline time (21 June 2021)? Look forward to your feedback. ~Juni      

I’m trying to utilise the plsql_rest_sender_api.call_rest_endpoint method passing the CLOB.  As soon as i try to follow the documentation to add url parameters the method fails with wrong number or types of arguments in call to ‘CALL_REST_ENDPOINT’.My problem is, if i don’t use url parameters then i’ll need to set up multiple routing addresses for each specific endpoint.  This will cause issues when the endpoint changes from test to production as i’ll need to change them all.Has anyone managed to utilise the url_params_ functionality within plsql_rest_sender_api.call_rest_endpoint ?

Recently we have uninstall Internet Explorer 11 from our client machines and started using Microsoft Edge as the default browser. then we are getting this error when try to open IFS EE using the Edge browser.as a workaround we are currently using Google Chrome with IFS Add-on.but It would be really helpful if anyone share a solution or any workaround to use the new Edge Browser? is there any add-on for Microsoft Edge as well?Thank you!

Is there an API that can be called to get a customers price for a part using the pricing hierarchy (Campaign, Agreement, Price List, Sales Part)? We are using Apps 10 V 10.

When try to send email from Order report dialog print job get state “ERROR” but he application message is in FINISHED state.   can send email through MAIL_SENDER1 using routing addresses In this environment cannot schedule quick report as well. Application server task get FAILED with the same error message  

Hi,Is it possible to duplicate a configuration context? (App 10 - Aurena)For example, the customer creates context ‘CompanyLayoutX’. They adjust the layout as per their own requirements. Then they create a new company and want to copy the page layout for some pages into a new context.Best Regards,Yashodha.

Hi - we’re starting our IFS Aurena implementation, and we’ll be using ClickLearn Attain for all of our end user content. I understand that you can link to ClickLearn content directly from IFS. Has anyone done this, or know how to do it? Our implementation partner is unfamiliar with what is required, and I can’t find any information anywhere else. We are using IFS cloud managed services. Thanks in advance!