My Oracle Support Banner

WMS Rule With Customer Number As Parameter Are Getting Created Incorrectly In R12 (Doc ID 1567732.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Label Printing

ACTUAL BEHAVIOR
---------------
Label format rule “package” is created incorrectly in R12 when rule is based simply on customer number.

Note: We are upgrading from R11.5.10 to R12.1.3

Created the following label format rule:

Type: Label Format
Name: Label Format for – XXXX
Description: Label Format for – XXXX
Return value: S004450.lwl (the label format)

Weight: 100

Restriction:
Seq: 10
Object: Customers
Parameter: Customer Number
Operator: =
Object: Constant Character
Parameter/value: 004450 (the customer account number)

Compile the rule.

Behind the scenes, WMS creates a package called WMS_RULE_YYYY (where YYYY is the rule_id for the rule).


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create label format rule:

Weight: 100

Restriction:
Seq: 10
Object: Customers
Parameter: Customer Number
Operator: =
Object: Constant Character
Parameter/value: 004450 (the customer account number)

2. Compile the rule.

3. Review the Rule package created.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.