My Oracle Support Banner

Depreciation Ends With ORA-00001 on FA_CALENDAR_PERIODS_U3 (Doc ID 353463.1)

Last updated on APRIL 01, 2024

Applies to:

Oracle Assets - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Year End Program


Depreciation program ends with following error:
    Fiscal Year: 20XX
    Fiscal Year 20XX is as long as a calendar year
    Fiscal Year 20XXis as long as a calendar year
    APP-OFA-48208: X_cal_type has the value of POL.
    APP-OFA-48208: X_start_date has the value of mm/dd/YYYY
    APP-OFA-48208: X_end_date has the value of mm/dd/YYYY
    APP-OFA-48208: X_per_num has the value of 1.
    APP-OFA-48208: X_per_name has the value of mth-yy.
    APP-FND-01564: ORACLE error 1 in faecicp
    Cause:  faecicp 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 .
    Error: Unable to insert calendar period records
    Cause: You have a database problem.
    Action: Contact your system administrator.
    Error: function is_cal_yr_ins_cp returned failure (called from faeofy)


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
 Still Have Questions?

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