WMS Label Format Rule getting Created Incorrectly when Customer Name Is Used as a Parameter (Doc ID 1574605.1)

Last updated on JUNE 10, 2016

Applies to:

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

Symptoms

I receive "The package for this rule failed to generate. Please check the restrictions for possible syntax errors" when attempting to create a new rule for Type Label Form.

This happens  when Customer Name Is Used as a Parameter in Restrictions Tab on Rules form.

There is an alias of "hc.party_id" in the query, but the table hc doesn't exist in the from clause.

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