E1Tips.com - SQL Ninja

How To Disable Client Package Deployment

Read Time:48 Sec

If you have a development client that has been neglected and JDE wants you to install 15 update packages but all you really want to do is install the latest and greatest full package, you could select each row individually and click the “Decline” Row Exit 15 times.

I don’t like repetition and avoid it at all costs, which means that for some of my “shortcuts” take a long time to come up with and may or may not be worth the time saved. Well, that’s why I put it here. Maybe someone else can save some time even if it did take me 2 hours to come up with a 5 second fix for a 30 second problem.

Here is the SQL to remove the client deployment records from the F98825 so you don’t have to click “Decline” so many times:

DELETE FROM SY910/F98825             
WHERE UPJDEPKGNM LIKE 'DVFU%'        
AND UPMKEY LIKE 'E1%'                
AND UPINPKST=20  

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.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

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 A Work Submitted Job (WSJ, P986110B) Grid Format You Can’t Live Without!
E1Tips Qucik Tip Next post Quick Tip: 3 Ways To Truncate a File in Linux