My Oracle Support Banner

EAM 9.2: Unique Constraint (SYSADM.PS_ASSET_ACQ_DET) When Rnning Transaction Loader (AMIF100) On Assets Loaded Via The INTFC_FINPHY_SS_A ExceltoCI Template (Doc ID 2460935.1)

Last updated on JUNE 17, 2022

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


When running Transaction Loader (AMIF100) on assets loaded via the INTFC_FINPHY_SS_A ExceltoCI template, it produced the following error: ORA-00001: unique constraint (SYSADM.PS_ASSET_ACQ_DET) violated Failed SQL stmt: INSERT INTO PS_ASSET_ACQ_DET

The issue can be reproduced at will with the following steps:

1. Use the INTFC_FINPHY_SS_A ExceltoCI template to upload assets into PeopleSoft
2. Run Transaction Loader (AMIF1000)




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.