One of the core feature's of OMW(Object Management Workbench) administration in JDE is the Activity Rules and their setup.
Activity rules govern the type of actions that are feasible for a given status of a project in OMW.
Let's begin with a specific example. My test setup has a status 71 which is used by the developers to denote that the project is ready for production move. This status however does not allow the CNC to do a "get", which is a good practice to ensure the latest code is promoted to production.
So if 71 is prod-ready, the CNC will have to move the code to 65 (QA) to do a get and then send it to 71 and finally send it to 72 (Production).
If the CNC now decides to update the activity rule so that "get" can be done for all the projects in status 71, following are the steps the CNC would have to carry out:
- Go to GH9081
- P98230
- Launch the Activity Rules
- Click find
- Highlight Status 71
- Click Add
- On the Project Status Activity Rule screen, put 71 in the From Project Status
- Add an entry for the role for which the "get" needs to be enabled
- Click OK
- Click Find
- Double click the new entry for 71 that just got created
- Add the Object Types that are needed for Allowed action type 05
- Click OK
The following SQL should give all the entries in F98225 for our scenario:
SELECT TROMWFPS, TROMWTPS, TROMWUSER, TROMWOT, TRSRCRLS, TRTRGRLS, TROMWSRCLOC, TROMWTRGLOC, TROMWAC, TROMWRLSTK, TROMWACTFLG, TROMWTMS1, TROMWTMS2, TROMWTMN1, TROMWTMN2, TROMWTMN3, TRPID, TRMKEY, TRUSER, TRUPMJ, TRUPMT, TRTIMEZONES, TRDSAVNAME FROM SYSXXX.F98225 WHERE ( TROMWTPS = '71' AND TROMWFPS = '71' ) ORDER BY TROMWOT ASC,TROMWSRCLOC ASC
