While Accessing RMS Forms an Error "ORA-04062: Signature of Package "RMS.SYSTEM_OPTIONS_SQL" Has Been Changed" Occurs (Doc ID 1382551.1)

Last updated on AUGUST 10, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.3.5 and later
Information in this document applies to any platform.

Goal

Scenario 1:  After upgrading to Retail Merchandising System (RMS) 13.1.3.6,

1. Log in to RMS
2. Select Items -> Items
3. Select any option (e.g., Edit)
4. Enter item in [itemfnd] screen and click OK
5. Note the following error:

ORA-04062 : signature of package "RMS 13.SYSTEM_OPTIONS_SQL" has been changed." appears when screen is being validated.



Scenario 2:
   After implementing the SYSTEM_OPTIONS_SQL script, and while accessing the RMS forms like LOTR or UDA, the following error is thrown :

ORA-04062: signature of package "RMS.SYSTEM_OPTIONS_SQL" has been changed returned by forms library unit P_HIER_FILTER.SET_FORM.

 

How can we resolve these issues?

Solution

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