Detail

This script is present under the $ALLOCHOME/batch folder.

The temporary tables which are impacted by the AlcDailyCleanUp process are as follows:

Allocation session tables:

• ALC_SESSION_SIZE_PROFILE_RATIO

• ALC_SESSION_SIZE_PROFILE

• ALC_SESSION_QUANTITY_LIMITS

• ALC_SESSION_ITEM_LOC_EXCL

• ALC_SESSION_ITEM_LOC

• ALC_SESSION_GID_PROFILE_LIST

• ALC_SESSION_GID_PROFILE

Worksheet session tables:

• ALC_WORK_SESSION_ITEM_LOC

• ALC_WORK_SESSION_ITEM_ALL

• ALC_WORK_SESSION_ITEM

Temporary tables:

• ALC_LOAD_TEMP

alc_calc_destination_temp

alc_calc_need_temp

alc_calc_rloh_temp

alc_calc_qty_limits_temp

alc_calc_rloh_item_temp

alc_merch_hier_rloh_temp

alc_calc_source_temp

alc_calc_need_dates_temp

Allocation approval tables:

• ALC_SYNC_HEADER_TEMP

• ALC_SYNC_DETAIL_TEMP