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 SEPTEMBER 23, 2016

Applies to:

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

Symptoms

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
----------
Error: Cannot Insert duplicate Key PS_INTFC_FIN. The process is ABEND at Step MTM_LIB_AM.00000510.Step20 (SQL) -- RC = 805"

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