My Oracle Support Banner

Fusion PIM: Error ORA-01843 While Loading Item With EFF Date Attribute (Doc ID 2430419.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Oracle Fusion Manufacturing Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to perform an item import the following error occurs.

While loading items with EFF Date Attribute the process gets errored out
Record 1: Rejected - Error on table EGO_ITEM_INTF_EFF_B, column ATTRIBUTE_DATE1.
ORA-01843: not a valid month

The issue can be reproduced at will with the following steps:
1. Use the item import FBDI
2. Upload EFF attribute in the sheet and generate csv
3. Import fails with an error in the log


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

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