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
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.
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
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