My Oracle Support Banner

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

Applies to:

Oracle Assets - Version 12.0.0 and later
Oracle Fusion Assets Cloud Service - Version 11.13.17.11.0 to 11.13.17.11.0 [Release 1.0]
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: MM/DD/YYYY HH:MM:SS
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 &BOOK.
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: MM/DD/YYYY HH:MM:SS
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 &FISCALYEAR.
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

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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