Solution : https://service.sap.com/sap/support/notes/545932 (SAP Service marketplace login required)
Summary :
If you are experiencing performance issues with database runtime during the period-end closing transactions in Cost Object Controlling (CO-PC-OBJ), follow the provided correction instructions. These are specific to varying database systems (SQL Server, Oracle, DB2), and are tailored for issues such as transaction slow-downs during production order processes or co-product settlements. Implement modifications cautiously; verify if a modification resolves the problem before proceeding with others. Notably, these corrections cannot be implemented through Transaction SNOTE and must be done manually. Refer to the individual instructions linked through correction instruction numbers for detailed steps and additional context.
Key words :
sql trace shows extremely costly accesses, manufacturing orders / product cost collectors, actual settlement production/process orders, production order/process order, period-end closing reason, cost object hierarchies run, period-end closing transactions, product cost collectors, period-end closing, -products/rework orders
Related Notes :
1079126 | Performance probl. in CO-PC-OBJ per-end closing: Oracle Hint |
740626 | Cost Object Controlling: Performance Objectselection |
712624 | High CPU consumption by Oracle |
544322 | Performance of CO period-end closing with SQL Server 2000 |