Maximo Open Forum

 View Only

 Adding Job Plan Description on the PM Forecast Tab (Maximo 7.6.1.3)

Jump to  Best Answer
  • Administration
  • Customizations
glenda creech's profile image
glenda creech posted 10-18-2024 21:41

Hello,

Has anyone been able to add the job plan description to the PM Forecast tab in the PM Application?  We are doing some job plan sequencing, and it is hard to show end users what the job plan sequence will look like as we just use numbers for our job plans.  I'd like to add another column into this table (via application designer) with the job plan description.  I've tried making a few relationships and adding in a description column for the job plan description, but I continue to end up with Invalid Binding.  Any help is greatly appreciated :)   Thank you!

Steven Shull's profile image
Steven Shull posted 10-19-2024 11:08  Best Answer

In database configuration, create a relationship from PMFORECAST to JOBPLAN. In my example I created one called EMXJOBPLAN. The relationship should be:

jpnum=:jpnum and ((orgid=:orgid and siteid=:siteid) or (orgid=:orgid and siteid is null) or (orgid is null and siteid is null) or (:orgid is null and :siteid is null) or (:orgid is null))



Then in Application Designer, reference your relationship like EMXJOBPLAN.DESCRIPTION. I did a quick test and this worked for me.

Related Content