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: The server is in Central time and the 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 sub-tab.
Enter start time, end time, and regular hours.
Then try to complete the work order.

SCENARIO 1:

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

With MAXVARS.SUPPRESSACTCHECK set to 1 and tolerance set to 1 hour, the 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, the current time on a machine is 12:45pm EST, the user can 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 the current time on a machine is 1:07pm EST, the user receives the following 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 cannot 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 the Organizations application, "Select Action", "Future Labor Transaction Tolerance in Hours", and enter 0:00 for the tolerance.

If the maxvars have not been set, run the update statements to set the varvalues:

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.

To verify the fix actually addressed the problem:

For example, the current time is 5:38PM EST on a remote laptop and the server is running on CST time.

1. Log in to Maximo, set the default user profile to use US/Eastern.
2. Bring up an approved work order, go to the Actuals tab, Labor sub-tab.
3. Enter a valid labor code.
4. Enter the actual start time and the end time when the work has been completed.

You should now be able to save / complete the work order without issue.

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

For example, if a future date is entered, you will receive the following error:

BMXAA2641E - You cannot enter actual labor with future dates and times.




If I enter a future time, the following error will be received:

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:

2014-07-29

Translate my page

Machine Translation

Content navigation