Implementation
There are six different batch executables, each executable calling the appropriate method from the above ALC_HIER_LVL_INV_SNAPSHOT_SQL package. Clarifications on the batch functionality:
-
Each batch should state success or failure, whether an exception is caught or not.
-
There is no need for restart recovery, intermittent commits, or threading.
-
Login validation standard logic used by the scheduled alloc program should be applied here as well.
-
The programs are run sequentially. The correct order is documented in the Merchandising batch schedule and controlled by whichever scheduling tool used at a particular customer.
-
There are no special security requirements for the program. Any user who can log into the Allocation product can have the ability to run the batch processes.