My Oracle Support Banner

Unique Constraint Violated For Index FA_MC_DEPRN_SUMMARY_H_U1 (Doc ID 1571696.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

MRC was recently incorporated into a new Corp book. Depreciation had already been run for the Corp book period without closing, so when a new Transfer was performed, it invoked the Deprn Rollback package, why did it return this set of errors?

APP-OFA-48396: Program exited with errors
ORA-00001 unique constraint (FA.FA_MC_DEPRN_SUMMARY_H_U1) violated
Error: function fa_deprn_rollback_pvt.do_rollback returned failure
Error: function fa_deprn_rollback_pub.do_all_books returned failure
Error: function fa_deprn_rollback_pub.do_rollback returned failure
Error: function FA_TRANSFER_PUB.do_transfer returned failure
 

Solution

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
Goal
Solution


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