WMSRULEF Cannot Enable Task Type Assignment Rule With SQL Expression, 'The package for this rule failed to generate ...' (Doc ID 820046.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Warehouse Management - Version: 11.5.10.2 to 12.1.2 - Release: 11.5.10 to 12.1
Information in this document applies to any platform.
FORM:WMSRULEF.FMB - Define WMS Rules

Symptoms

When attempting to enable a Task Type Assignment WMS rule in WMS Rules form (WMSRULEF), the
following error occurs.

The rule has a restriction based on a SQL expression as below:
Operator: =
Object: Expression
Parameter/Value/LOV: <any valid SQL statement>
.
The problem occurs with Source Locator-Locator Identifier parameter.
The problem does not occur with Source Subinventory-Subinventory Name parameter.
.
Examples: (with dummy rules)
1) Able to compile a rule as below:
Seq Object Parameter Oper. Object Parameter/Value/LOV
10 Source Subinventory Subinventory Name = Expression select 1 from dual
.
2) Cannot compile a rule as below:
Seq Object Parameter Oper. Object Parameter/Value/LOV
10 Source Locator Locator Identifier = Expression select 1 from dual

ERROR
"The package for this rule failed to generate. Please check the restrictions for possible syntax
errors.
"

STEPS
The issue can be reproduced at will with the following steps:
1. Go to WMS Rules definition form
Warehouse Manager: (N) Setup : Warehouse Configuration : Rules : Warehouse Execution : Rules
2. Create a Task Type Assignment WMS rule with the following restriction:
Seq Object Parameter Oper. Object Parameter/Value/LOV
10 Source Subinventory Subinventory Name = Expression select 1 from dual
3. Save
4. Enable the rule
5. See no error is raised
6. Disable the rule
7. Override fields Object and Parameter, and then repeat the same for the remaining fields:
Seq Object Parameter Oper. Object Parameter/Value/LOV
10 Source Locator Locator Identifier = Expression select 1 from dual
8. Save
9. Enable the rule
10. See the reported error

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