CMCPAW Periodic Actual Cost Worker Performance Issue CSTPPACQ.get_charge_allocs ORA-30036 (Doc ID 1292481.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The periodic average costing processors are run in order to close the period.
The first request, Periodic Acquisition Cost Processor, starts the Periodic Actual Cost processor which runs for hours without finishing.
There is an error in the logfile for CMCPAW module: Periodic Actual Cost Worker. There has been a recent upgrade from existing 11.5.9 HR to 12.1.1 and new implementation of Purchasing, Inventory, Project Costing, Payables.
Before this performance issue, the program took about 5 minutes to complete. Expectation is that it should take no longer than 10 minutes to complete.
The last time that it ran normally was on 14th December. Then the next run was on 17th December and it was running for more than a day and ended with error when it hit a tablespace issue.
The DBA checked the Alert log and it is clean from any database issues (e.g., tablespace, max extent)

Gather Schema Statistics is run Weekly on all Schemas.
These are run through the application > System Administrator > Gather Schema Statistics
Estimate percentage used: 10
Last time stats where gathered: 20th December
Ran run the Gather Schema Statistics for AP, INV with Estimate percentage 50 on Wednesday, 22-Dec-2010
Run the Gather Schema Statistics for BOM, WIP with Estimate percentage 10 on Wednesday, 22-Dec-2010

ERROR
-------
CSTPPACQ.get_charge_allocs(30):ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1' : There was an error in obtaining the special charge allocations for the Invoice distribution matched to the receipt being processed.
Processing failure on phase 1.

$ strings -a $BOM_TOP/bin/CMCACW | grep '$Header' | grep 'cm.*.*.pc'
$Header: cmlacw.lpc 120.15.12010000.5 2008/10/30 06:09:58 lchevala ship $
$Header: cmlccu.lpc 120.2 2006/05/10 16:58:06 sheyu noship $
$Header: cmlctw.lpc 120.0 2005/05/25 05:53:05 appldev noship $
$Header: cmlutl.lpc 120.3 2006/02/14 23:27:01 ggautam noship $
$Header: cmluwp.lpc 120.0.12000000.1 2007/01/17 12:39:41 appldev ship $
$Header: cmlwrx.lpc 120.3 2007/06/02 00:55:38 hyu ship $
$Header: cmlwsx.lpc 120.2 2006/05/12 09:16:33 sikhanna noship $
$Header: cmlcpx.lpc 120.0 2005/05/25 04:19:50 appldev noship $
$Header: cmlcfm.lpc 120.5 2007/05/21 23:57:10 vtkamath ship $
$Header: cmlwmx.lpc 120.0 2005/05/25 04:50:08 appldev noship $
$Header: cmlwsv.lpc 120.5 2007/09/21 08:04:14 svelumur noship $
$Header: afpcmn.lpc 120.7.12010000.2 2008/08/10 02:01:08 jtoruno ship $
$Header: afpcmt.lpc 120.0 2005/05/07 17:01:04 appldev ship $
$
$ strings -a $BOM_TOP/bin/CMCTCM | grep '$Header' | grep 'cm.*.*.pc'
$Header: cmltcm.lpc 120.1 2007/06/27 18:24:56 vjavli ship $
$Header: cmlwcm.lpc 120.1 2006/05/12 06:57:30 sikhanna noship $
$Header: cmlmcm.lpc 120.8.12010000.4 2008/12/28 13:22:58 anjha ship $
$Header: cmlacm.lpc 120.10 2008/01/25 01:45:23 ipineda ship $
$Header: cmlccu.lpc 120.2 2006/05/10 16:58:06 sheyu noship $
$Header: cmlutl.lpc 120.3 2006/02/14 23:27:01 ggautam noship $
$Header: afpcmn.lpc 120.7.12010000.2 2008/08/10 02:01:08 jtoruno ship $
$Header: afpcmt.lpc 120.0 2005/05/07 17:01:04 appldev ship $


STEPS:
-----------------------------
Cost Management > Periodic Costing > Periodic Average Costing > Periodic Acquisition Cost

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms