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,

The documentation from 21R2 hinted at a great feature we could use:https://docs.ifs.com/techdocs/21r2/020_installation/010_installing_fresh_system/010_planning_installation/010_storage_tier_considerations/010_oracle_db_19c/ Oracle Edition-based Redefinition¶Beginning with IFS Cloud 21R1, IFS offers framework support for Oracle Edition-based Redefinition.Oracle Edition-based Redefinition (EBR) allows online application patching and upgrades with uninterrupted availability of the application. When the installation of the upgrade is complete, the pre-upgrade application and the post-upgrade application can be used at the same time and as soon as there are no sessions any longer using the pre-upgrade application, it can be retired.Note, framework support implies that all editionable objects meet the requirements for EBR and they are, from a database perspective, handled as if EBR is used in IFS Cloud. However, full support for EBR in IFS Cloud and the possibility to apply online service up

How would a customer create a new custom webapp similar to the WAR files that APPSRV and GISINT use for mapping? Do you review customer requests on BitBucket, or is that only for internal use? Are the README files still valid for Cloud where our customer Git repo is hosted in Azure? (Would my webapp become available for every customer?) Please assume I have development experience outside of this framework.

Where can I find instructions for a Linux-only installation without using Windows for the Installation and Management Server?

Is there Cost history details for Shop Orders? Can I export all cost bucket detail for shop orders from the last 2 years? Where is the data stored? I need the cost data for all shop orders.  

I want to enter data through postman in one of our customer’s test environment. I tried connecting to the environment using Basic Auth as Authentication type, but it’s giving an error.How can I connect postman to this environment? Is there a different Authentication type that I can use?Following is in the API Documentation. This is a 25R1 environmet. 

As the overall idea of IFS's API, when you run an API, the processing result comes back, but at which point is the processing result actually output?- The message is sent after the API process is completed.- The message is sent as soon as the API is executed, without waiting for the API process to complete.

①Is it correct to understand that in the following API processes, record locking (exclusive control) is done when performing stock in/out operations?・ShopFloorConnector.svc/IssueComponentLine・ShopOrdersHandling.svc/IssueExecute・Issue_Inventory_Part_SVC.Do_Issue_Inventory_Part・Receive_Inventory_Part_SVC.Do_Receive_Inventory_Part_In_Update②If another in/out process runs at the same time as the API execution, will the process that runs later cause an error?③In the API, how is data being controlled when it comes to handling stock in and out?→Since access to inventory data happens frequently, it's hard to imagine that the process executed later would fail every time we access the same record, so I'm curious about what kind of control is in place.

Hello,We are currently revising the permission sets. We now have over 850 functional roles and numerous user roles (a total of over 1,097 permission sets). The two QuickReports titled “Permission Set Grants Reports” are no longer functioning as intended. They are no longer returning any data. We need these reports for the audit. These two QuickReports are running on the IFS-MIG as intended. However, we now have 256 permission sets there.We use IFS Cloud 25R1 SU 5Best regards,André

Dear developers,I'm having a problem when I create an event action of the SQL type.I want to use general parameters such as:#PERSON_NAME##TODAY#etc.How can I use them in PL/SQL code?‘#PERSON_NAME#’ gives me #PERSON_NAME#‘PERSON_NAME#’ gives me &IFS Application Owner Thank you in advance.

When an application messages addresses gets fail status, the framework has a mechanism to create a “one-time scheduled task” to re-execute the same message/address within a short time. At my customer environment, this sometimes fails. It is not the actual “Retry application message” that is the problem. The problem as I understands it, is the logic that catches the exception of the application message and then fails to add the “one-time scheduled task”. The error is shown on the application message with the error text “Next execution date must be between start date and stop date”. The reason to this error is that when the scheduled task is to be created, the logic fails to calculate a correct execution date. There is an logic checking that the execution date must be betweenCode if from Batch_Schedule_API.Insert___-- Check date intervalsIF newrec_.next_execution_date IS NOT NULL THEN IF newrec_.next_execution_date NOT BETWEEN nvl(newrec_.start_date, newrec_.next_execution_date - 1) AN

We have a list of documents attached to customer invoice and when the invoice is printed, we would like to t the invoice and all the attached documents should get printed after the invoice as annexures (in a certain sequence).We have configured reporting rule for this with the following parameters:However, the output is a little random. sometimes the annexures get printed after the invoice, but there are times when half the annexures come before the report, and half of them after. The need is multiple documents getting printed after the report as annexures. Can someone provide help here. 

Hi, I ma trying to make a field in (assistant window) on Register Arrivals-Receive mandatory for users. How do I find and configure this field in page designer. Regards OJ

Hi TeamIs it possible to disable the fields user and password in ifs aurena login dialog.To force only SSO or Azure login

I created a custom attribute on the event called “CoordinatorEmail” with the methodIFSAPP.COMM_METHOD_API.Get_Value('Person', &NEW:MRB_COORDINATOR, '1') Then I try to use it as the email address by entering &CoordinatorEmail The field does not appear to be pulling an email address if I put &CoordinatorEmail in the body of the message. Any help would be greatly appreciated. Thanks,Mike

Hello,Brief description of our problem:our company recently migrated from IFS9 (Oracle 12) to IFS Cloud (Oracle 19c). Both databases run on Oracle RAC. IFS9 worked well with Oracle RAC, but IFS Cloud can only function properly on one Oracle RAC instance. When we run the application on two nodes, we start receiving errors like: ORA-20113: JtTaskTransaction.FND_LOCKED: Update could not be fetched because the work task transaction record is currently locked. Retry the operation.JtTaskTransaction - is one of several tasks, provided only as an example.Our DBA analyzed the database logs and found that there are no RAC waits at the top, but a lot of TX row lock contention, waits event in Oracle databases that occurs when multiple sessions attempt to modify the same row(s) simultaneously.Have you encountered similar problem in your practice? If so, could you please share some advice on how we can solve it or what we can try to find a solution? Currently we have service update 24.2.1. Thank you