FA:SCM:IB FBDI Template for Maintenance Assets Gives ORA-01841 error
(Doc ID 2367500.1)
Last updated on MAY 17, 2021
Applies to:
Oracle Maintenance 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.
Symptoms
When attempting to upload FBDI template for Maintenance Assets, the following error occurs.
Record 1: Rejected - Error on table FUSION.CSE_ASSETS_INT column ACTIVE_END_DATE.
ORA-01841: (full) Year Must Be Between -4713 And +9999, And Not Be 0
ORA-06512: at "FUSION.CSE_LOAD_INTERFACE_UTILS_PKG", line 88
ORA-01841: (full) Year Must Be Between -4713 And +9999, And Not Be 0
ORA-06512: at "FUSION.CSE_LOAD_INTERFACE_UTILS_PKG", line 88
The issue can be reproduced at will with the following steps:
1. Generate the CSV File using the excel file using the "Load Interface File for Import" in Scheduled Process for the "Import Process: Import Assets".
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 |
| Cause |
| Solution |