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

The Art of IndexingIn an online transactional database, administrators tend to avoid adding indexes because of their impact to inserts and updates. This is true in a laboratory setting, but a real-world system has to deal with a collection of concurrent workloads. OLTP ERP systems tend to be very read-heavy, in the neighborhood of 94% in my experience. Reducing the aggregate read load can free system resources, and if that means getting the system out of a heavily-loaded state, intelligently adding indexes can indirectly (and paradoxically) improve real-world write performance. Your mileage may vary. I recommend iteratively measuring the effects of tuning your own system rather than following any given recipe. "Match Case"Oracle string comparisons are case-sensitive, unlike Microsoft SQL or MySQL. This means the query hints in Enterprise Explorer do not accurately reflect the effects of the "Match Case" flag, since extra work is necessary to scrub the table's values to uppercase first,

Hi, everyone!Yesterday morning (around 11AM - Brazil) we started the installation of the following deliveries:‘initial’ delivery (1.0.0) for customer XXX (running on server XXX) customization delivery 4.12.0 for customer YYY (running on server YYY)     NOTE: Both customers use IFS Cloud 26R1 (26.1.1)At the very first execution for customer XXX (delivery 1.0.0) the error below was shown:[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Installer Action: install[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Installer Deploy Step: all[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Installer version: 26.1.1[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Java: build 11.0.29+7-LTS[Mon Jul 20 11:46:21 BRT 2026][INSTALLER] - INFO: k8s (client): v1.34.1[Mon Jul 20 11:46:21 BRT 2026][INSTALLER] - INFO: k8s cluster: https://XXXXX.XXXX.com.br:16443[Mon Jul 20 11:46:22 BRT 2026][INSTALLER] - INFO: k8s (server): v1.34.1[Mon Jul 20 11:46:22 BRT 2026][INSTALLER] - INFO: auto scaler: 2.18.0[Mon

I am currently working on a new pallet label using Crystal Reports within our IFS Apps 10 environment.As part of the label requirements, we need to print a GS1 QR Code on the pallet label. After reviewing the available options, we are considering using the IDAutomation QR Code Font and Crystal Reports Encoder to generate the QR code within Crystal Reports.As our Apps 10 environment is hosted by IFS, I would appreciate some guidance from anyone who has implemented a similar solution.Specifically:Does a Service Request need to be raised for the installation of the IDAutomation QR Code font and Crystal Reports encoder on the server hosting the Crystal Web Service? Has anyone successfully deployed IDAutomation QR codes in an IFS-hosted Apps 10 environment, and if so, were there any challenges or considerations? Would the installation require any system downtime or service interruption?Any advice or experiences would be greatly appreciated.

Hi all,We're on IFS Cloud (managed SaaS, hosted by IFS, 25R2) and we're evaluating enabling Analysis Models (Tabular) with self-hosted BI infrastructure. We've been working through the technical docs but, before committing, we'd love to hear from people who've actually been through it. Docs we've been looking at:Scenario 3 (BI infra in Azure, customer-managed): https://docs.ifs.com/techdocs/25r1/050_reporting/010_analytics/010_analysis_models/000_am_tabular/000_biinfrasetup/010_infra_setup_azure/ Scenario 2 (Azure, IFS Cloud Remote): https://docs.ifs.com/techdocs/25r1/050_reporting/010_analytics/010_analysis_models/000_am_tabular/000_biinfrasetup/009_infra_setup_azure_2/ Scenario 6 (on-prem): https://docs.ifs.com/techdocs/25r1/050_reporting/010_analytics/010_analysis_models/000_am_tabular/000_biinfrasetup/020_infra_setup_onprem/A few questions for anyone who has deployed this in production — either managed service (IFS-hosted + Azure BI) or on-premise:Did you stand up the full stack (A

Hi everyoneWe are currently creating a concept for our development process for IFS Cloud Upgrade. We are planning to use DevOps on our own Doppelmayr Azure Tenant for handling all kind of Issues (BacklogItems, Developments, Bugs, Tasks, Testcases, etc.)We are used to mention the issue key in our commits for the customized sources (.plsql, .projection, etc), so that there is an automatic connection between the Issue and the source (visible in DevOps).The issue now is, that the code resides on IFS DevOps and the issues are on our DevOps so we cannot link the commits to the issues anymore. Has anyone the same requirenment or even a solution to that?Best RegardsMatthias

Simply, how do I filter non-extensible PersonInfo entity selection LOV on client? No developer studio is allowed. We want to not show all of our ERPs people on quality assurance person selection drop downs when we only care about a subset we would curate. 

Hi, In Apps 10 - adding custom fields to LEDGER_ITEM_CU_DET_QRY. Works ok as read only. We can add Persistent Fields but it will not let us enter data in the client.Any ideas on why this is and if there is any where we can add this in the client?Current alternative thinking is to use  a Custom LU to enter data which will be picked up by LEDGER_ITEM_CU_DET_QRY. This is for an invoice query management system - so need to be visible on the screen that Credit Control use,

Hi, I’m experiencing an issue with the file name of the Reminder Letter report.A customer reported that they received the email with a seemingly random attachment file name. However, when I checked the corresponding Application Message in IFS, the attachment file name appears to be different and looks to be the correct oneI'm struggling to identify the reason for this discrepancy. Have you come across this behavior before, or do you have any idea what could be causing it?

Hi,I get below error when trying to create a new layout in report studio. I used the module_rep for import. The page is blank because the Report Designer failed to load the report. Consult the developer for assistance. Use development mode for detailed information.Appreciate your support. Thank you.

Hello,I’ve the following situation involving a rebase configuration:Created a new context for company address page where I did some changes (removed tabs, fields etc) and most importantly, to one of the page’s selectors:Modifications in the page Modifications in the page’s selector Then I’ve created a new command through code customization and added it in the selector:Adding command to the selector’s page through code customization After the deploy, the command appears without problems in global context: Custom command in pageBut for my context_test, the command doesn’t appear because the selector was modified through the page designer and a warning appears saying a rebase is needed, so far it is normal behaviour: Custom command not appearing in a personalized context But when I click to rebase, the command only appears if I apply the entire selector which in the process, I lose all my modifications unless I revert them one by one: Before clicking to rebase the entire selectorAfter cli

 I use PurchaseRequisitionLineAuthorizationsHandling  and action AuthorizeRequisitionLinesThats my json {"FullSelection":"LINE_NO=1^RELEASE_NO=1^REQUISITION_NO=1234^SEQUENCE_NO=1^","ChkptUsername": "username","ChkptPassword": "password","ChkptComment": "comment"} What is wrong ? I receive message:"ORA-40441: JSON syntax error"

We need to list all the endpoints preferably module wise to restrict the access and maintain the application security.Please suggest.

I have tested this in multiple 25R2 environments, and in all of them I get the same error: ./main.ps1 -resource 'MONITORING' returns following errors, it seems that the artifacts downloaded from IFS do not contain the folder ifsroot/infrastructure/ifs-monitoring? Hang tight while we grab the latest from your chart repositories......Successfully got an update from the "ifscloud" chart repositoryUpdate Complete. ⎈Happy Helming!⎈Error: chart "ifs-monitoring" matching 1.24.6 not found in ifscloud index. (try 'helm repo update'): no chart version found for ifs-monitoring-1.24.6[2026-04-07 12.58.05.145][INFO] IfsMonitoring downloaded successfully[2026-04-07 12.58.05.209][INFO] Creating ImagePullSecret in ifs-monitoring namespace......."ifscloud" has been added to your repositoriesHang tight while we grab the latest from your chart repositories......Successfully got an update from the "ifscloud" chart repositoryUpdate Complete. ⎈Happy Helming!⎈Release "imgpullsec-monitoring" does not exist. I

Hi!I would like to know if there is a specific path or flow where we can connect 2 Functional objects of the same level.One is a major equipment/asset and the other one is also the same but can be installed on the first equipment and be transferred between different objects of same asset class.Is there a way we can follow e.g.Asset B breaks down under asset A, and we replace it with another asset like asset B again under asset A.Brekadown is on asset A, but following CM is on asset B. Because once we replace the asset B asset A is operational again.While asset B is on asset A cost goes on asset A but it needs to have history recorded on asset B as well.It may be complicated to explain but hopefully we can make this clear together.Thank you!

Could someone please provide the Supported Platforms for IFS10 UPD27 ?Technical documentation link not working    

Hello,Ubuntu 20.04 is nearing end of Support (By 2025 April). Does anyone know whether there are plans to have a more latest Ubuntu version (22.04/24.04) for the Upcoming Cloud releases starting from IFS Cloud 24R2?Thanks