My Oracle Support Banner

ORA-01843: not a valid month error in Install Base (Doc ID 1291437.1)

Last updated on DECEMBER 04, 2020

Applies to:

Oracle Installed Base - Version 12.1.2 and later
Information in this document applies to any platform.


On : 12.1.2 version and above, Support Codes
While trying to create IB instance manually - receive error on the page while saving the record.
This error is also seen during the transaction interface process.
The shipment and WIP job Completion transactions are failing with error. But they get interfaced when they are resubmitted.
the following error occurs.

ORA-01843: not a valid month in Package CSI_ITEM_INSTANCE_GRP Procedure CREATE_ITEM_INSTANCE...

The issue can be reproduced at will with the following steps:
1. Oracle Install Base Agent User > Item Instance > Create


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.