E1 Tips The Tips & Tricks of a CNC Administrator on Oracle JDEdwards EnterpriseOne

EnterpriseOne (E1) OMW Cleanup

When installing ESUs, an OMW project is created. If you have installed a lot of ESUs those projects can make it very annoying when trying to find other legitimate projects that you have access to. Yes, you can filter the OMW Project display, but I kinda find that annoying too. Anyway, I created a very simple SQL that I run once in a while to clean up my OMW:

DELETE FROM sy811/f98221
WHERE PUOMWUSER =’userid’
AND PUOMWPRJID LIKE ‘JJ%’

Of course the syntax will need to be adjusted if using a database other than an IBM iSeries.

pf button EnterpriseOne (E1) OMW Cleanup
evernote EnterpriseOne (E1) OMW Cleanupdigg EnterpriseOne (E1) OMW Cleanupshare save 171 16 EnterpriseOne (E1) OMW Cleanup

Leave a Reply