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 "

Is it possible to add more objects to the object connections on a Non Conformance Report (NCR)?   We would like to add the shipment to the pre-defined list available in IFS.    

Somewhere in IFS 10, each window knows which table or view it’s based on.  And, the navigator knows what to display in it’s list and which window to display when the user clicks an item.  How do I get a list of all the windows named in the navigator, the tables or views they’re based on,  and their Object relations?For instance, someone created a custom menu in window “frmPriceInquiryAnswer” and I need to verify it works (for migration to IFS 10).  Searching the navigator for something like that gets me to “Price Query” and it doesn’t have a custom menu.  Multiply this by a list of 300 custom menus, and you see my problem.In advance, thanks so very much!

I see that UPD6 is out now. Anyone running this and can recommend going forward installing it? We are on UPD5 now.  https://open.ifsworld.com/mediashare/mediapage.aspx?entityId=12137 Heard something of some bugs and unstable things in UPD6. This was due to some design change, I heard. Anyone knows more about this?

Good afternoon,Is anyone able to provide the database views/tables for those areas of the IFS system which are not visible through the System Info tab? These typically are screens within the Solution Manager folder.For example, Database tasks, Scheduled Database Tasks, Background Jobs etc.We are using Apps 8.Thanks in advanceRegardsShaun

Pros and Cons of executing cache refresh in-app or native in Oracle. Results appear the same however are there advantages.

I am trying to set up a couple of permission sets related to the entering and processing a corrective action.  We’ll have one group that will only initiate the capa and enter the Investigation Data. I need to be able to restrict them from completing the subsequent steps (enter action data, verification data etc..). This looks pretty clear in the permission set, under frmNcrCapaActionsMain\Actions, there are 4 distinct options one for each step. I only have the “Enter Investigation Data” one checked  for this permission set. However when testing, a user with this permission set has all of steps available.If I go deeper and look at the Presentation Objects by Component the options for “Enter Action Data” etc. are not granted but the Database Objects for each of the steps are the same (NCR_CORRECTIVE_ACTION_LINE, NCR_CORRECTIVE_ACTION_LINE_API) so they are granted.Is there any way to limit the access to specific steps? It seems as this should be possible so hopefully I’m

We are on App8 SP1+.  We have some documents that require special handling if they are printed out.  I can indicate which documents require this using a field on the document revision.  These documents can be Word, Excel or pdf.  Ideally I would like to have a cover page printed automatically anytime someone prints one of these documents.  The cover page would always be the same.  As an example it might say “Confidential Do Not Distribute”.  Any ideas on how to accomplish this or other suggestions to accomplish something similar.Phil

There must be a smarter way then browsing the permission set details and clicking all branches in the tree ...

A week ago, I successfully installed UPD5 to Apps 10 in my DEV environment with only one error reported in the installer.log and no errors reported in the IFSDEV10_configuration.log. Yesterday, I ran the UPD5 against my MGR environment and it reported a “partial Failure” with the following error in IFSMGR10_configuration.log 2019-10-17 17:51:59 Running ant script E:\ifs\mws\ifsmgr10\repository\server\install_fndmws.xml, target post for component server[java]: Java Result: 1Error in Ant-script: server\install_fndmws.xmlReported error is: The following error occurred while executing this line:E:\ifs\mws\ifsmgr10\repository\server\install_fndmws.xml:237: Failed to install Middelware Server! Error is: Call to stopAllServers not successful.Failures detected when updating IFS Middleware Home, see logs

Is there a smarter way to grant permission to database objects besides doing a rmb on 200 folders one-by-one?

In IFS Middleware Server Admin Console page all the services are in GREEN state but Http Servers which higlited in RED is in ORANGE state. What is the meaning of this difference, to overcome this issue what is the action need to perform. Is anyone of you faced issue similer to this, If YES please advise way to resolve. Common Tab→  HTTP Servers →If we select the option, it is in loading state and page went greay-out. Regards,Vivek NR.

Hi, does anyone know how to reach and edit the New Document Page in Page Designer? It seems to be a global Page, and i can’t find it. We want to hide the yellow part in the screenshot below.   

Does the IFS client (we are Apps 9) use the JAVA runtime (JRE) environment?  If so are we required to license it?  This question has come up with the announcement of the JRE licensing requirements that were announced earlier this year.

What is the significance of the No of processes in the batch queue configuration? 

We're upgrading to IFS 10 from IFS 8. I need to verify all the saved searches came through intact. If I navigate "My Administration" -> "Saved Searches", I can see the list. How do I export it so that I can compare the IFS 8 list to the IFS 10 list? Alternatively, what table or view can I use to see this information in SQL?

Does anyone know how to publish changes to a lobby in Aurena? I've made some changes to one and they are active in EE, but not on Aurena. Also wonder how to change a Lobby in Aurena. We want to make a local copy of My Self Service and do some changes to this. Bjarte

I want to add a second application server, do i need to i stall all of my patches on the second application server?

Is there any customer out there that has this working in v10 - that are able to produce operational reports (like POs and such) inside of IFS? Also, I think the attachment is from version 9 - it refers to Simple LDAP which is not supported in v10. Is there a version of this document updated for v10?

End-Customer needs secure access for +300 end-users. They are using hired equipment by OEMs where they can't install VPNs nor register them into Azures or similar Active directory structures. Simpe user name/password to access into Aurena is not enough. They should use also second authorization through tokens or similar technology which ensure personal access into Production environment of IFS Apps. Equipments are running on different OS like Android and iOS. Therefore they should use Aurena client for limited functions like Time reporting, Absence registration and Travel Requests/Expenses. I would get some "white papers" how to setup two stage authorization. The aim is to prevent second installation for "reporting" environment with replication into PRODuction env.