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 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 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!