Deleting User Overrides In EnterpriseOne (E1)

Read Time:53 Sec

Once in a while my power-user wants to delete some User Overrides because they created some that they want everyone to use. Well, the UO app usually works pretty well, until your get some can not be deleted with the normal process. Here is the process that I go through:

1. Open a ?Fat Client? in the environment in which want to delete the UO
2. Fastpath to UO
3. Use the QBE to find the UOs that you would like to delete
4. Highlight them and click delete
5. NOTE: If some of them do not delete and give you an error like ?The object is in an open project?:
* Run a SQL statement similar to the following from the green screen to select the records desired and then delete them:

SELECT * FROM copy811/f98950 WHERE UOUSER ‘*PUBLIC’ and
UOOBNM=’Pxxxx’ and UOFMNM=’WxxxxA’ and UOVERS=’XJDE0016′

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

When working at home, starting with cheap web hosting is best and hence midphase or powweb are better choices.

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.

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Introduction to Oracle EnterpriseOne (E1)
Next post E1 Upgrade From Tools Release 8.95.P1 to 8.96.xx