AIP Batch Failed at generate_store_sched_process.sh 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 JULY 06, 2016

Applies to:

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

Symptoms

In Oracle Advanced Inventory Planning (AIP), the generate_sched.sh 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 generate_store_sched_process.sh script when Off Supply Date is 12/28/9999

Cause

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 hundreds of Community platforms