Quick Tip: Decline All Update Packages Using SQL

Read Time:31 Sec

A quick way to decline all packages that have been marked for deployment on a development client is use SQL:

UPDATE SY900.F98825
SET UPINPKST=40 --Decline
WHERE UPMKEY='DEV_CLIENT_NAME'

Use case:
Development client has been around for a while. You’ve since deployed many update packages. The developer has neglected to take all the update packages. Something goes wrong and you have to install the latest full package. Well, that full package contains all the code changes from the update packages. So, even though those update packages will show up upon login, they are not required in order to stay current.

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%

One thought on “Quick Tip: Decline All Update Packages Using SQL

  1. You actually make it seem really easy with your presentation however I in finding this matter to be actually one thing that I feel I
    would by no means understand. It sort of feels too complicated and extremely huge for me.
    I am taking a look ahead for your next publish, I’ll
    attempt to get the grasp of it!

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 Quick Tip: Change A Scheduled Job’s Time Zone Using SQL
DSI-Unibar-Warehouse Next post Unibar ELS Enterprise Print To File