EAM: MTMTOOL Fails With Duplicate Key Row in PS_INTFC_FIN When Asset Has Multiple Cost Rows (Doc ID 2307670.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Doing a book change using Mass Transaction. Added a new template to include the calculation type.
MTM fails with the following error.

ERROR
----------
[SQL Server]Cannot insert duplicate key row in object 'dbo.PS_INTFC_FIN' with unique index 'PS_INTFC_FIN'. The duplicate key value is (10001877010314ELEV-11 CORP 2017-04-24 14:27:18.000 00

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