My Oracle Support Banner

EAM: Mass Transaction Process MTMTOOL Fails With 'Cannot Insert Duplicate Key PS_INTFC_FIN' When Asset is in 2 Deptids and Transfer Is to a New Deptid (Doc ID 2161685.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


When using the Mass Transaction template of 'TRF-Full Asset Transfer', transferring to a new department id, and if the assets are in more than 1 department, MTMTOOL will fail.

Error: Cannot Insert duplicate Key PS_INTFC_FIN. The process is ABEND at Step MTM_LIB_AM.00000510.Step20 (SQL) -- RC = 805"


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.