antoine_mpo
Reputable Poster
Hi list,
Since our architecture change (we were in Xe S20, Oracle 8i, websphere 4, with win2k servers, now we are in Xe S23_Q1, Oracle 10.2.0.3, Websphere 6) we are experiencing loss of processing options values at runtime.
It means that everyday, on some versions, all the po values disapear. It's not always the same versions (even if the most used version meet the issue more often).
We've got an opened case for this issue since 2007 may 31st.
So far we didn't find any solution (it's happening only in our production environment, and we cannot reproduce it in others).
When this issue occurs, it's a real pain in the ass because we have to put the values back by hand. And of course, one of the most used application is P4210, which have quite a lot of values ...
So i'd like to find a way to easily copy the processing options values (recorded in F983051.VRPODATA field) from a backup table to the in use table.
Does anyone knows a way to do so (PL/SQL, JDE bsfn, ube, ...) ?
Thanks a lot for your help
Since our architecture change (we were in Xe S20, Oracle 8i, websphere 4, with win2k servers, now we are in Xe S23_Q1, Oracle 10.2.0.3, Websphere 6) we are experiencing loss of processing options values at runtime.
It means that everyday, on some versions, all the po values disapear. It's not always the same versions (even if the most used version meet the issue more often).
We've got an opened case for this issue since 2007 may 31st.
So far we didn't find any solution (it's happening only in our production environment, and we cannot reproduce it in others).
When this issue occurs, it's a real pain in the ass because we have to put the values back by hand. And of course, one of the most used application is P4210, which have quite a lot of values ...
So i'd like to find a way to easily copy the processing options values (recorded in F983051.VRPODATA field) from a backup table to the in use table.
Does anyone knows a way to do so (PL/SQL, JDE bsfn, ube, ...) ?
Thanks a lot for your help