We need the in-house overlay, seal coat, crack seal, and fog seal projects for FY25 added to Maximo.

[atdservicebot]

What application are you using?

Maximo

Describe the problem.

We need the in-house overlay, seal coat, crack seal, and fog seal projects for FY25 added to Maximo.

How soon do you need this?

Soon — Within a week

Is there anything else we should know?

The field crew will need the Maximo work orders to track work completion.

Requested By Ambarish B.

Attachment (764.18kb)

Request ID: DTS24-117440

[rebekkabry]

[rebekkabry]

9/17/24 Crack Seal Updates

Reached out to OCE to check on the following duplicate work orders found (this shows only Crack Seal duplicates)

[rebekkabry]

Appers no assetnum --| SP25-164491 SP25-164706 SP25-164770 SP25-165106 SP25-165400 SP25-165518 SP25-165602 SP25-165630 SP25-165706

[rebekkabry]

Updates 9/20/24

• working with GIS to get asset_ids updates for ASSETNUM field.
• Pending updates from Andrew, may follow up with CTM and Ganesh for support. Pending Andrew updates.

[rebekkabry]

Updates Seal Coat 9/20/24

WONUM Missing AssetNum --| SP25-164743 SP25-164743-LU SP25-164743-CS SP25-164743-SW SP25-164951 SP25-164951-LU SP25-164951-CS SP25-164951-SW SP25-164965 SP25-164965-LU SP25-164965-CS SP25-164965-SW SP25-165246 SP25-165246-LU SP25-165246-CS SP25-165246-SW SP25-165278 SP25-165278-LU SP25-165278-CS SP25-165278-SW SP25-165351 SP25-165351-LU SP25-165351-CS SP25-165351-SW SP25-165409 SP25-165409-LU SP25-165409-CS SP25-165409-SW SP25-165413 SP25-165413-LU SP25-165413-CS SP25-165413-SW SP25-165492 SP25-165492-LU SP25-165492-CS SP25-165492-SW SP25-165581 SP25-165581-LU SP25-165581-CS SP25-165581-SW SP25-165651 SP25-165651-LU SP25-165651-CS SP25-165651-SW SP25-165889 SP25-165889-LU SP25-165889-CS SP25-165889-SW

• In TEST (all 12 missing WO parents, caused errors, removing for test import)

[rebekkabry]

Updates 9/29/24

• OCE and DTS GIS updated the Assetnum for Seal Coat, Crack Seal and Overlay
• OCE will send FogSeal when able to update
• During TEST upload for OVERLAY have errors for no CONCW work type. (based on SP24-138773 example updatting Worktype to CW for all)

Upload Status

- Uploaded

• all Crack Seal WO/ Service Address/Specifications
• all Overaly WO/ all Overaly Service Address
• Seal Coat Parent Work Orders

- Pending Uploads:

• all Fog Seal (pending updated file)
  • Seal Coat Children, all Service Address, all Specifications (errors with Children WO)
  • Overlay Specificiations (errors)

[rebekkabry]

[rebekkabry]

Error to Follow Up On

- Overlay Specifications - unable to load Specifications

[rebekkabry]

Updates 10/9/24

Reattempt of failed datasets

• [x] all Fog Seal (pending updated file from OCE
  • [x] parents
  • [x] children
  • [x] service address
  • [x] specifications
• [x] Seal Coat Children, all Service Address, all Specifications (errors with Children WO)
  • [x] children
  • [x] service address
  • [x] specifications
• [x] Overlay Specificiations (errors)

[rebekkabry]

10/14/24

• Received updates from CTM
• Attempting FOG

[rebekkabry]

10/15/24

Completed Overlay, Fog Seal Children, Service Address.

[rebekkabry]

11/21/24

all have been added Overlay CONWT work workorders are giving errors. Following up with CTM on assistance.