My Oracle Support Banner

FA:SCM:INV: Error on table INV_TRANSACTION_LOTS_INTERFACE, column LOT_EXPIRATION_DATE. ORA-01839: date not valid for month specified (Doc ID 2533513.1)

Last updated on OCTOBER 26, 2020

Applies to:

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

Symptoms

Loading inventory transactions with FBDI fails with the below error.

Log file states 0 records were loaded.

ERROR
---------------
Record 1: Rejected - Error on table INV_TRANSACTION_LOTS_INTERFACE, column LOT_EXPIRATION_DATE.
ORA-01839: date not valid for month specified

STEPS TO REPRODUCE
-----------------------------------------
1. Download 'Inventory Transaction Import' template
2. Enter data in template file
3. Generate CSV (zip file)
4. Upload the CSV zip file to the designated location in the Oracle Cloud: File Import and Export --> Upload file to following account: scm/inventoryTransaction/import
5. Move Data into the Inventory Management Interface tables: Scheduled Processes --> Schedule New Process --> Load Interface File for Import --> Create Inventory Transactions.
6. Scheduled Processes --> Schedule New Process --> Manage Inventory Transactions.

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.