E1 Tips

We have been having some issues lately where users create web-only versions and expect to use them after a full package has been built and deployed.

We have processes in place for them to submit new versions to our development teams, but sometimes things don’t happen the way they are designed.

Anyway, I was doing some checking and noticed that there were quite a few versions in the F983051 that were web-only versions and were older than the last full build.

So, I created an SQL that we are going to run immediately after the deployment of a new full package.

DELETE FROM <central objects>/F983051
WHERE VRVCC2='1' 

***NOTE: the syntax used in the SQL statement is for the IBM System i (as400, iSeries)

Stewart Schatz

• Owner of 9Rains Technology
• Oracle EnterpriseOne CNC Administrator for The Washington Corporations
• Owner/Operator for several websites: E1Tips.com, SharePoint-Geek.com, Bakken-Jobs.com just to name a few

Location: Missoula, MT USA

What I like to do: Spend Time With Family, Play Basketball, Coach Basketball, Hunt, Hike, etc.

More Posts - Website