Hi All,
We are creating sales orders using oracle middleware in oracle ebs. As there are thousands of orders coming on real time basis middleware is using connection pooling.
We are having 6 PLSQL packages, one called by midleware and that main package is calling all other packages. All these packages are using global variables heavily. We even have package spec level variables.
Our problem is with order booking, we investigated and found that value of some global variables is now coming as expected.
I need inputs to troubleshoot this issue, why the value of global variables is changed in many session and not coming correctly.
Do I need to reset package variable state everytime ? does it have any performance issue ? do i need to call then in package spec/body or initialization section.
Please advise how to get bottom of issue caused by global variables.