Monday, April 15, 2013

Entity Object based on Synonym issue

We have HR and Finance Database , in the schema of Hr we need to create an Entity Object Based on Synonym in Financial database.
when running wizard to create ADBC , we can't see any Eo or Vo !
I will explain how to reproduce the problem and how to solve it

The Design of the Database :
  • Ben_View is DB View in Finance
  • HR have the privilege to select data from Ben_View

Now start ADFBC wizard

Choose connection

choose Synonym only

Create Entity Object

Create View Object

Create Application Module

The result is ....... !!!
No Entity Object or View Object  , just Application module !

I have tried repeating the above steps with another synonyms and the result was good and normal !

ok , now let's look at Ben_View , Ben_View composed of two query and this is the difference between it and other synonyms 

the solution is very easy , we need to add primary key for Ben_View when creating EO.
i will create EO and add PK to it 

Now we can see EO inside the project

No comments:

Post a Comment