My Oracle Support Banner

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 NOVEMBER 29, 2018

Applies to:

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


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

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?


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

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