CMCCCI module: Material Cost Collection Worker fails with: CSTPPCCB.pm_check_error_mmt(60): ORA-01422: exact fetch returns more than requested number of rows * TXN MARKED IN MMT (Doc ID 1492367.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Oracle Project Manufacturing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

CMCCCI module: Material Cost Collection Worker

fails with

DEBUG: Calling pm_cc_worker - Txn Id = 2835742.000000
DEBUG: INV_PROJ_MISC_TXN_EXP_TYPE (0:system defined, 1:user entered) is 1
2835742.000000 -- -00001422  - CSTPPCCB.pm_check_error_mmt(60): ORA-01422: exact fetch returns more than requested number of rows * TXN MARKED IN MMT. * TXN MARKED IN MMT.

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