filizrae
Member
Hi All,
Since migrating from db2 to oracle 9i 18 months ago, we've been experiencing an annoying problem - users locking the next number F0002 table.
We have logged this problem with Oracle and have spoken with many people without a successful resolution. I'm hoping that you guys might give a different insight into the problem...
When AP are entering data and someone goes into supplier details, this locks the next number table, causing everyones screen to lock. We have written a couple of quick sql scripts that show who is causing the lock and we get that person to exit the screen which releases the lock.
These are standard JDE screens and no one other than us seem to experience this issue. We have provided Oracle with a jde.log showing the dead lock, but cannot produce this with debug turned on.
Does anyone have any ideas or suggestions? Other than this issue, our system is working quite well...
Regards,
Filiz
JDE CNC Administrator
EnterpriseOne 8.9 SP2
Database: Oracle 9i on AIX 5.3
Ent Server: windows 2003
Since migrating from db2 to oracle 9i 18 months ago, we've been experiencing an annoying problem - users locking the next number F0002 table.
We have logged this problem with Oracle and have spoken with many people without a successful resolution. I'm hoping that you guys might give a different insight into the problem...
When AP are entering data and someone goes into supplier details, this locks the next number table, causing everyones screen to lock. We have written a couple of quick sql scripts that show who is causing the lock and we get that person to exit the screen which releases the lock.
These are standard JDE screens and no one other than us seem to experience this issue. We have provided Oracle with a jde.log showing the dead lock, but cannot produce this with debug turned on.
Does anyone have any ideas or suggestions? Other than this issue, our system is working quite well...
Regards,
Filiz
JDE CNC Administrator
EnterpriseOne 8.9 SP2
Database: Oracle 9i on AIX 5.3
Ent Server: windows 2003