@roklde Thanks for the response. I wanted to get some clarification. What do you mean by “those tables?” Which tables from which application are you referring to? FSM or PSO tables?
Screenshot of hierarchy select in QAT/TEST:
The hierarchy select brings back the correct columns from a view to insert into the custom table, but the error is referring to the parent table not the custom table I’m trying to insert into.
@Shneor Cheshin thanks for the suggestion. I have put in a support ticket, but hoping reaching out here would bring about a quicker solution.
@Sajith Anushan,You mentioned PSO making adjustments based on the person place time zone.We set up a place (e.g., HOME_PERSON_ID) for each PSO user/resource in FSM with a Starts Works From, which includes the person id as the place person.I also see the place person which includes the person, works_from and ends_works_at, but there is not time zone specified on either of these tables. How is FSM getting time zone coming from the Resource’s Place Id? We began setting the time zone on the resource in PSO and re-generating their shift and now it the shift has adjusted, but we originally didn’t have that done. We do have resources going to places in different time zones. To be clear there is no time zone information being sent with the task?
@Sajith Anushan, Thank you for the quick response. Is there anything you recommend in either FSM, mobile or PSO when a user crosses time zone?Right now, if they schedule a task time, but the place is in a different time zone, then they need to adjust the time accordingly. For example, a place’s time zone is US/Central and and the user is in US/Eastern. They would have to set the task plan start time, eastern to be 9 AM for the actual task to be scheduled at 8 Central.For mobile we have enabled a setting in mobile/tablet to automatically adjust and display the time zone they are in. Is there anything else you recommend?
Make sure in the exception_type, code table, the Available column is not checked.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.