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%'

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com

Average Rating

5 Star

4 Star

3 Star

2 Star

1 Star

(Add your review)

One thought on “Remove The Owner From An OMW Project”

Luis Bertrand says:

October 27, 2010 at 9:51 AM

Valuable content. Will revisit soon. Thanks

Reply

How to Print a Directory Structure Using PowerShell: Step-by-Step Guide

If you need to print out the directory structure and list the files within, this PowerShell script will help you...

Stewart Schatz

June 7, 2024June 14, 2024

Windows God Mode… What!?!

Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.

Stewart Schatz

January 5, 2023October 23, 2023