Missing Seed Records In WMS_DB_OBJECT_JOINS For Picking Rules In WMS Rules Form

(Doc ID 2090130.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle Warehouse Management - Version 12.1.2 and later
Information in this document applies to any platform.



After a WMS rule restriction is created on the WMS Rules form (WMSRULE) with object Move Order Line,
see parameter Move order line id is added, but the additional join is not generated in the package.

Expected Behavior

Expect no join missing in the generated package.

The issue can be reproduced at will with the following steps:
1. Go to: Warehouse Manager
2. Navigate to: Setup > Warehouse Configuration > Rules > Warehouse Execution > Rules
2. Query Rule name
3. See Object Expression is incorrect.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms