Some Forms Fail With Error "ORA-06508: PL/SQL: could not find program unit being called ORA-01403: no data found"

(Doc ID 1442796.1)

Last updated on AUGUST 24, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.3.3 and later
Information in this document applies to any platform.
Checked for relevance on October 22nd, 2013

Symptoms


After upgrading to RMS 13.2.3.3, the following error is received:

ORA-06508: PL/SQL: could not find program unit being called
ORA-01403: no data found


Steps to Reproduce:
1. Navigate to Action -> Organizational Hierarchy; click Warehouse; click Edit.  Note the error.
2. Navigate to Action -> Organizational Hierarchy; click Store; click Edit. Note the error.
3. Navigate to Control -> Supplier. In the Action field select Edit. In the Supplier Level field select Supplier Site. In the Supplier Site field enter value for a supplier site and press tab. Click OK. Note the error.

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