My Oracle Support Banner

EAM: 9.2 AMRETFDA Fails when INTFC from PC with Multiple Add Rows and Installation Set with Retain All (Doc ID 2668280.1)

Last updated on JUNE 17, 2022

Applies to:

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


AMRETFDA Unique Constraint Error upon AMIF1000 for Assets with Multiple Add Rows and Installation Options Set with Retain All for Project Chartfield 

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1738  Error Position: 0  Return: 805 - ORA-00001: unique constraint (EMDBO.PS_INTFC_FIN) violated Failed SQL stmt: INSERT INTO PS_INTFC_FIN


  1. Set up Installation Options for *Project Chartfield Detail to Retain All
  2. Set up AM BU for auto retirement on the BU Definition
  3. Set up AM BU for auto retirement on the BU/Book Feature for books.
  4. Created new project in project costing
  5. Set Asset Integration rules
  6. Accepted default on filter criteria
  7. Added new status of I (In Service) for the project
  8. Created project activities
  9. Added Transactions for activities
  10. Express Asset Definition
  11. Select Activities
  12. Define Assets
  13. Express Capitalization Process
  14. Send from PC to AM
  15. Find interface in AM
  16. Run AMIF1000
  17. Run AM_DEPR_CALC and review process monitor for success
  18. Validate asset is fully depreciated
  19. Query report manager – AM_FULLY_DEPR_END_DPR_DT
  20. Run Auto-Retire R Copy changes to other books – run AMRETFDA to review AMIF1000
  21. AMRETFDA fails with unique constraint error




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.