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

In one of our IFS8 environment we are facing the issue “Unable to open saved pdf file from crystal web service” We have tried the fresh crystal config and ifsprint user grants but no success. Please Suggest.  

Version - IFS2003 We have a user who often exports Quick Report Navigator Crystal Reports to excel using the Export icon. On his old laptop, he has the option to export to MS Excel 97-2000 whereas the new client build only has older options (Excel 5.0, Excel 7.0, Excel 8.0). 97-2000 gives better formatting of data into Excel. We know that the F1 Runtime part of a client install loads Crystal runtime components onto the client and we think we have installed something else on is old laptop in the past to give him the 97-2000 option but don’t know what. We have compared like with like and cannot see a difference. Any ideas where the dlls might be that give him the option for Excel 97-2000? Thanks in advance.​   What we want:   What we get when we install IFS:  

We have split from our parent company, and since disconnecting from there network, IFSEvents has stopped because it cannot use their mailhost. Where do we set the Mailhost for IFS Events to use to send emails?   Yes- we are that far behind the times with IFS2003!

We noticed that Dynatrace APM is affecting the IFS EE client download.  Reason behind this is due to feature called RUM (Real Time Monitoring) in Dynatrace and it automatically injects a javascript tag to each html file in the application it monitors.   IFS client runtime contains a html file named employeedata.htm and it’s included in the manifest in group Ifs.Application.Person. With RUM enabled, file content is modified dynamically so clickonce reject downloading the person.dll meaning IFS forms depending on person.dll will not work. As a solution, a custom rule can add in Dynatrace settings to avoid injecting Javascript to this particular file. Dynatrace rule to do not inject JavascriptCheers!

Crystal report developed and executes successfully outside of IFS. Report is using a custom developed IAL as its data source (access granted to appropriate permission sets) When copy Crystal Report to server and try to preview in IFS an error is presented: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object.    at Ifs_ReportService.GetSavedPDFReport(String FileName, String ParameterValues, String LangCode) in c:\inetpub\wwwroot\IFSCRWebSetupIFST_3\App_Code\Service.cs:line 244    --- End of inner exception stack trace ---  No actions were executed. Other Crystal reports work fine which would rule out issues with the IFS Crystal Web Service. Does anyone have any suggestions to overcome this error?  Thanks in advance Shaun  

We currently send ORDRSP (order acknowledgements) to our EDI customers. In reviewing the ORDRSP XML file, I noticed that all items on an order are included, regardless if there has been a changed or the item has been shipped.  Our current version of IFS is App9 and we are looking to understand the following: Is there documentation on what drives the ORDER_LINE_RESPONSE_TYPE values of: Changed  Accepted without amendment Is there a configuration setting within IFS that would prohibit sending a shipped complete line in an order acknowledgement (ORDRSP)?  Right now, if an order acknowledgement is generated, the ORDRSP file includes the shipped completed line item and the ORDER_LINE_RESPONSE_TYPE is “Changed”.  

Hi, When will it be possible to override/overtake fragments? This is a serious hurdle when it comes to porting over customizations from EE to Aurena.   Kind regards, Sindre Tellevik

We have a user that would like the System Info added to their context pane, been through the security settings and can’t seem to find it anywhere. Does anyone know how to add this for a user?

Is there someone out there that have experiance of this tohether with IFS Applications

Currently we receive an error each time our scheduled task for Update Purchase Lead Time has to perform an update. If no update is needed it runs and the background jobs states it’s ready. Otherwise when it needs to perform an update we get the error “ ORA-00060: deadlock detected while waiting for resource ORA-06512: at "REST1APP.TRANSACTION_SYS", line 1632 ORA-06512: at "REST1APP.TRANSACTION_SYS", line 683 ORA-06512: at "REST1APP.TRANSACTION_SYS", line 1226”   See attached document as well. Has anyone else run into this? 

There are two types of temporary tables in Oracle. They are Global temporary tables and Private temporary tables.   Private Temp Tables:   Private temp tables exist from oracle 18C onwards. They exists in the memory and do not have physical objects in the database. They exists during the session and after a re-login or in a new session it will not exists. Following syntax can be used to create a private temporary table.   CREATE PRIVATE TEMPORARY TABLE ora$ptt_customer ( customer_id NUMBER, name VARCHAR2(20) ) As you can see we have to use ora$ptt identifies when creating a private temp table. If we want to remove the table after the commit we have to use the  “ON COMMIT PRESERVE DEFINITION” definition and if we want to remove it after the commit we can use “ON COMMIT DROP DEFINITION” clause. Advantages: The advantages of having these private temp tables is we dont have the hedache of removing tables after a technical investigation. And also we can use these tables to insert important

Using APPS9, we have created a copy of the Transport Task page and modified the new version with custom fields, we are struggling to apply the custom menus that are in the original version of transport task. Can this be done?

Hi All,   Is there a setting to disable the sorting functionality by clicking the column header? I never noticed this but today a customer questioned about it, and now I see it every time when opening a table window   I already tried disabling FNDBAS Presobject Table Column Reorganization but it didn’t solve the problem.  

Dear Experts,Thanks for your time.We are planning to uplift one of our client from IFS Application 9 Update15 to IFS Aurena.What are the major steps which we need to follow being an IFS partner.

Hi Eveybody, What .NET framework version is necessary to run IFS V10 UPD 6  on a computer ? Regards  

I am working with some customers who are planning to move from older IFS systems apps7, app8 and app9 and upgrading to the latest and greatest IFS offering apps10. I am interested in experiences of customers who have either been through this process or are currently in the planning or business case generation. Please either post back you experiences or reach out to me if you would like to share your experiences privately. tony.johnson@ifsworld.com 

HiWe are planning to perform a test DR of our infrastructure and IFS system as this is a requirement for SOX/Audit to evidence we have performed this task. We have Oracle database on a Linux server, whereas IFS environments are on Windows servers. We have Mobile and 360 in addition to the Middle Ware (MW) server.  We are using IFS Apps 8.Our Windows servers are mirrored using a 3rd party product, and i believe the plan is to fail over to a mirrored equivalent during the test. We copy the Live Oracle files to our TEST Oracle server hourly. The plan is to create the Live database on the test server using the backed up files transferred from Live server.Once the database is up, i understand i need to perform a re-config on the MW server to point to this database on the test server instead of the Live server for the purpose of DR test. Are there any other steps I need to perform to allow IFS to work in this DR scenario? I am looking for guidance or advise on experiences of performing a DR

Dear IFS Heroes, I want to print 100 lines in one go via Picked Pick List Lines but IFS 9 returns an error: At present I can print nothing more than 20 lines in one go. Is there a way to mass print more lines?   Thank you.

Hi, How can i create materilized view on IFS Developer Studio or i shouldn’t?   Thank you.

I would like to perform an action in one custom menu and then move to another window.A simple but not user-friendly solution is to create two custom menus:First: action type: “PL / SQL Block” - execute code (create a new row in the table), Second: action type: “Create window with transfer” - go to window.Is it possible to switch to another window in the “PL / SQL block” (run procedure / function)?

Hopefully not me having a Monday moment... I have 3 Custom LUs: LU1 KEY: MODEL_NO, REV_NO (Persistent Number Fields) LU2 KEY: MODEL_REF (Persistent Reference Field, ultimately the OBJKEY from LU1) LU3 KEY: MODEL_REF (Persistent Reference Field, ultimately the OBJKEY from LU1) I want to navigate from LU3 → LU2 via the KEY (MODEL_REF). At VIEW level there are 2 columns MODEL_REF and MODEL_REF_DB. I have used ERROR_SYS.Record_General to peek at the values behind each key; the results are interesting: MODEL_REF (2019-12-02_16-16-43.jpg) - This value matches the one shown in debug console when loading the screen MODEL_REF_DB (2019-12-02_16-21-14.jpg) - “Invalid Type definition” error... Can someone make this work?

Can we enable sorting in the search screen for a coumn which is not part of the primary table,We see taht right now we are only allowed to sort columns which are part of the primary table for the screen and not on the columns which are related to the primary table.

We noticed that special characters (Eg Swedish ÅÖÄ) are garbaged when deploy via IFS installer file executor. This happens to be due to the UTF-8 file encoding and it works fine when the file encoding is changed to ANSI (can test with attached script). Has anyone encountered the same issue and found a smart way to get over it rather than changing file encoding? Version: Apps10 UPD 6   Cheers!

Hello,Customer is running on IFS Apps9 with SSO and Active directory synchronization.Could you please advice, how we can ensure that Apps9 will work properly with LDAP channel binding and LDAP signing on Active Directory Domain Controllers?The link on announced update from Microsoft: https://portal.msrc.microsoft.com/en-us/security-guidance/advisory/ADV190023Best regards,/Jozef

We have purchased the SSRS module for Apps10. We have not been able to get it installed correctly. Unfortunately, the documentation in IFS help is for Apps9 and it is different. Does anyone have current Apps10 technical documentation for Apps10? We are on UPD2 planning to update to UPD6.