My Oracle Support Banner

FA:SCM:IB FBDI Template for Maintenance Assets Gives ORA-01841 error (Doc ID 2367500.1)

Last updated on DECEMBER 06, 2019

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


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


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