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?
Tags:
e1,
enterpriseone,
EnterpriseOne - SQLs,
omw,
sql
August 4, 2008 | EnterpriseOne - SQLs | No Comments »