Reporting Actual Labor Usage

Technote (troubleshooting)


Problem(Abstract)

Unable to complete work orders due to timezone difference.

Symptom

If the server and client machines are in different time zones and labor reporting tolerance is set to not allow future date/time, then it is not possible to change the status of work orders to complete.

ENVIRONMENT: server is in Central time, user is in Eastern Standard time

MAXVARS.SUPPRESSACTCHECK suppresses the check for past or future time when entering actual labor hours

MAXVARS.LABTRANSTOLERANCE allows future Labor Transaction Tolerance in Hours when reporting into the future

MAXVARS.USECLIENTTIMEZONE allows user time zone to be taken into account (as per the timezone defined in the user's default profile or users application)

STEPS:
Bring up an approved work order, go to the actuals tab, labor subtab
Enter start time, end time, regular hours
Then try to complete the work order

SCENARIO 1:

With the MAXVARS.SUPPRESSACTCHECK set to 0, user cannot complete the work order.

With MAXVARS.SUPPRESSACTCHECK set to 1 and tolerance set to 1 hour user can complete the work order.
This is the workaround for APAR IZ90431

However, this workaround is not acceptable because it allows the user to enter future time.

For example, current time on my machine is 12:45pm EST, user could enter 1pm EST as the start time and complete the work order.

SCENARIO 2:

With MAXVARS.SUPPRESSACTCHECK SET TO 0 and labor tolerance MAXVARS.LABTRANSTOLERANCE set to 1 hour

If current time on client machine is 1:07pm EST, user get this message when trying to complete the work order:

BMXAA4590E - Could not change Work Order 1006 status to COMP.
BMXAA4494E - Specify actual dates that are in the past.

Server time converts the time to 12:07 pm CST and users could not complete the work order due to the error message.

Cause

Timezone difference between server and client machine

Resolving the problem

This problem has been tracked as APAR IZ90431 and has been addressed in 7.5.0.4 fixpack.


For the fix to work, the following configuration settings must be in place.

Run the queries below to check the database settings:

SELECT varname ,varvalue , orgid,siteid,maxvarsid from maxvars where varname ='USECLIENTTIMEZONE';

SELECT varname ,varvalue , orgid,siteid,maxvarsid from maxvars where varname ='SUPPRESSACTCHECK';

SELECT varname ,varvalue , orgid,siteid,maxvarsid FROM MAXVARS WHERE VARNAME ='LABTRANSTOLERANCE' AND orgid='EAGLENA';

NOTE: the labor tolerance (maxvars.labtranstolerance) can be also set in organizations application, select action, Future Labor Transaction Tolerance in Hours, enter 0:00 for the tolerance)

If the maxvars has not been set, run the update statements to set the varvalue:

update maxvars set varvalue =1 where varname ='USECLIENTTIMEZONE'
update maxvars set varvalue =0 where varname ='SUPPRESSACTCHECK'
update maxvars set varvalue ='0:00' where varname ='LABTRANSTOLERANCE'


output:


Restart the application server for the new maxvars settings to take effect.

Steps to verify the fix actually address the problem:

For example, my current client time is 5:38PM EST on my laptop, server is running CST time

1. Login to Maximo, set the default user profile to use US/Eastern
2. Bring up an approved work order, go to the actuals tab, labor subtab
3. Enter a valid labor code
4. Enter the actual start time, end time when work has been completed
You should be to save complete the work order without any problem.

In addition, the fix should prevent the user from entering future date and time:

For example, if I enter a future date, I get error
BMXAA2641E - You cannot enter actual labor with future dates and times.



Also, if I enter a future time, I also get error
BMXAA2641E - You cannot enter actual labor with future dates and times.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management IBM Maximo Asset Management for IT Supplement Not Applicable
Systems and Asset Management IBM SmartCloud Control Desk Not Applicable

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Work Order Tracking

Software version:

7.1, 7.1.1, 7.5

Operating system(s):

AIX, HP-UX, Linux, Windows

Reference #:

1621991

Modified date:

2013-08-28

Translate my page

Machine Translation

Content navigation