CMCICU: Update Standard Cost Process having performance issue or not completing (文档 ID 1588583.1)

In this Document

APPLIES TO:

SYMPTOMS

On  Cost Maintenance, Standard Cost Update

ACTUAL BEHAVIOR
-----------------------
Update Standard Cost is taking too much time for completing

EXPECTED BEHAVIOR
-----------------------
Expect a better performance behavior for this process.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Cost Management >
2. Requests >
3. Run Update Standard Cost program

CAUSE

Code Issue

SOLUTION

EBS 11.5.10.2
------------------

1. Download and review the readme and pre-requisites for Patch 17450072.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

    cmlwru.lpc 115.32.115100.34
cmcicu.opc 115.26.115100.24
cmliru.lpc 115.23.115100.29
cmlicu.lpc 115.34.115100.26

    You can use the commands like the following:
strings -a $BOM_TOP/src/cmlwru.lpc |grep '$Header'

5. Retest the process

6. Migrate the solution as appropriate to other environments.

EBS 12.0.X
---------------

1. Download and review the readme and pre-requisites for Patch 8442125:R12.BOM.A

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:  

  cmlicu.lpc 120.6.12000000.7
CSTUTILB.pls 120.6.12000000.2
CSTSISCB.pls 120.2.12000000.4

  You can use the commands like the following:
strings -a $BOM_TOP/patch/115/sql/CSTSISCB.pls |grep '$Header'

5. Retest the process

6. Migrate the solution as appropriate to other environments.

EBS 12.1.X
---------------

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 22053665:R12.BOM.C.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

   cmlwru.lpc 120.9.12010000.8
cmcicu.opc 120.6.12010000.23
cmliru.lpc 120.9.12010000.11
cmlicu.lpc 120.6.12010000.23

    You can use the commands like the following:
strings -a $BOM_TOP/src/cmlwru.lpc |grep '$Header'

5. Retest the process

6. Migrate the solution as appropriate to other environments.

EBS 12.2.X
---------------

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 22053665:R12.BOM.D.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

   cmlwru.lpc 120.11.12020000.13
cmcicu.opc 120.14.12020000.19
cmliru.lpc 120.15.12020000.7
cmlicu.lpc 120.13.12020000.3

   You can use the commands like the following:
strings -a $BOM_TOP/src/cmlwru.lpc |grep '$Header'

5. Retest the process

6. Migrate the solution as appropriate to other environments.

Other Actions to be Considered

In case patch does not resolve the performance issue, we may be facing a new situation. In this case please log a Service Request providing the following required information:

ACTION PLAN
===========

Please answer/upload/read/proceed with the following:

1. Please read Doc ID 378348.1)  Data Collection Scripts for Cost Management. (For R11 and R12). Upload the output of the following costing diagnostic script:

CstCheck.sql (Cost Collector Script, shows cost setup by organization, File versions, invalid objects. Customer name is a required input and can be any name and is used for the name of the report. The output will be spooled as file name CstDiag115.txt)

2. Upload Standard Cost Update log file for the process with performance issue.

3. Generate TKPORF Trace File and upload RAW and TKPROF Trace files. For more information about generating trace files review the following document.
How To Trace a Concurrent Request And Generate TKPROF File (Doc ID 453527.1)

REFERENCES