Missing Seed Records In WMS_DB_OBJECT_JOINS For Picking Rules In WMS Rules Form (Doc ID 2090130.1)

Last updated on NOVEMBER 10, 2016

Applies to:

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

Symptoms

Problem

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.

Changes

 

Cause

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