Request to Increase Goods Owner Character Limit in Wave Plan Rule

I would like to ask regarding the Goods Owner field in the Wave Plan Rule menu.

Currently, the field seems to have a maximum limit of 5 Goods Owners. Would it be possible to increase the character/field limit so that we can configure more than 5 Goods Owners?

Please let me know if this is configurable or if there is any limitation on the system side.

There is no configuration available to restrict a wave plan rule to a single Goods Owner when the field is set to *.

The current behavior, where a single wave can contain orders from multiple Goods Owners, is the standard system behavior.

If you would like to limit the wave plan to a specific Goods Owner, a separate wave plan rule with the required Goods Owner will need to be created.

As for performance concerns, there is no fixed maximum limit for the number of Goods Owners that can be configured in this field. The main factor affecting performance would be the number of order details being processed.

Based on the Product Team's recommendation, we suggest not exceeding 1,000 order details per wave, as any higher volume may cause performance degradation during wave creation and allocation process.

To proceed with this change, the table column will need to be modified. Kindly apply the change in the TEST environment first and perform a full wave creation and allocation to confirm that there are no issues before proceeding with the PROD deployment. Below is the script required to perform in the DB.

Connect to the 4 DBs to run the scripts below: WMS TEST DB, WMS TEST ARC DB, WMS PROD DB, WMS PROD ARC DB.

ALTER TABLE RUL_WAVE_PLAN
MODIFY COLUMN customerId varchar(50)

--Change 50 or to the desired length. BY default is 30

UPDATE bsm_data_dictionary_field

SET fieldType = 'varchar(50)'

WHERE organizationId ='MLS_XXX'

and tableName = 'RUL_WAVE_PLAN'

  AND fieldname = 'customerId'

--set fieldType value must be the same as the modify column value. If MODIFY COLUMN customerId is varchar(50) then SET fieldType = 'varchar(50)'