IV34499: NO WORK LOGS CREATED FOR USERS WITH ACCESS TO MULTIPLE SITES

Subscribe

You can track all active APARs for this component.

APAR status

Closed as fixed if next.

Error description

We have an issue where a Mobile user that has access to multiple
sites and receives Work Orders to Mobile for these sites has
Work Logs go 'missing'.
The scenario is:
User's default insert site = MCLEAN
Site of Work Order adding Work Log to = BEDFORD
When the user adds a Work Log to the Work Order with site
BEDFORD it is not saved on the PDA, nor does it appear in Core
Maximo when the job is sent back.
It appears that all Work Logs are given the site from the user's
default insert site rather than the site of the Work Order that
the Work Log is going against.
This affects Mobile users serving multiple sites that are unable
to record work logs correctly without having to change their
default insert site in Preferences to the site of the work order
they are updating. Even WORKLOG database is not updated for
SITEID field to reflect the original site where workorder was
created.
Steps to reproduce in MAXDEMO 7.1.1.7:
Update the user: kathyb prior toreproducing in MAXDEMO
environment
Logged in as MAXADMIN user.
Updated kathyb in User application.
Click Groups tab
Update so that only the following groups are displayed:
EVERYONE
CONTRACTMGR
Save changes.
Open Security Groups application
Filter for CONTRACTMGR group and click on Sites tab
Changed from Authorise All Sites to specific Sites:
MCLEAN
BEDFORD
Save changes.
Click Applications tab
Setup to ensure she has access to Workorder app and Assets app.
Read/Write/Save/ Grant All
Save changes.
Login as kathyb Maximo user.
Clicked Default Profile from Start Centre and configured kathyb
to be on Default Site: MCLEAN
Use Default Insert Site as a Display Filter is ticked enabled
Logout kathyb.
Actual Steps of reported issue:
Login as MAXADMIN user or any other user that is on Default site
BEDFORD.
Create a new Workorder
Under the Workorder tab enter KATHYB in the Lead field, this
field is found further down screen.
Change status from WAPPR to INPRG
Go to Log tab and create a new Summary and make it Viewable
i.e. Worklog Description
"WO test bedford"
Make note of work order number.
Save record.
Login to PDA as KATHYB (Default insert site is
MCLEAN)
Click worklist refresh
The new workorder is incremented in Work List total workorders
displayed on Mobile homepage.
Click on Work List Items
Click binoculars and enter in the workorder number in the
Ticket/Work Order #: field and click Find to bring up record.
Click on the workorder record displayed
Click on the View(Workorder) menu option
Select History from available options.
This will show one existing entry ("WO test bedford")
Click New Row button
"WO test Mclean"
Click OK and then Send from Actions menu -> send or from Mobile
homepage to upload changes to Maximo core.
Click the Work List data refresh icon.
Login to Maximo as any user Kathyb or other...
Bring up workorder number in Wotrack app.
Click on Log tab.
Only the first Worklog that was created by the first user
(MAXADMIN) in BEDFORD site is displayed.
If you query the database WORKLOG table, the entry is visible
select createby, createdate, description, siteid orgid, modifyby
from worklog where createby ='KATHYB' order by CREATEDATE
You will see the Kathyb entry under Description
"WO test Mclean" is listed with SITEID: MCLEAN.
changing SQL query to MAXADMIN and you will see the original
Maximo Core created Worklog entry is listed with SITEID: BEDFORD
Shouldn't the Mobile PDA worklog entry be listed under SITEID:
BEDFORD too?
Customer believes their work logs are missing because somewhere
in the Maximo Mobile system, the SQL query being run is
wrong and not correctly filtering work logs.