Error for Upload Asset Calendar: The end date of the last period in a fiscal year must be the same as the end date of the fiscal year (Doc ID 2961520.1)

Last updated on JULY 17, 2023

Applies to:

Symptoms

Unable to Upload Daily Asset Calendar from Manage Asset calendar Import function.

ERROR
-----------------------
Business object: Fixed Asset Calendar. Status: Completed with errors. Status details: Review and report the errors for this object to product Assets.
Detail Object: CalendarType. Status: Completed with errors. Status Details: A total of 1 rows were processed. 1 rows of them failed and 0 rows completed with warnings.. Started: 7/10/23 1:40 PM. Ended: 7/10/23 1:42 PM.
Row Identifier: PSN_AMM_GG. Status: Error. Message Code: FA_CAL_FY_LAST_PERIOD_END_DATE. Message Text: The end date of the last period in a fiscal year must be the same as the end date of the fiscal year.
The data row that caused the exception exists in the FA_CALENDAR.csv file.
The data row can be found in batch file CalendarType/1_BATCH.zip.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to Setup and Maintenance
2. Financials -> Manage Asset Calendars
3. Click on 'Actions' button
4. Export CSV file
5. Modify the file ORA_FA_CALENDAR_PERIOD.csv
6. Import CSV fil

Cause

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