Remove The Owner From An OMW Project
Read Time:30 Sec
In the past I wrote a post called “EnterpriseOne (E1) OMW Cleanup”. I used a SQL statement to remove my UserID from Object Management Workbench (OMW) projects that were automatically created by the ESU installation process.
Today, I used that same SQL to remove my UserID from OMW projects that the development team has requested that I move to a status 38. We do this to satisfy some auditing requirements and to stay consistent with other systems that we have.
Anyway, here is the SQL, again…
DELETE FROM sy811/f98221 WHERE PUOMWUSER ='userid' AND PUOMWPRJID LIKE '%projectname%'
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Valuable content. Will revisit soon. Thanks