New Tables for Dynamic Default

If you are upgrading, this list of the new tables used for dynamic default can be helpful to you for data migration and troubleshooting. The following new tables were added to capture the deleted items between configuration sessions:

• S_ASSET_DEL

• S_ORDER_ITM_DEL

• S_QUOTE_ITM_DEL

When the user confirms deleting an item from the configuration session, a new record for the deleted item is inserted in the relevant table. During reconfiguration, the configurator logic checks the tables so that deleted items are not re-included during reconfiguration.

Using the S_ASSET_DEL Table with a Set Preference Constraint

When you deploy a new version of a customizable product that contains a new Set Preference constraint, you may not want this constraint to automatically add a new component to any existing assets when you modify them.

To do this, you must insert the appropriate record into the S_ASSET_DEL table for all existing assets affected by default products.

Observe the following guidelines:

1. Review all existing active assets affected by default products.

2. Add an entry to the S_ASSET_DEL table at the parent asset level, populating the following columns:

   • ASSET_ID. Parent asset (not Root) for which the child item, selected by the default product, has been explicitly removed.

   • PRODUCT_ID. ID of the product that must not automatically default.

   • PORT_ID. This is a reference ID. It belongs to the relationship object of the customizable product that you do not wish to be affected by an automatic default product.