IFS Solutions

Hello, I would you ask you a question. How can I speed up data retrieval and exporting Oracle columns in excel? I find that indexes is good option, exist another options? Or when I will use indexes (for example) composite, how can I implement it? How can I find out in which table belongs certain view in IFS? Thank you

We have a PO (A90081) linked to SO (1889644). The PO is for an external operation related to SO 1889644.Previously, the user over-received the SO and reported all items as received. They have since reversed the over-receipt for the part on the SO, but we are still encountering the error: "Cannot ship more than completed in previous operation" when trying to receive the PO. I believe this may be due to the need to reverse the operation report as well. However, I am unsure how to proceed.Could you please advise on how to resolve this error?

Hello, I would you ask you a question. How can I speed up data retrieval and exporting Oracle columns in excel? I find that indexes is good option, exist another options? Or when I will use indexes (for example) composite, how can I implement it? How can I find out in which table belongs certain view in IFS? Thank you

Hi Community,We try to anderstand what is difference between customer contacts and customer communication method. It seems to be use in the sames cases to manage contacts. if somebody have examples about differents usages please share your experience. Contacts are link to Persons and Communciation method is free to input data.is it the only difference ? BR, Christophe 

Hi All,We use FSM and PSO to schedule all field service work in our business.We used appointment booking in 360 with Metrix 5 (old names for PSO/FSM) about 10 years ago but quickly reverted to fixed resource and fixed commitment tasks and turned appointment booking off due to its poor reliability at that time. Basically it didn’t work.We are now on FSM U27 and the latest PSO version and are considering looking once again at appointment booking. I though it worth asking on here if any of you use it with FSM/PSO and if your experience has been a positive one.Thanks in advance for any feedback.Barry

Hello, If we display a field on the screen and it is driving from a drop down we can select a “Item Style ID” to format the text and alter the back ground color. - This is GREAT!  BUT if that field is Read only then it reduces this control to only formatting text, it ignores the background formatting.    Do we have the ability to override the ‘grey’ of the read only cell and allow the image style ID show?

Hi All, I’m setting up a file sender and would like to know if the directory location path name is case-sensitive? Thanks,Ashen

Hi, I have event actions with type - Rest Call. That generate a outboud message from IFS. This message fails  by the below errorExecutionException from Sender thread Caused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending data Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target As per IFS, we should be able to import certificated by our own in IFS cloud.This event action doesn’t use Routing addresses. But I tried to import the certificates using a dummy routing address. After

Hello everyone,I have a question. I hope you can help me.Currently, we have an integration between IFS CLOUD (24R1) and PSO. Although all data is created correctly in Cloud, we have no errors when we run ,,Send full load,, nor in Application Messages, resources and activities do not appear in PSO. Dataset is visible but no information appears. Resources are created correctly. What might be the problem? Thank you in advance!Best Regards, Miruna 

Hi,Looking for some advice to see what’s possible with this scenario.I have a resource ‘x’ working 8hrs. The have a van and can travel to jobs within a 60 mins max travel.I also have a second resource ‘y’ working 8hrs, but they don’t travel as customers bring their vehicles to one of our locations.I want to be able to set up the resource ‘x’ to say for the first 4hrs of the shift they have a max travel of 0 mins then the second 4hrs to be back to 60 mins.This will then enable resource ‘x’ to assist in a Service Centre for the morning, and then go mobile in the afternoon with PSO taking him back home.There’s other scenarios where we may use this also, i.e. the Vans in for repair or service. So I have looked at Vehicle setup in ARP, but that appears to be around capacity and / or travel based on range.I have thought about lowering the cost/ph and increasing the cost/km during the shift so it encourages Base work, but that would still allow travelling for the first 4 hours when we don’t w

Hello,Could you please give me advice on this problem. My task was to add new column SUM which will count values in two columns and in this column are decimal values with a dot, but I want decimal values with a comma, how can I change it? This is my query:“SELECT :QUANTITY + :QTY_WAIV_DEV_REJ FROM INVENTORY_VALUE_PART_LEVEL_EXT” I tried this command: “SELECT REPLACE(TO_CHAR(:QUANTITY, '99999999.9'), '.', ',') +        REPLACE(TO_CHAR(:QTY_WAIV_DEV_REJ, '999999999'), '.', ',')FROM INVENTORY_VALUE_PART_LEVEL_EXT  “ in SQL works, but in IFS it didnt retrieves any data.

I need to know the logic the utility uses to re-classify ABC Class on items.  I just need to understand the calculations IFS uses to classify the ABC. I am trying to determine if it uses the total consumption value (based on Annual consumption value = Annual x Unit Cost) and calculates  a cumulative percentage OR if it uses a weighted approach that assigns different weights to ‘value’ (annual consumption value) and usage frequency (how often an item is used) version and uses both total value and volume.Can anyone provide me the IFS it uses to reclassify the ABC classes. Also it is important to understand when is best to run this..  we just brought a separate company/site in Oct 23 but into the same company/site in June 2024.  Will the ABC classification use only usage since June 2024?  I do see on Inventory Part Availability Planning that the usage does show from last year, so would the ABC Classification see this and use that in their calculation?  See IPAP example ThanksRachael 

Is there a setup where a project manager can only see transactions related to his or her projects Only? Regards,Rasfe.

Hello eveyone! I need to schedule a csv file from IFS server to be in FTP address each 2 hours. I already set the Job Migration to create a csv file. And I already set my destination folder in IFS Server.The csv file is being created in the folder that I set. It’s all fine here. Now, I need to send this file to a FTP server each 2 hours. Is there a way to customize this? Thanks a lot for any help!!

Setup:  IFS Applications 10 UPD 6   On trying to run IFS Aurena Notify Me 10 we are receiving the following error: Something went wrong!   Reference:  IDP-U5Mvq0wrYt6A Code:  IDP_PROTOCOL_FLAW Message:  Request failed to fulfil protocol requirements. Information:  Invalid redirect URL   I know in the past we have had to open IFS Middleware Server Admin Console > Security > Database Identity Provider > External Redirect URls and added the Redirect URl for the application that is displaying the error.    My problem is where do I locate the Redirect URl so that I can add this?   Can anyone please advise?      

Hi EveryoneWe are testing SSO in one of our test environments and are having an issue. We have set it up to Azure AD services and also have the Active Directory User Integration configured to point at on on premise AD security group- this works but we are running the synchronisation manually while testing, rather than having it scheduled.Things seem to be working as intended except we are seeing user accounts being auto locked daily at 14:50 and/or 02:50 (example screenshot below) but we don’t know by what- we cant see any obvious background jobs doing this, although we have disabled a couple with no change. Has anybody had the same issue and resolved it?Thanks in advanceChris

We are IFS hosted.In IFS Apps 9 UPD 1, on the Solution Manager -> Security -> Users -> Active Directory User Integration screen, there is a Primary LDAP Server listed.We need to change this server. I know when we updated the password for the service account listed on this screen, we lost IFS access and IFS (who hosts our system) had to stop/restart some services for IFS to work again.Do we need to coordinate with IFS to change the LDAP server name? Or are we able to do that with no other impacts? 

We are using the IFS10 Print Agent very little and wish to stop using it. We don’t print much but a few times per week invoices that we are going to change to be emailed internally instead. Any considerations before removing the print agent service you can think of?

Hi,We get the following error message when creating a change order for a PO in IFS Cloud (23R1).We don’t use supplier schedules, and I have never seen this error message before.Any help would be much appreciated. Thank you

Laser check is developed using IFS report designer and it aligns with the pre-printed check in Dev environment. But when the same rdl and xsd is moved to prod, the alignment is completely off.The “Payment Document → Supplier Check” settings are identical, printers are identical. So not sure what causes the mis alignment.Any suggestions?Thanks in advance  

There is a SharedDocs”appname” folder on the app server that fills up the disk with small files over time. These all appear to be uploaded document images. I found the references to this directory in the “appname”_configuration.xml file. <ifs.fndmws.internal.custom.java.options.main>-Difs.fnd.docman.shared.path=c:/IFS/SharedDocs”appname”/</ifs.fndmws.internal.custom.java.options.main><ifs.fndmws.internal.custom.java.options.int>-Difs.fnd.docman.shared.path=c:/IFS/SharedDocs”appname”/</ifs.fndmws.internal.custom.java.options.int><Docman.cluster.shared.path>c:/IFS/SharedDocs”appname”/</Docman.cluster.shared.path> Can anyone tell me if these are just temporary files created for upload to the database, and if so, is there a setting to clean these up after a given period of time or can they be cleaned up manually after processing is complete?

To me it looks like the material bottleneck settings have been swapped in the logic. “Always Finite” components will be scheduled in Shop Orders with planned goods receipts. If I switch to “Finite” the Shop Orders gets “Unscheduled”!? 

Hi All,I have a clarification with regards to the Supplier Check Templates and would like to know the logic behind printing of 10 invoices per remittance if the Check Template ID is defined as LASER and 14 invoices when it is defined as NORMAL.  Also observed that, when a cheque is printed with the Template ID Laser, it generates 2 result keys if more than 10 invoices are  matched with a check.Example: Matching of 16 invoices to a check. Appreciate your support.Best RegardsRazan

Supplier Payment screen (Screen shot below) is missing from Cloud verison.I have below doubts -Although, the related business transaction can be done through mixed payment but what is the reason to discountinue the process.  How previous transaction can be seen in upgraded environment.  Note: Similarly, corresponding screen for customer, names - Customer paymeny is also discontinued.

It seems that you need an existing record in the Register Arrivals screen in order to select that line and then use the line-specific commands to Create the PO.  What if you’ve never created a PO for this PN?  In this case, when you search the Register Arrivals screen, there are no records and when there are not records, there is no line to select to enable the command to create PO. Thank youPatrick