E1 Tips

Over a year ago, I wrote about how to delete User Overrides in EnterpriseOne.

Well, I had to use that process the other day and felt I should probably publish a fix to an unfortunate effects of using the User Overrides application.

What are these effects?  Well, when you delete a User Override, it is first placed in your default project and then deleted.  Unfortunately, after it is deleted, the object is not removed from your project.

So, to clean up what could be hundreds of objects from your default project, run the following SQL:

DELETE FROM SY811/F98222  
WHERE POOMWUSER ='***userid***'
AND POOMWOBJID LIKE '%GF%'

Can you think of anything that would make this easier?
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

Stewart Schatz

• Owner of 9Rains Technology
• Oracle EnterpriseOne CNC Administrator for The Washington Corporations
• Owner/Operator for several websites: E1Tips.com, SharePoint-Geek.com, Bakken-Jobs.com just to name a few

Location: Missoula, MT USA

What I like to do: Spend Time With Family, Play Basketball, Coach Basketball, Hunt, Hike, etc.

More Posts - Website