List of Contributions

Julio Hernandez

Contact Details

My Content

1 to 13 of 13 total

RE: Select WO actuals and include task actuals?

Posted By Julio Hernandez Dec 22, 2020 12:44 PM
Found In Egroup: Maximo \ view thread
If you have multiple Sites, your JOIN should include the SiteID in a WHERE clause and/or in the ON clause. You used NVL around the cost fields in the main SELECT but not in the Tasks GROUP BY Query. Since the Act... columns are not flagged as REQUIRED, you should use NVL throughout to be safe. ...

RE: Select non-parent WOs?

Posted By Julio Hernandez Dec 11, 2020 12:24 PM
Found In Egroup: Maximo \ view thread
Hi. The HasChildren flag will be set to 1 when a WO has Tasks so I don't think you want to rely on that field if you want to include WOs whose only children are Tasks. You said you're using: where ( parent is not null or (haschildren= 0 and parent is null )) and istask = 0 The first part of that, ...

RE: Create extension table (database config)

Posted By Julio Hernandez Nov 19, 2020 2:06 PM
Found In Egroup: Maximo \ view thread
Assuming you're not working in a Multi-Tenant environment, the fact that you're seeing the "Create Extension Table" option is a bug. I have submitted a case to IBM to report it. The ApplicationAuth records for that option in a MaxDemo environment have the ConditionNum = "MTONLY". That condition references ...

RE: Select WO actuals and include task actuals?

Posted By Julio Hernandez Nov 10, 2020 11:41 AM
Found In Egroup: Maximo \ view thread
That's actually not a good approach. When you group by "coalesce(parent, wonum)", the costs charged directly to a child WO will be included with the Parent WO and the ClassificationID won't be what you want either. ------------------------------ Julio Hernandez ------------------------------

RE: Select WO actuals and include task actuals?

Posted By Julio Hernandez Nov 6, 2020 3:40 PM
Found In Egroup: Maximo \ view thread
There are many ways to do this but relying on the WOGroup avoids having to bring the WOAncestor into it. Below are 2 options: SELECT WO.WONum, WO.WorkType, (SELECT SUM(ActLabCost) FROM WorkOrder AC WHERE AC.WOGroup = WO.WOGroup) as "Actual Labor Cost", (SELECT SUM(ActMatCost) FROM WorkOrder AC WHERE ...

RE: Use of Job Plans or Inspection Forms for Technicians when performing PM and PdM

Posted By Julio Hernandez Oct 22, 2020 1:38 PM
Found In Egroup: Maximo \ view thread
The use of Job Plans for Inspections requires the creation of a WO for each Asset or Location being inspected. This has always been a significant drawback of doing inspections in Maximo. The creation of a WO for activities that may only take a few minutes and are not going to be scheduled or charged ...

RE: Prevent tasks from being converted to WOs

Posted By Julio Hernandez Oct 19, 2020 2:12 PM
Found In Egroup: Maximo \ view thread
An AutoScript validation as suggested by Jason is a good fail safe. Regarding the Application Designer changes: In the "Work Order Tracking" application, a Task cannot be promoted to a WO unless you allow a Task WO to appear as the "header" WO. By default, the "Is Task?" field is set to "N" on the ...

RE: Convert task to child work order?

Posted By Julio Hernandez Oct 16, 2020 1:57 PM
Found In Egroup: Maximo \ view thread
Trying to "promote" a Task to a Child WO by simply changing IsTask from 1 to 0 is dangerous. When a Task is "promoted" by adding a Task directly or through a Job Plan, the IsTask value is not the only thing that changes. The TaskID will be NULLed out and the WOGroup, which is set to the Parent when ...

RE: Why allow users to add/delete specs/attributes from records?

Posted By Julio Hernandez Oct 9, 2020 1:31 PM
Found In Egroup: Maximo \ view thread
The Classification/Specification feature was originally only available for the Asset, Item, and Locations objects and the feature was introduced to replace the conditionally related tables feature that existed back in the Client/Server days where depending on an attribute on the record, a tool bar button ...

RE: SSO with Azure AD

Posted By Julio Hernandez Aug 28, 2020 4:33 PM
Found In Egroup: Maximo \ view thread
And I should include "https://" in front of the HostName? ------------------------------ Julio Hernandez ------------------------------

RE: SSO with Azure AD

Posted By Julio Hernandez Aug 28, 2020 4:30 PM
Found In Egroup: Maximo \ view thread
Thanks for the response. Just to be clear, are you saying that if my Maximo URL is " example.com:443/maximo ", I should set it to " example.com:443/samlsps/* "? ------------------------------ Julio Hernandez ------------------------------

RE: SSO with Azure AD

Posted By Julio Hernandez Aug 26, 2020 8:27 PM
Found In Egroup: Maximo \ view thread
Hi Biplab, Your above post has been a big help but I'm confused as to what goes in the sso_1.sp.acsUrl property. If my Maximo URL is " https://example.com:443/maximo ", would I set it to " https://example.com:443/samlsps/maximo "? The note about " multiple, similar entry points for your SAML workflows ...

RE: Significance of savemode="ONLOAD" for dialog

Posted By Julio Hernandez Jun 30, 2020 9:59 AM
Found In Egroup: Maximo \ view thread
savemode="ONLOAD" causes any changes prior to launching the dialog to be saved when the dialog is opened. savemode="ONUNLOAD" causes changed to be saved when "OK" is clicked on he dialog. And savemode="ONLOADUNLOAD" causes changes to be saved when the dialog is opened and when "OK" is clicked. If savemode ...