CMCPAW Periodic Actual Cost Worker raised the following error message CSTPPACQ.get_acq_cost ORA-01422 exact fetch

(Doc ID 1331498.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 27-FEB-2015***

CMCPAW Periodic Actual Cost Worker


On : 12.1.1 version, Inventory Costing

When attempting to run CMCPAW  Periodic Actual Cost worker the following error occurs.


CSTPPINV.COST_INV_TXN:CSTPPACQ.get_acq_cost(45):ORA-01422: exact fetch returns more than requested number of rows
Setting phase 5 status to ERROR
Processing failure on phase 5.

Check the Periodic cost processor log file. You will find a message saying
something like "No COGS Events found for transaction" ...

The issue can be reproduced at will with the following steps:
1. Go to Periodic Costing Responsibility
2. Run the Periodic Actual Cost Worker.


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