بسم الله الرحمن الرحيم
in this post I will illustrate how to Create a primal Preventive maintenance functionality.
I suppose the requirement is to generate a WOs on Asset or location with job plan based on a frequency of days.
this solution implemented on SCCD 7.5.1 and DB2
- Solution summary (the solution based on create a WO from another one)
- Create new 4 attributes(PM_nextduedate,PM_previousduedate,frequncey and pmflg)By A database configuration application
- Duplicate Workorder tracking Application By Application designer
- Ceate an escalation to generate a WO and calculate the next due date
- Solution Details
- 1 Create new needs attributes from Database Configuration application
- 2 open GOTO--> System Configuration --> platform configuration-->Database Configuration
- 3 filter on workorder object and add the following attributes
Attribute | Type | description |
---|---|---|
PM_nextduedate | DATE | Hold the next due date |
PM_previousduedate | DATE | Hold the last time WO GEN |
frequncey | integare | The frequency for WO generation(my unit is in day) |
pmflg | YORN | To flag the PMs records in Workorder table |
- 4 run admin mod and apply the configuration.
2.0 Duplicate WOTRACK APP
2.6 add a default value object and set pmflg=1
2.7 add the add attributes in 1.3 to be like following
3.1 create a new Escalation as following table
Table Header | Table Header |
---|---|
Escalation | WOAUTOGEN |
Description | TAMIT - WO Auto generation |
Applies To | WORKORDER |
Conditionc | pmflag = 1 and date(pm_nextduedate) = date (current date) and status ='APPR' |
Schedule | set it to every day |
Create Successful Execution Entry? | CHECK |
3.2 add a new escalation point and check repeat checkbox.
3.3 we will add 3 action in action section as following
Action | desc | Object | Type | value | Paramter/attribute |
---|---|---|---|---|---|
1100 | set pervois date = current date | WORKORDER | Set Value | :&DATE& | pm_perviousduedate |
Table Cell | set the next due date | WORKORDER | Set Value | :&DATE& + :pm_frequency | pm_nextduedate |
Table Cell | generate a WO | WORKORDER | Application Action | CREATEWO |
3.4 after that Activate the escalation
4.1 finally you will need to add the jpnum in WO2WO DOMAIN to be able to copy the job plan to the generated WO
GOTO--> System Configuration --> platform configuration -->domains
4.2
filter on WO2WO
4.3 add jpnum in both source and destination
For now the solution is ready for work , may be need for more enhancement, Let us discover it together .