My Oracle Support Banner

Cant Use A Synonym As A Table Name In Data Properties When Creating New General Level (Doc ID 2129568.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Goal

Customer is trying to create a new general level called t_ep_pitem_parent

He has created a synonym t_ep_pitem_parent that points to table t_ep_pitem_child

When they try to create the general level in the business modeler, the synonym t_ep_pitem_parent is not visible in the list of values. Initially it was thought that it was a permission issue but they say that the permissions of the synonym should be granted already. The user is the Demantra schema owner DM that is creating the level. The synonym is owned by dm, and so is the target table. All the permissions should be high enough. When they try some simple pl/sql using the synonym instead of the table name they can update, delete, select, and insert into the synonym.

But they do see that configuration for seeded t_ep_cto_parent uses a synonym. It is a synonym for t_ep_cto_parent that points to t_ep_cto child. This is a seeded one

So does that mean that there is the limitation on the level creation tool that it cannot see a synonym that a user has created, and can see and use only the ones that oracle has created like in the case of t_ep_cto_parent ?


 

Solution

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
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.