Changing A Package Deployment Status Using SQL

Read Time:24 Sec

We have been trying to setup multi-foundation on Oracle JDEdwards EnterpriseOne 9.0 and have run into some issues with package manifests and such. Once in a while 2 full packages for the same pathcode show up as “deployed” in the package assembly screen. So, since the package is “deployed”, you can not delete it. Below is the SQL statement that I use to mark the package as not deployed:

update sy900/f9603
set PHISPTF=0
where phpkgname='[PACKAGENAME]'

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 JD Edwards EnterpriseOne 9.0 Standalone Installation
Next post Oracle Releases JD Edwards EnterpriseOne Tools Release 9.1