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 JANUARY 16, 2020
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