My Oracle Support Banner

ORA-06550 and ORA-00942 Errors During the Deployment of Patch 31314781 (Doc ID 2691770.1)

Last updated on JULY 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 19.0 to 19.0 [Release 19.0]
Information in this document applies to any platform.

Symptoms


During the deployment of the <Patch 31314781> on the RMS database, the Control Script, merch_19.0.005_batch_schedule.sql, throws ORA-00942 error.
 

Error

"ERROR at line 1488: ORA-06550: line 27084, column 12: PL/SQL: ORA-00942: table or view does not exist"

Steps to Reproduce


1. As part of the deployment of the <Patch 31314781> run the script merch_19.0.005_batch_schedule.sql.
2. Notice the ORA error.

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
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.