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 15, 2021

Applies to:

Oracle Retail Allocation Cloud Service - Version NA and later
Information 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


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