R12.1 and later: Depreciation Run Error APP-OFA-47155: Error: Unable to Insert Convention Records

(Doc ID 2088002.1)

Last updated on JULY 10, 2017

Applies to:

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


When attempting to Run Depreciation (FADEPR)the following error occurs.


FADEPR module: Depreciation Run

At beginning of End of Fiscal Year program
APP-OFA-47707: Date: 15/07/2015 21:42:17
APP-OFA-47709: Fiscal Year: 2016
APP-OFA-48208: faeccfy: book_info->cur_fy has the value of 2016.
APP-OFA-48208: faeccfy:book_info->fy_name has the value of FiscalSepAug.
APP-OFA-47136: Fiscal Year 2016 is shorter than calendar year
APP-OFA-47129: Fiscal Year 2017 is as long as a calendar year
APP-OFA-47128: Inserted 0 calendar period records
APP-FND-01564: ORACLE error 1 in faecicv

Cause: faecicv failed due to ORA-00001: unique constraint (FA.FA_CONVENTIONS_U1) violated

The SQL statement being executed at the time of the error was: and was executed from the file .
APP-OFA-47155: Error: Unable to insert convention records

Cause: You have a database problem.

Action: Contact your system administrator.

APP-OFA-47715: Error: function faecicv returned failure (called from faeofy)
Module End of Fiscal Year ended with error
APP-OFA-47715: Error: function faeofy returned failure (called from FADEPR)


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