Enable a store to use available-to-promise (ATP) inventory

Develop > Controller layer > Application developer > Order Management subsystem > Inventory allocation

Enable a store to use available-to-promise (ATP) inventory

During the process of publishing a store, the developer can enable the store to use the available-to-promise (ATP) inventory capabilities. For stores, the developer can choose to enable ATP or not, except for the demand chain reseller hosted store.

Procedure

Edit the INVENTORYSYSTEM column in the STORE table. If INVENTORYSYSTEM is set to be -1, the store will be enabled for ATP.

Use the WebSphere Commerce Accelerator to populate the following inventory fulfillment tables.

BASEITEM

BASEITMDSC

ITEMSPC

For more information about populating these inventory tables, see Part 4: Creating inventory information in the Create catalog assets topic.
In the WebSphere Commerce Accelerator, the BASEITEM, BASEITMDSC, and ITEMSPC inventory tables are handled by the Product Management tool. When you create a new product in the WebSphere Commerce Accelerator, these inventory tables are automatically populated, as required. However, if you have existing catalog entries and these inventory tables are not populated, you might need to manually populate the tables using the massload utility.
When these tables are populated, the store can use these ATP functions:

ATP functionality of Find Inventory

Ad Hoc Receipt

Adjust Quantity

Expected Inventory Records

Establish the behavior of order capture checks that are made during the order capture process by editing the INVENTORYOPFLAGS column in the FFMCENTER table. The program code uses the binary bits in this column individually; however, enter one decimal integer to represent all the bit settings. Complete the chart below and enter the resulting integer into the field.
To use the full capabilities of ATP inventory, you should enter a result of 0 or 1. Other results will limit the ATP inventory functions.

Flag Operation Enter a value
1 Enter a value of 0 to have operations accept single order items, or enter a 1 to have operations accept multiple order items.
2 Enter a value of 0 to have inventory always checked, or enter a 2 if you want inventory never checked and have the check operation always appear to succeed.
4 Enter a value of 0 if you want the allocate operation to check inventory and allocate it. Or, enter a 4 if you want the allocate operation to check inventory, but not actually allocate it (the allocate operation appears to succeed if the check succeeds).
8 Enter 0 if you want backordering operations, or enter an 8 if you want the backorder operation to always fail so no inventory is ever backordered.
Enter the sum of the values you have entered in the rightmost column. This sum is the integer you should enter in the INVENTORYOPFLAGS column Sum =

Specify allocation offsets to modify the time frames used to determine inventory allocation by editing the following columns in the STORE table:

Column name Description
MAXBOOFFSET The maximum number of seconds that an item can be backordered. If the estimated availability time for a backordered order item exceeds the number of seconds into the future specified in this column, the availability date will automatically be set to this many seconds into the future. Thus, an item cannot be backordered longer than the interval specified here. The default value is 7776000 seconds, which equals 90 days.
DEFAULTBOOFFSET When an estimated availability time cannot be determined for a backordered order item, by default, it will be set to the number of seconds into the future that are specified in this column. The default value is 7776000 seconds, which equals 90 days.
ALLOCATIONOFFSET Amount of time before the requested ship date when inventory allocation should be performed. This time period provides a buffer for the store to reserve the inventory to the order and also to allow for enough time to obtain inventory should there be an insufficient amount. (See REQUESTEDSHIPDATE column in the ORDERITEMS table.) The default value is 86400, which equals 1 day.
MAXFOOFFSET The maximum period of time that can be requested for a future ship date after the date when the requested ship date is entered. (See REQUESTEDSHIPDATE column in the ORDERITEMS table.) The default value is 7776000 seconds, which equals 90 days.

Results

It should be noted that the migration from non ATP inventory to ATP inventory is not supported for stores

Related concepts

Store publish process
Available to promise (ATP) inventory allocation
Inventory

Related tasks

Create expected inventory records
Create ad hoc inventory receipts
Adjust inventory quantity

+
Search Tips | Advanced Search

Flag	Operation	Enter a value
1	Enter a value of 0 to have operations accept single order items, or enter a 1 to have operations accept multiple order items.
2	Enter a value of 0 to have inventory always checked, or enter a 2 if you want inventory never checked and have the check operation always appear to succeed.
4	Enter a value of 0 if you want the allocate operation to check inventory and allocate it. Or, enter a 4 if you want the allocate operation to check inventory, but not actually allocate it (the allocate operation appears to succeed if the check succeeds).
8	Enter 0 if you want backordering operations, or enter an 8 if you want the backorder operation to always fail so no inventory is ever backordered.
	Enter the sum of the values you have entered in the rightmost column. This sum is the integer you should enter in the INVENTORYOPFLAGS column	Sum =

Column name	Description
MAXBOOFFSET	The maximum number of seconds that an item can be backordered. If the estimated availability time for a backordered order item exceeds the number of seconds into the future specified in this column, the availability date will automatically be set to this many seconds into the future. Thus, an item cannot be backordered longer than the interval specified here. The default value is 7776000 seconds, which equals 90 days.
DEFAULTBOOFFSET	When an estimated availability time cannot be determined for a backordered order item, by default, it will be set to the number of seconds into the future that are specified in this column. The default value is 7776000 seconds, which equals 90 days.
ALLOCATIONOFFSET	Amount of time before the requested ship date when inventory allocation should be performed. This time period provides a buffer for the store to reserve the inventory to the order and also to allow for enough time to obtain inventory should there be an insufficient amount. (See REQUESTEDSHIPDATE column in the ORDERITEMS table.) The default value is 86400, which equals 1 day.
MAXFOOFFSET	The maximum period of time that can be requested for a future ship date after the date when the requested ship date is entered. (See REQUESTEDSHIPDATE column in the ORDERITEMS table.) The default value is 7776000 seconds, which equals 90 days.