Unable To Create Public Synonyms For Custom Report Package. (Doc ID 1613698.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

01. The Report Designer Guide (Adding Custom Packages section) of Page 4-1 (pdf page number - 41/64) is being referred

02. It lists the below:

To add a custom package for use with query templates, the report designer:

Creates the PL/SQL package specification and the package body definition in the Oracle Transportation Management reportowner DB schema

Compiles both the PL/SQL package specification and body to make sure the code is error free

Provides grants and permissions so Oracle Transportation Management users can access the custom package. The following scripts are provided under the installation and should be run as reportowner
.
/glog/oracle/script8/reportowner_grants.sql
/glog/oracle/script8/create_public_synonyms.sql

03. All the above steps were done , but the create_public_synonyms.sql under the reportowner schema is erroring

ERROR
-----------------------
SQL> @create_public_synonyms.sql

USER_WS_REPORT_ACCESSORA-01031: insufficient privileges
REPORTORA-01031: insufficient privileges
REPORT_COMMON_PROPERTIESORA-01031: insufficient privileges
REPORT_CONTROLORA-01031: insufficient privileges
REPORT_EMAILORA-01031: insufficient privileges
REPORT_GROUPORA-01031: insufficient privileges
REPORT_LOGORA-01031: insufficient privileges
REPORT_LOG_PARAMETERORA-01031: insufficient privileges
REPORT_PARAMETERORA-01031: insufficient privileges
REPORT_PRINTORA-01031: insufficient privileges
REPORT_RESTRICT_FROM_LEVELORA-01031: insufficient privileges
REPORT_SETORA-01031: insufficient privileges
REPORT_SET_DETAILORA-01031: insufficient privileges
REPORT_TEXT_TEMPLATEORA-01031: insufficient privileges
REPORT_EMAIL_SEQUENCEORA-01031: insufficient privileges
RPT_GENERALORA-01031: insufficient privileges
RPT_BOLORA-01031: insufficient privileges
BOL_HEADER_BOVORA-01031: insufficient privileges
INVOICE_ROUTE_BOVORA-01031: insufficient privileges

Changes

Cause

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