Getting Errors When Running Create_all.sh on pluggable database for 6.4.3 Installation (Doc ID 2759691.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Getting errors when running create_all.sh in Pluggable Database

After installing OTM643 application software, when running "create_all.sh" file to create master data in OTM database we are getting lot of unexpected errors w.r.t reportowner.

Attached log file for your reference!

ERROR
-----------------------

Creating REPORTOWNER footprint triggers...
SCHEMA NAME IS REPORTOWNER
Running reportowner_grants...
Creating REPORTOWNER comments...
COMMENT ON TABLE REPORT_T IS 'The REPORT table contains the list of standard and customized reports. One record per report.'
  *
ERROR at line 1:
ORA-00942: table or view does not exist


COMMENT ON COLUMN REPORT_T.REPORT_GID IS 'GC3 Global indetifier for the entity. Is created by concatenating Domain Name,"." and XID.'
  *
ERROR at line 1:
ORA-00942: table or view does not exist


COMMENT ON COLUMN REPORT_T.REPORT_DESC IS 'Report description.'
  *
ERROR at line 1:
ORA-00942: table or view does not exist


COMMENT ON COLUMN REPORT_T.REPORT_GROUP_GID IS 'GC3 Global indetifier for the entity. Is created by concatenating Domain Name,"." and XID.'
  *
ERROR at line 1:
ORA-00942: table or view does not exist


COMMENT ON COLUMN REPORT_T.DOMAIN_NAME IS 'Domain of the User. Is used for creating the GID.'
  *
ERROR at line 1:
ORA-00942: table or view does not exist



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run create_all.sh

Cause

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