Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Hello everyone! Me and my team are trying to create an FSM developer environment. Firstly I initiate the Oracle database installation process through the setup.exe file provided by IFS and the GUI is running normally at first. When asked, after some steps, to enter the credentials provided to us to create the DB, ba powershell windows appears beginning the installation. After some run time, I get the ORA-06550 error. I have attached a log file with this post, as taken from windows powershell, any help would be greatly, greatly appreciated! Thank you!Dimitris

Hi All, does the products support ALWAYS ENCRYPTED mechanisms and is there any documentation how to configure? Thank you,Charalampos

Hi,To restrict the view of tasks and person in FSM we are using Access Groups. If a user has Access Group "X", they can only see the tasks and person with that access group. If a user doesn't have any Access Group they can see all tasks and person.In PSO, we use Object Groups to achieve the same behavior. We expected that a user who has no object group defined should be able to see all tasks and persons. However, this is not the behavior that is happening in the PSO.Can someone clarify the behavior of object groups please?

Is it possible to increase the resources row height on the Resources Workbench? In order to view multiple days work, we lose sight of key information on the Activity icons on the workbench. If the row was higher, we could increase the icon size, and therefore display more info.

Dear All, I need to populate some specific selected global code values in a drop down fields in web client.  Lets say in Global code I have code values likeCode_Value1,Code_Value2,Code_Value3,Code_Value4 Some time I need to display  Code_Value1, Code_Value2  and some time Code_Value2, Code_Value3,Code_Value4.  Can anybody help me on this to achieve the same. In Mobile there is a populatelistQuery  function . Same Functionality we need to achieve in Web client.  Thanks & RegardsRajat

~~~Edit (wrong FSM Version 5.7 Update 6) ~~~   Hi I was wondering if anyone could help me. I have ran out if UDF fields on the place table and i beleive that i want to create a Extension table to make more fields available. but i cant find any details on the process to do this. does anyone have the steps on how to setup an extension table that they could share them with me?   Thanks,   Graeme

Hi All,We have created an extension table for PART_NEED table as PART_NEED_EXT, for just populating the existing data from Part_Need table we created an alias table for the same, but we need to define a child relation in UI Designer with the Part_Need alias using a field of PART_NEED_EXT table.Our major challenge is to bring the columns of PART_NEED_EXT table to the alias table to define a child relation.Please suggest any solution for the same. Thanks in Advance!  

There is a requirement where I need to send below formatted message from FSM to external system.Mail Bodyin above some information are directly available in FSM database. some text and information are fabricated with Database values to look like paragraphs (Email Body).How can i send this information in Outbound Integration on XML maps? is it possible to send the Fabricated Mail body in XML maps?

Hi Experts,Could you please confirm whether FSM 6U12 Mobile service and FSM application supported TLS1.2 or greater versions? Thanks & Best Regards,Isuranga

Hi everyone, I have a customer requirement that  files outout from FSM via integration should be sent to a customer hosted SFTP server. Can this be done using Integration schedules?When configuring a Monitor Schedule of the type ‘Process (S)FTP Upload’, the 'File and Folder options’ appear to refer to local client locations?Can this point to the attachment container? This is an IFS Managed Customer with FSM / PSO / CE Thanks

 Hi All, Is it possible to prevent the deleting (allow delete) off a row in a list in mobile, based on a criteria. (DebriefLaborList screen).  

Hi Experts, Can you guide me in this scenario where I have to add validation before creating a request as well as need inbound integration.  

In the request screen we have a contact tab and in the contact tab all the contact are stored and the parent table where contact are stored is Request_Contact. we want to sequence all the contacts stored in the contact tab so that primary contact can be shown always at the top and can be visible on the request header screen.

Hi Experts: I attempted to install FSM (On Premise), each time it fails with the following error (Admin user sa is used). Any Idea? Starting install, parameters passed:Server name........FSMINSAdmin user.........saAdmin password ....**********Database...........fsmdbprodDatabase user......fsmdbprodDatabase password..**********Backup Folder......C:\mxserv 6u20\DatabaseData\SQLServer\NewInstallInstallation parameter check passed.Testing database connection...Database    : masterElapsedTime : 0.0189728Server      : FSMINSUser        : SQL (sa)Connection  : Successful...verifying sqlcmd utility.........searching folder = C:\Program Files.........searching folder = C:\Program Files (x86)...Everything seems to be order, continuing new install!Import

Hi,We need to have more than one dataset in PSO and we did the following steps: 1 - Created two datasets;2 - Created a team for each dataset;3 - Created Integration Schedules for each dataset.4 - Created a resource and associated it to one of the teams. Expected result: The resource only exists in the corresponding dataset.Actual result: The resource exists in both datasets. In our understanding, the resource should only exist in a dataset (the dataset associated with his team). Does anyone know how to solve this problem or if this is a already known issue? FSM Version: 6 Update 18PSO Version: 6

We have to create a new user-id for a technician.  The old user-id was set to inactive.The technician only has MOBILE license. When completing a task, we set a BR to send email with attachment (a report.  PDF file).Another BR is also setup to attach the report to task when task is completed.  (we have customization to attach report here). After using the new account, the emails by the technician do not contain attachment anymore.On task there is no report attachment either. I have checked to task_attachment, and attachments tables, no record is created by new user-id since it was created. User connects to mobile app using SSO login. The issue doesn’t happen to other technicians. Any idea what to check for this new user-id? Thanks in advance,~Juni 

Hi Experts, One of our customers have raised a question on the Apple ABM process required for FSM iOS app distribution.“I would like to know whether we can utilize the direct link download mechanism mentioned in Apple distribution methods (link 1 below), as Electrolux have a business case where there are technicians (3rd party) who does not have an Electrolux account, but wants to install the FSM iOS app. Since they don’t have an Electrolux account they won’t have access to Microsoft Intune (ABM), so they will not be able to download and install.For Android, we are able to sideload the application as it can be downloaded from the FSM Server URL, problem occurs for iOS. I did some research and I came across the below articles from apple, please let me know how feasible is this.link 1 Go to topic "Make your app available only through a direct link" - https://help.apple.com/app-store-connect/#/dev275598f16link 2

Hi team, We have iframed other application url inside FSM Smart Client. We are passing task parameters in the iframed url using the format {{task.task_id}}. It is working fine in smart client. But the same is not working in webclient. In webclient it takes the parameter value as {{task.task_id}}Can you please advise how to fix this for web client or workaround for this? We need to construct urls through metrix browser as iframes in web client. Basically it should work in webclient rather than smartcliet for us. The URL is unable to substitute e.g. {{task.task_id}} in web client.  Regards,Ajay

We have setup all the parameters for PSO in our application, however when the Service request is initiated and the scope is added to the service requests and the tasks are getting generated based on Service Catalog, we do not get the option for Appointment booking so that Appointments can be retrieved from PSO. Could anyone please help us with the reason for of us not getting the Appointment Booking button?

Hello,I’m trying to create a lobby tile with a scripted data source. (FSM 6.5)My Client Script SQL and Client script are both working.  I can preview my data source from the data source designer screen and see the result from my script.  The script is returning a single number and appears to be in a column named “return”.I’m struggling to get the number returned from the data source to be displayed in the actual element tile.  There is just a big X where the number should be.Since this is my first scripted lobby tile I must be missing a step somewhere. Anyone know what it could be? Thanks! 

I am trying to refresh the test DB with up to date data  (SQL) with the a backup of the PROD DB, however when I restore the DB (either full or files and folders), and then try to connect with the client app it says it cannot find the DB. I am sure it is possible but I must be missing something simple. Any help would be greatly appreciated. 

Hello Community,I have configured the part used lookup in mobile to retrieve additional fields from PRODUCT and MODEL_STRUCTURE tables.The issue is that I cannot see all the fields I am trying to show in the UI,This is my query in mobile vs. SQL tool. Identical as far as I can seeI added a specific part id just to demo my issue The results2 fields are missing and NOT showing - product.product_id, product.external_system_id.  Any ideas?Cheers!

Hi Experts,Currently I am working with the UPD20 upgrade for DEV and BNT environments. After the upgrade(from UPD17 to UPD20), it seems there is an issue when trying to print both Baseline and Custom reports.  There is no modification was done to APP PARAMS = CLIENT_REPORTS_PATH. Am I missing something here? Thanks,Hasara 

Hi Team,I have added the Custom Button in one of the screen and tried to implement the Multi Selection of Serial Id functionality, with reference of the Baseline Client Script of the  SELECT button in the Shipping Screen.I had implemented this Same script in New Custom Button which worked in the Web client not working in the smart client.Need Suggestion on this

There seems to be a dependency between the two non part usage fields quantity and transaction amount. Has anyone an idea why that is the case, and is there a way to disable this dependency?For example, there appears an error message if a zero is saved in the transaction amount field, that informs that the quantity can not be zero.