jimmymac
Reputable Poster
We are on E1 9.0, tools release 8.9.42. I am building and deploying a package to production that includes a table change to a custom table. We have added a few fields to this custom table.
My question is in regards to the table change. From what I've gathered and am also told by oracle/jde, is that when you deploy the package to your production environment, you still have to manually rebuild the table in OMW. So the step s will be to deploy the package to production. Then sign on to a production fat client, and in OMW go into table design aid and choose Generate Table. It seems I would need to first do a get to get the now new table specs for that table onto the fat client. Then generate the table and indexes.
That all makes sense but certainly seems a bit of a manual and quirky process. Is there some other simpler way or is this just the way it has to be done.
It occurred to me, that after deploygin the package to production, I could install that update package on my fat client also. But it seems a quick Advanced get of the table would serve the same purpose and be quicker and safer given I will have a bit of a tight window for deploying and affecting this change.
Any thoughts are appreciated.
My question is in regards to the table change. From what I've gathered and am also told by oracle/jde, is that when you deploy the package to your production environment, you still have to manually rebuild the table in OMW. So the step s will be to deploy the package to production. Then sign on to a production fat client, and in OMW go into table design aid and choose Generate Table. It seems I would need to first do a get to get the now new table specs for that table onto the fat client. Then generate the table and indexes.
That all makes sense but certainly seems a bit of a manual and quirky process. Is there some other simpler way or is this just the way it has to be done.
It occurred to me, that after deploygin the package to production, I could install that update package on my fat client also. But it seems a quick Advanced get of the table would serve the same purpose and be quicker and safer given I will have a bit of a tight window for deploying and affecting this change.
Any thoughts are appreciated.