My Oracle Support Banner

FBDI import error while loading on-hand: Error on table INV_TRANSACTION_LOTS_INTERFACE, column D_ATTRIBUTE1. (Doc ID 2483107.1)

Last updated on MARCH 01, 2021

Applies to:

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

Symptoms

Inventory Transactions On Hand Balances FBDI Upload fail with Error on Date format
 

ERROR
-----------------------
When trying to load on-hand using FBDI , facing below mentioned error:

Date Rejected - Error on table INV_TRANSACTION_LOTS_INTERFACE, column D_ATTRIBUTE1.
ORA-01843: not a valid month



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Fill the FBDI template with transaction type as "Miscellaneous Receipt"
2. Generate the csv.
3. Run "Load Interface File for Import" process for the above generated csv files.
4. Submit "Manage Inventory Transactions" process which ends with above mentioned error.

 

Changes

 

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
Changes
Cause
Solution
References


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