Question

regenerate plan for all PM

  • 24 December 2020
  • 3 replies
  • 294 views

Badge +2

We would like to do in bulk for all PM - Re-generate plan. Any help appreciated?

As we use the RMB option to Re-generate plan for one PM in the PM action header ???

 


This topic has been closed for comments

3 replies

Userlevel 7
Badge +24

hi @sarfraz65vns 

I can’t see a button in IFS that lets you do that.

This could be done without too much difficulty using the DB procedure (PM_Action_API.Refresh_Plan__) either via a script or FNDMIG Data migration job, but you would need some technical expertise to do that.

Through the IFS client, it might work to use Find and Replace and set Generatable to No, and then back to Yes.  That might trigger the Regenerate plan, but i’m not sure.

 

 

Userlevel 6
Badge +14

Hi,

 

This should be done with a script using the Pm_Action_API.Refresh_Plan__

FOR rec_ IN get_pms_regenerate LOOP

      Pm_Action_API.Refresh_Plan__(rec_.pm_no, rec_.revision);

  END LOOP;

Userlevel 3
Badge +3

Hi,

I once solved this by creating a custom menu in Separate PM Actions ovw window. It was used for a support task but you can probably use this description as a base.

Regards

Pelle

 

Work Steps to create a Custom Menu in Separate PM Actions overview window

 

  1. Logon into the environment as an Application Owner (IFSAPP) or another user that have privileges to create custom menus.
  2. Open Separate PM Actions overview.
  3. Select RMB Properties.
  4. Check the ‘Include Custom Items’ box and click OK.
  5. Select RMB Custom Objects / Menus / Create New and fill in the following information.
    1. Description: ‘Regenerate PM Plan
    2. Action Type: ‘PL/SQL Block
    3. Menu Text: ‘Regenerate Plan
    4. Action Parameters / PL/SQL Block: ‘&AO.PM_Action_API.Refresh_Plan__(&PM_NO,&PM_REVISION);
    5. Presentation Object: ‘tbwPM
    6. Translations: ‘en-English       Regenerate Plan’ (or another line for the language wanted)
  6. Save the information.
  7. Open Separate PM Actions overview and see that you have a new RMB option Regenerate Plan. (If not try to logoff and logon again).
  8. Test this new Custom Menu by searching for the PM Actions that you want to update. Mark the lines that need to get their plans regenerated and select RMB Regenerate PM Plan. (If there will be a lot of PM Actions that need to get regenerated, the regeneration step can preferably be divided into several batches to not get into any performance issues.
  9. Open PM Action window and search for the PM Actions that was affected by the updated calendar.
  10. Go to Maintenance Plan tab and verify that the plan has been updated according to the calendar change.

Note! Afterwards this Custom Menu created probably need to be distributed to the users that need this function.