My Oracle Support Banner

Labels Are Not Printing In Production (Doc ID 2545956.1)

Last updated on JULY 08, 2020

Applies to:

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

Goal

Labels are not printing in Production. This is a global issue. A few Label Format Rules were disabled and deleted. The below 3 packages are now invalid in Prod -

WMS_RULE_LABEL_PKG1
WMS_RULE_LABEL_PKG2
WMS_RULE_LABEL_PKG3  

and we are getting the below error -

LINE/COL ERROR
-------- -----------------------------------------------------------------
63/10    PL/SQL: Statement ignored
63/10    PLS-00201: identifier 'WMS_RULE_12539.GET_LABEL_FORMAT' must be
         declared

Rule ID 12539 ---is one example of one of the rules deleted by the user in Production.

The rule - WMS_RULE_12539 seems to be associated with the above packages.

Super User is now trying to re-create  these rules, how do we ensure we link these rules to the above packages? Is there a program - Re-generate all rules?

Solution

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
Goal
Solution


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