Depreciation Error APP-OFA-47136 Fiscal Year XXXX Is Shorter Than Calendar Year, APP-OFA-47150: Error: Unable to Insert Calendar Period Records (Doc ID 1926605.1)

Last updated on OCTOBER 18, 2017

Applies to:

Oracle Assets - Version 12.0.0 and later
Information in this document applies to any platform.
FADEPR
End of Fiscal Year program

Symptoms


When attempting to run Depreciation, the following error occurs.


Depreciation Program Exception Report
At beginning of End of Fiscal Year program
APP-OFA-47707: Date: 12/09/2014 01:01:57
APP-OFA-47709: Fiscal Year: 2014
APP-OFA-48208: faeccfy: book_info->cur_fy has the value of 2014.
APP-OFA-48208: faeccfy:book_info->fy_name has the value of ABC Fiscal Year.
APP-OFA-47136: Fiscal Year 2014 is shorter than calendar year
APP-OFA-47136: Fiscal Year 2015 is shorter than calendar year
APP-FND-01564: ORACLE error 1 in faenicp

Cause: faenicp failed due to ORA-00001: unique constraint (FA.FA_CALENDAR_PERIODS_U3) violated
.

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

Cause: You have a database problem.

Action: Contact your system administrator.

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

-OR- Cause could say:    Cause: faenicp failed due to ORA-00001: unique constraint (FA.FA_CALENDAR_PERIODS_U1) violated
-OR- Error seen as: Depreciation Program Exception Report
At beginning of End of Fiscal Year program
APP-OFA-47707: Date: 23/06/2016 11:51:19
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 CORPORATE.
APP-OFA-47129: Fiscal Year 2016 is as long as a 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

 

Cause

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