My Oracle Support Banner

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:

Oracle Transportation Management - Version 6.4.3 and later
Information in this document applies to any platform.

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

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.