Schedule Allocations Is Failing When Release Date In ALC_ITEM_LOC Is In The Past
(Doc ID 2798992.1)
Last updated on AUGUST 23, 2023
Applies to:
Oracle Retail Allocation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
When the schedule allocations batch is running after the initial created day it's failing will the following error:
Manually updating the release date in the ALC_ITEM_LOC table and running the batch the child allocations are created successfully.
Steps To Recreate :
1. Create a schedule allocation to run for a everyday for a week.
2. After saving please note the RELEASE_DATE on the ALC_ITEM_LOC table it should be equal to VDATE.
3. Move VDATE to the future where the RELEASE_DATE should be less then the VDATE.
4. Run the ALC_SCHEDULE_JOB and notice that it fails with error.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |