Big issue with us F0911 Primary Index F0911_0 not correct in Oracle database

We found a issue with oracle(9.2.7)+ Hpux 11. The F0911's primay index in oracle database not equal to it's spec.
In JDE index F0911_0's spec as following:
GLDCT ASC,GLDOC ASC,GLKCO ASC,GLDGJ DESC,GLJELN ASC,GLLT ASC,GLEXTL ASC

But in Oracle database F0911_0 is sort by GLDCT ASC,GLDOC ASC,GLKCO ASC,GLDGJ ASC,GLJELN ASC,GLLT ASC,GLEXTL ASC.

The utb is very slowly when we use UTB open F0911 and press find button (do not enter anything in QBE).

You can always re-generate this index, using JDE and see if this fixes it. You should do this, when here are no users in the system.

On the other hand, this will have no effect on what is essentially a full table scan - retrieving all rows from this table without using any filters. This is bound to be slow.