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 FEBRUARY 21, 2023

Applies to:

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

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