Changing A Package Deployment Status Using SQL
Share
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.
More Stories
Needle: Package Manifest Browser
Here is a common discussion between a CNC Admin and a JDE Development Manager (if you are lucky enough to...
Needle – Overview of Specifications (SPEC) in Oracle JDE EnterpriseOne
I'm starting a new category of posts called "Needles". It is going to have Oracle Support Documents that I have...
Better Performance On Work with Payroll Transaction Ledger (P050999) With An Index On F0618
We have been getting complaints about the Work with Payroll Transaction Ledger (P050999) grid loading performance. So, I decided to...
VBScript To Insert Values Into UBE Data Selection List Of Values
First off... Shannon Moir ROCKS! He has put together a VBScript that will insert a list of values into the...
Recover Lost Disk Space
We currently share development clients and so there can be many people that use each one. Several times some of...
Error Installing An Update Package On An E1 Development Client
Every once in a while we get errors when installing update packages on our E1 Development Clients. An error occurred...
Average Rating