My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.




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

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