My Oracle Support Banner

AIP Batch Failed at with a Date Out of Range Error: "ERROR : ORA-01841: (full) year must be between -4713 and +9999, and not be 0" Due to Off Supply Date (Doc ID 2150955.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Retail Advanced Inventory Planning - Version 14.1 and later
Information in this document applies to any platform.


In Oracle Advanced Inventory Planning (AIP), the script fails when Off Supply Date is a System High Date. There should be error trapping at the point where off-sale date is being loaded; the batch and the system should not allow it. The error should not be discovered only during the execution of generate schedule.

For example:  Bad dates causes: AIP Batch failed at script when Off Supply Date is 12/28/9999


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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