Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Transaction VKOA issue

Former Member

‎12-26-2011 6:09 AM

0 Kudos

hello All,

We are facing some issues with transaction VKOA

User is able to access transaction vkoa, but when he click on 1st table entry ie Cust.Grp/MaterialGrp/AcctKey

it get stucked for lot of time.

In process overview it is showing Delete action for table D010INC

hence i tried with SAP* user but same thing happen with this user also

An anyone tell me why this is happening.

1 REPLY 1

former_member188883
Active Contributor

‎12-26-2011 7:10 AM

0 Kudos

Hi Amol,

User is able to access transaction vkoa, but when he click on 1st table entry ie Cust.Grp/MaterialGrp/AcctKey 
it get stucked for lot of time. In process overview it is showing Delete action for table D010INC

Reason and Prerequisites

The long execution time on the statement mentioned above is generally caused by missing or outdated statistics for the database optimizer so that the optimizer chooses an incorrect access plan. This response was observed on Oracle databases, but may also occur on other database platforms.

Solution

Create optimizer statistics for the table D010INC. When you do this, you must also ensure that the optimizer statistics are regularly created for the other tables.

Note 588668 contains all the information about database statistics for Oracle.

Basis team can perform the statistics update.

Hope this answers your query.

Regards,

Deepak Kori